Re: instance shutdown problem ? (please help)

ut i need to know the complete procedure. would you know the complete statement and procedure to generate control files. do we have to change the db/sid name ? --- Arup Nanda [EMAIL PROTECTED] wrote: Yes, the poster clarified that it was a missing controlfile. I have a reply that catered to

Re: Replication Manager

: 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 ORACLE-L FAQ: http://www.orafaq.com -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services

Re:

: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E

The future DBAs?

in that field can progress to the next logical career move. Guess which profession's logical career move is database administrator? See the excerpt from the webpage here in the attachment as a picture. I just couldn't resist posting it here. May be they are referring to SQL Server DBAs? Arup Nanda

Re: instance shutdown problem ? (please help)

? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Sat, 23 Nov 2002, Arup Nanda wrote: Well, system does not do a shutdown abort. Oracle finds a problem and then instance aborts. A few things you can do here. (1) See if a trace file is generated around that time in user_dump_dest

Re: A way to restore a DB

, tables, populate control tables, etc and then refresh it from the regular sources. This works out to be longer but less expensive. HTH. Arup Nanda www.proligence.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, November 24, 2002 12:23 PM

Re: Storing of number datatype in table

this, not from other cleint machines. HTH Arup Nanda www.proligence.com From: Stephane Faroult [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Storing of number datatype in table Date: Fri, 22 Nov 2002 23:43:43 -0800 MIME

Re: instance shutdown problem ? (please help)

and service in a command prompt window using oradim comamnd. I am not sure of the options; but the oradim command gives a help. At some point you would hit a problem that is decipherable. Please let us know what came out of it. HTH Arup Nanda www.proligence.com From: john [EMAIL PROTECTED

Re: Storing of number datatype in table

The number is more than the numwidth specified. Try this SQL set numwidth 13 SQL select trn_id from trnid; Your numwidth is perhpas defined as 9; so anything of more precision is displayed as exponetial notation; internally all numbers are stored the same. HTH Arup Nanda www.proligence.com

Re: find the system process for an oracle session

Ruth, If you mean the operating system process id, it's in v$session field PROCESS. the following will tel you the oracle server process select spid from v$process p, v$session s where s.sid = your sid from v$session and p.addr = s.paddr HTH Arup Nanda - Original Message

Re: Identifying indexes

the constraint but rather to design a better index. HTH Arup Nanda www.proligence.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 22, 2002 1:39 PM I am trying to find out what indexes are in the database only for performance

Re: Oracle is a time machine!!

FAQ: http://www.orafaq.com -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

Re: Urgent: ORA-02067 transaction or savepoint rollback required (Distributed transaction)

anywhere; I found this by accident. Hope this helps. Arup Nanda www.proligence.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 21, 2002 9:18 AM (Distributed transaction) Gurus, Desperately need some ideas to solve this one

Re: export in full mode but exclude particular user?

Title: RE: export in full mode but exclude particular user? It's the same - exu81obj and exu8usr. HTH Arup Nanda www.proligence.com - Original Message - From: Chris Stephens To: Multiple recipients of list ORACLE-L Sent: Thursday, November 21, 2002 9:18 AM

Re: Dynamic views

Title: Dynamic views Sure, You can write an INSTEAD OF trigger on the view that inserts into the right table. Arup Nanda www.proligence.com - Original Message - From: david hill To: Multiple recipients of list ORACLE-L Sent: Wednesday, November 20, 2002 1:48

Re: to_date function and NLS settings on client

. Have you tried this: select ... from ... where trunc(datefield1) = '01.10.1950' or select .. from .. where datefield1 between '01.10.1950' and '02.10.1950' Hop this helps. Arup Nanda www.proligence.com - Original Message - From: Daiminger, Helmut To: Multiple recipients

<    1   2   3   4