ORA-03113: end-of-file on communication channel. HELP !

Hi, We have a Unix user dcclive ( oracle database user ops$dcclive - os authentication ). I am able to connect my database using TNS Alias but not directly. when i start the database in the following way : After logging in as dcclive ( C Shell ), su -u oracle ( Korn Shell ) and started the d

RE: When was analyze run last?

Hi Smith, check LAST_ANALYZED column of DBA_INDEXES or DBA_TABLES I believe it shouldb be there in ver. 7.3. HTH Arul. > -Original Message- > From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] > Sent: 08 July 2002 17:33 > To: Multiple recipients of list ORACLE-L > Subject: When w

How to administer OAS at server without using Browser ?

Hi DBAs, I would like to know the ways we can manage OAS ( ver. 4.0.8 ) without using Browser. For example, how do we create DADs without using browser admin utility. Is there any Oracle utility available to use at OS prompt? Possible ? Thanks, Arul. -- Please see the official ORACLE-L FAQ: htt

RE: How to store Value greater than 38 digits ?? Help !!

Hi DBAs, Thanks for the prompt replies. We have solved it using Java in the stored procedure. We created a java function which will manipulate the numeric value and return it as string. This java function is wrapped into a PL/SQL function which returns Varchar2 !.

Re: SELECT statement...

delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the off

SQL Loader:How to load data with carriage return embedded

Hi DBAs, I have a flat file with Varchar2 data spread across lines with carriage return.. I have tried using the following but in vain. =  LOAD DATA  INFILE 'test.dat' "str X'0c0a'"  INTO TABLE arul.test1 FIELDS TERMINATED BY "~" optionally enclosed by '"' trailing

[no subject]

-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

Re: A doubt in 9.0.1.0.0 database..

n the admin guide,. joe Arul kumar wrote: > Hi DBAs, > > I got a problem in Rollback Segments.. > > This is the setting for UNDO ( Rollback ) in my init file... > > undo_management=AUTO > undo_retention=900 > undo_suppress_errors=FALSE > undo_tablespace=UNDOTBS > >

Another doubt in 9.0.1.0.0 database..

Hi DBAs, While reducing the JAVA_POOL_SIZE in initfile , i observed that minimum it takes 8M and not less than that. If we dont specify this parameter, default value it takes as 20 M !!. If there is no JAVA related stuff in my application / database..., why should i have this space allocated.

A doubt in 9.0.1.0.0 database..

Hi DBAs, I got a problem in Rollback Segments.. This is the setting for UNDO ( Rollback ) in my init file... undo_management=AUTO undo_retention=900 undo_suppress_errors=FALSE undo_tablespace=UNDOTBS While querying V$waitstat, got the foll. : CLASS    COUNT TIM

Locally Managed Tblsp. Vs Dictionary Managed Tblsp.

based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

Re: Data Archiving

Hi Nirmal, Export/Import sounds good for this. I think u can give a try with DIRECT=Y option in exp utility (for faster export !). I am not sure abt this option in 7.3.. do give it a try. Arul. I am not sure abt this Nirmal Kumar Muthu Kumaran wrote:   Hi all, New year Greetings. We need to archi

Why LOGGING in Indexes(!)?

, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET

Re: Oracle database users

e and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ:

NLS Support in Oracle..

Hi Gurus, We want to develop a multi-lingual application where the user would have entered some data(NVARCHAR2) and some other user would like to view it in a different  language. So, I wud like to know how to enter NVARCHAR2 data in any language and query the same data in any  other language.  H

Re: ms acces

nd are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http:

Reg. MTS Connections..

. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Last Update

lude a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > = > Eng. Christian Trassens > Senior DBA > Systems Eng

offline- Returning pl/sql table from a proc. dynamically..

g, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET: [EMAIL PROTECTED] Fat City Networ

Any idea about DIANA in Oracle...??

taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET: [EMAIL PROTECTED] Fat City Network Services

Re: Temp

his message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET: [EMAIL PROTECTED] Fat City Ne

offline - Dynamic SQL doubt...

sed on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

Re: How to avoid sorting in the select statement?

m). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET: [EMAIL PROTECTED] Fat City Network Services--

Re: Dead Lock in Temporary Tables 8.1.6 ... HELP !

reports the error only > for the first time after a connection is established. Why ? > > I am sure there was no other user using that table at the time of > procedure execution. > > Thanks in advance. > > Regards, > Arul. -- Please see the official ORACLE-L FAQ: http://w

AFTER LOGON ON SCHEMA Trigger 8.1.6 .. HELP!

Hi Everybody, I am using oracle 8.1.6 db. I want to create a trigger which fires for every new object created in a particular schema. Basically,  i want to grant privileges for this newly created object  to Roles, Users dynamically as and when the new object created. When i tried , the trigger  g

Dead Lock in Temporary Tables 8.1.6 ... HELP !

me of procedure execution. Thanks in advance. Regards, Arul. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Re: Full database Export..

ECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official O

Re: NLS_DATE_FORMAT not effective..help!

ld be 03/20/2001 ) > > What went wrong? Did anyone faced similar problem? > Do i need to modify registry in client PCs ( Win 9X)...?? > > Thank You. > Arul. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Arul kumar > I

Re: NLS_DATE_FORMAT not effective..help!

it is giving me the date as > > SELECT SYSDATE FROM DUAL; > > 03/20/200 ( it should be 03/20/2001 ) > > What went wrong? Did anyone faced similar problem? > Do i need to modify registry in client PCs ( Win 9X)...?? > > Thank You. > Arul. > > -- > Please

NLS_DATE_FORMAT not effective..help!

ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yours

Disabling Constraints in a Schema!..??

ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

Offline - ORACLE ODBC Err.

official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Offline doubt - Exclusive OR operator in PL/SQL??.

work done.? Note - Oracle Database Version - 7.x Thank You. Arul. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

Re: Creating indexes in seperate tablespace

Hi John, Here is the answer: CREATE TABLE salgrade    ( grade  NUMBER  CONSTRAINT pk_salgrade     PRIMARY KEY     USING INDEX TABLESPACE users_a, losal  NUMBER, hisal  NUMBER )    TABLESPACE human_resource    STORAGE (INITIAL 6144 NEXT   

Reg. SPOOL in SQL*PLUS

Hi DBAs, I would like to know the way for specifying a filename dynamically in SQL PLUS. Say, for example The file name should be suffixed with a sequence number available from a SEQUENCE object. ( like SPOOL ||seq1.nextval). Any idea? Thank You, Arul.

Offline doubt - Password checking in Oracle..

take place. Now, my question is : How to validate the user given password as correct or not? (becos Oracle stores password by encrypting it!). Any suggestions will be of great help to me. TIA, Arul. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET