Hello all, I did install toad version 6.3.11.1 on my cpmputer.But the toad cannot make connection to the database, the message error appears...

ing_ora

12-14-2004 09:56 AM
NumbNuts

I wrote the following script: DECLARE type employee is record( LAST_NAME VARCHAR2(15) , FIRST_NAME VARCHAR2(15) , HOURS_WORKED NUMBER(5,2)...

sikyala@comcast.net

12-14-2004 09:09 AM
sikyala@comcast.net

I've got a problem with sending an email with the help of the ORDCOM-Package. Creating the object CDONTS.Newmail is no problem and sending an...

Monika

12-14-2004 02:55 AM
Monika

Now its official :-) http://www.oracle.com/technology/tech/linux/vmware/index.html

Dave

12-14-2004 01:30 AM
Dusan Bolek

Hello Stecal, I am doing my homework..........Reading the Oracle Doc... ----- I can run WebForms through the Web. I can call-up the Reports Web...

ptreves

12-13-2004 11:53 PM
ptreves

Hi, At my customer's windows 2003 server I installed 10g, 10.1.0.2 database with starter database orcl. I am basically a UNIX person. I have...

oracleguru@lycos.com

12-13-2004 08:04 PM
Mark Bole

Hi, I've been asked to come up with a general answer to this question: Comapred to standard oracle, how difficult is 10g RAC to setup, and...

jdevroberto@yahoo.com

12-13-2004 07:52 PM
DA Morgan

Let's say I have a sales organization (denormalized and simplified design): CREATE TABLE salesman (id NUMBER PRIMARY KEY, manager...

Tom Barnes

12-13-2004 06:23 PM
VC

Hi All, Does anyone know how to read a trace/dump file? For example, say I coded the following event to be trapped: LTER SESSION SET EVENTS '1858...

amerar@iwc.net

12-13-2004 06:16 PM
Snewber

Folks, We are running 6 instances of a proprietary application server against an Oracle8 instance with a connection pool of 16 each (for a total of...

Y

12-13-2004 06:12 PM
Yogesh

Hello ecerybody, I have at least three complete set of Oracle 8 Manuals (from Oracle) and many Oracle Press books, with Forms CBTs and Videos (from...

DBA

12-13-2004 04:53 PM
DBA

Please forgive me the re-posting. I first posted this a week ago and got no bites, so thought I'd try again. Oracle 8.1.7.4 on Win2k Recently I...

Ed Stevens

12-13-2004 03:06 PM
Ed Stevens

I am wanting to put together a collection of the demeaning one upmanship comments SYBRAND BAKKER has written in this and related groups. This will be...

Pete

12-13-2004 01:07 PM
joel-garry@home.com

Downloaded the install of 10g. File is 10g_win32_db.zip. Extract the files from the zip. First I tried the setup.exe from the Disk1 folder but...

Lloyd Sheen

12-13-2004 12:24 PM
Dave

I had a 9.0.1 on a win2003 server recently and today I tried to install 10.1.0 on that machine. Somehow deinstallation of 9.0.1 which was oin that...

Christoph Kukulies

12-13-2004 12:05 PM
Ed Stevens

Are there tools available to export a table from Oracle to a CSV file? Either an Oracle tool, or free 3rd party is OK. Les M

lmcphee69@hotmail.com

12-13-2004 10:42 AM
gelewyc@nyct.com

Hi All, I am hving real trouble with this one. Basically I've been asked to crack down on database security. Everyone knows all the passwords...

amerar@iwc.net

12-13-2004 09:17 AM
Pete Finnigan

Hi all, I will deploy a database project to an Oracle server, but I could not figure out which version of Oracle should I get. Here is my...

Murtix Van Basten

12-13-2004 08:24 AM
greatguangong@gmail.com

Hello i have to load characters like ^M ^D . I don't won't to delete them while importing, because i must import 100% of another database. the...

Ralf Bender

12-13-2004 07:32 AM
Ralf Bender

Hi Oracle fanciers, I would like to check numeric data types already in a Java client to be able to react on potential an overflow or underflow...

mattin

12-13-2004 03:41 AM
mattin

"Rafa" <rafa (AT) enterra (DOT) es> wrote Multi posted - answered in another group.

Randy Harris

12-13-2004 02:32 AM
Rafa

chirantan.chakraborty (AT) gmail (DOT) com wrote: I believe the only purpose of MERGE INTO is to perform 'upserts'. There is no provision to...

fitzjarrell@cox.net

12-13-2004 02:18 AM
billiauk@yahoo.co.uk

OMLET -- the premier oracle monitoring solution is now mirrored in the far east and around the globe! www.omlet.org www.okonomiyaki.org

teraknowledgesystems@yahoo.com

12-13-2004 02:09 AM
teraknowledgesystems@yahoo.com

Could anyone shead some light on this problem that I'm faced with. I have a stored procedure that has 2 parameters. The first is the primary key ...

Adrian Scott-Day

12-12-2004 02:58 PM
Noons

hello, i try redirect the export dump directly to a packer program like zip under windows. i must prevent my diskspace there. is there a chance to...

Ralf Bender

12-12-2004 02:25 PM
Noons

Dear DBA, You are cordially invited to test and review our windows native and 100% pure Java Oracle 9i/8i Monitoring Application (OMLET). OMLET...

teraknowledgesystems@yahoo.com

12-12-2004 07:35 AM
teraknowledgesystems@yahoo.com

For some of the readers this could be well know but I asked the very same question a couple of months ago without receving a good answer. Even...

Fabrizio

12-11-2004 03:36 PM
Fabrizio

Hi, Can you help me to find free, good tutorial for Oracle developer. Thanks

ANSWER

12-11-2004 03:33 PM
Dave

Hello, I'm an SQLServer dba and a newbee in Oracle. What "spooling" is (in context of logins, connections or user sessions)? As I suppose it's a...

Vladimir

12-11-2004 11:27 AM
DA Morgan

Is is possible to create automatic startup of 9ias using the Services only (i.e. without starting any components from the command prompt or from the...

Stefan

12-11-2004 09:11 AM
nikhilmistry@yahoo.com

I have been sent a copy of a database and I need to install/mount it on a new server. I have the CTL, DBF and LOG files. Here are the...

Greg Doherty

12-11-2004 08:16 AM
Yang

10.1.0.3.0/RHEL3 I used to run this oem java app "$ oemapp console" on 9i But with 10g => "-bash: oemapp: command not found" I installed 10g with...

robert

12-11-2004 07:06 AM
Denis Do

Hello I want to set unused column: SQL> alter table test set unused column name; alter table test set unused column name * Error in line...

vertigo

12-11-2004 06:17 AM
Howard J. Rogers

Oracle 10g for x86-64 was released Nov 10th. I'm wondering if anyone here have tried it out. Just being curious since I'm a fan of the AMD64...

hastenthunder

12-11-2004 04:56 AM
Eberhard Niendorf

I have oracle 9i database on HP UNIX 11i with automatic undo management. I created undo tablespace to be 1800M. When I look in OEM, storage, it shows...

premmehrotra@hotmail.com

12-10-2004 11:43 PM
niy38

All: A leading Software company in Bangalore, INDIA requires good ORACLE DBA, strong is fundamentals in SPECIALIST ROLE. Please contact me offline...

db2sysc@yahoo.com

12-10-2004 11:13 PM
db2sysc@yahoo.com

Hi all, Environment: Oracle 9i DB server on Solaris 9 (production site) Veritas Netbackup Server on Solaris 9 Oracle 9i DB server on Solaris 9...

Lav Kovacic

12-10-2004 07:44 PM
alcesteatxmissiondot@com.or.net

Please forgive me the re-posting. I first posted this a week ago and got no bites, so thought I'd try again. Oracle 8.1.7.4 on Win2k Recently I...

Ed Stevens

12-10-2004 04:51 PM
Anurag Varma

Greetings, is anyone familiar enough with Financials schema to tell me which datatype is used to hold currency values? I suspect it is...

LineVoltageHalogen

12-10-2004 02:52 PM
LineVoltageHalogen

Hello a well running export script of my database breaks now with EXP-00008: ORACLE-Fehler 604 gefunden ORA-00604: Fehler auf rekursiver SQL-Ebene...

Ralf Bender

12-10-2004 02:34 PM
Ralf Bender

Hi, I've posted this on ORACLE-L - apologies if you're seeing it twice. I've written a search plugin for Firefox to allow you to search Metalink...

mattypenny

12-10-2004 10:24 AM
mattypenny

Hello I've got a big flat file with # as separator. There is a number field which has negative sign at the end or nothing if it is a positive...

Ralf Bender

12-10-2004 06:29 AM
Ralf Bender

Hi all, I was reading the Concepts manual and it says from 9i you have the option of both native and interpreted execution available for...

lambu999@yahoo.com

12-10-2004 04:36 AM
Rauf Sarwar

I have the following structure query in a datawarehouse: select /*+ star_transformation */ from fact, dimensions where <the usual joins> and (x, y,...

asya999@gmail.com

12-10-2004 12:58 AM
asya999@gmail.com

Hi All, we are just about to start a sizable project (1-2TB (disk) EDW with 200+ users) and the client is AIX 5.1 Oracle 9.2. The mostly likely...

peter@peternolan.com

12-09-2004 10:00 PM
HansF

Greetings to the List... Has anyone had any experience installing and running 8.1.7.4 on Win2K3...? Any known pitfalls, etc...? This IS a supported...

Robin_Gustavson@merck.com

12-09-2004 09:45 PM
SomeName

Hi, I have been sent a copy of a database and would like to be able to access it. I copied it to a subdirectory under the oradata directory. I'm...

Greg Doherty

12-09-2004 08:07 PM
Howard J. Rogers

Is it possible to examine/process the Oracle log files to see what updates have occurred to any data between to points in time? I would like to use...

Stuart Smith

12-09-2004 07:30 PM
Howard J. Rogers

When i restart my windows 2000 server with oracle 9 the database do not get startede anymore. I must log in and run the startup command to get the...

kjellern99@yahoo.no

12-09-2004 05:51 PM
ana

hi, i requested to all users please give some information about how to install SAP on windows 2000 PE. or what is the best and easy configuration...

The Rising

12-09-2004 03:19 PM
Andy France