RE: Truncate system tables.

2003-01-08 Thread Bernardus Deddy Hoeydiono
Title: Message Hi Terrian,   hm... hm... I'm thinking   I have one question for you. Can you still connect to the database ? If you can connect the database :   1. export the database using application user. 2. drop the application user. Before drop the user, make sure that the export

RE: Truncate system tables.

2003-01-08 Thread Khedr, Waleed
Title: Message Sorry I meant these are the tables owned by "SYSTEM" in 9.2   Waleed -Original Message-From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08, 2003 2:44 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Truncate system table

RE: Truncate system tables.

2003-01-08 Thread Khedr, Waleed
ailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08, 2003 1:30 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Truncate system tables. SYSTEM not SYS also - Oracle 9.2.0.2 -Original Message-From: Khedr, Waleed [mailto:[EMAIL PROTECTED]] Sent: Wednesday, Ja

RE: Truncate system tables.

2003-01-08 Thread Rachel Carmichael
since when have you ever "respectfully" disagreed with me? :) you are correct, semantically I should have said he cannot rollback the truncate and because he has no backups, he cannot recover from the action either. of course, your recovery does depend on knowing exactly when the truncate took p

RE: Truncate system tables.

2003-01-08 Thread Terrian, Tom (Contractor) (DAASC)
Title: Message SYSTEM not SYS also - Oracle 9.2.0.2 -Original Message-From: Khedr, Waleed [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 1:17 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Truncate system tables. System tables means tables owned

RE: Truncate system tables.

2003-01-08 Thread Paul Heely
  -- Paul     -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Freeman Robert - ILSent: Wednesday, January 08, 2003 10:54 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Truncate system tables. Ok... I've got a copy of 9iAS 9.0.3 f

RE: Truncate system tables.

2003-01-08 Thread Mercadante, Thomas F
: Wednesday, January 08, 2003 10:54 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Truncate system tables. Ok... I've got a copy of 9iAS 9.0.3 for NT I'm wanting to install, but I'll be darned if I can find an install guide anywhere I've looked on OT

RE: Truncate system tables.

2003-01-08 Thread Khedr, Waleed
Title: Message System tables means tables owned by "SYSTEM" or owned by "SYS", just making sure?   Waleed -Original Message-From: Terrian, Tom (Contractor) (DAASC) [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08, 2003 9:19 AMTo: Multiple recipients of list ORACLE-LSub

RE: Truncate system tables.

2003-01-08 Thread Freeman Robert - IL
Title: Message Ok... I've got a copy of 9iAS 9.0.3 for NT I'm wanting to install, but I'll be darned if I can find an install guide anywhere I've looked on OTN and can find an install guide for a SUN and AIX, but no NT. Anyone have any ideas if such a beast exists and if so where?   Rob

Re: Truncate system tables.

2003-01-08 Thread Ora NT DBA
Hi Tom, Nothing I would feel comfortable with.  Be happy that it was new.  I would recomend trashing it and starting over. John Terrian, Tom (Contractor) (DAASC) wrote: Message ummm...I just truncated all of the system tables in a new database (that's not good).  No

RE: Truncate system tables.

2003-01-08 Thread Fink, Dan
I respectfully disagree, you can recover from a truncate. Restore a backup, recover to immediately before the truncate. You cannot rollback a truncate. The database will have to be recreated because there is not a backup. If the tables had been deleted, then committed, the effect would be the same

Re: Truncate system tables.

2003-01-08 Thread Ron Rogers
Tom, There is no respectable way of saying it but "you screwed up." Welcome to the club of the "sharp learning curve of remembrance". Recreate and perform a cold backup immediately. Ron >>> [EMAIL PROTECTED] 01/08/03 09:18AM >>> ummm...I just truncated all of the system tables in a new da

RE: Truncate system tables.

2003-01-08 Thread Mercadante, Thomas F
Title: Message Tom,   wait. laughing.   ok.  I'm better now.   since you havn't really lost anything (just time), just re-create it.     I bet you won't do THAT again!     Tom Mercadante Oracle Certified Professional -Original Message-From: Terrian, Tom (Cont

RE: Truncate system tables.

2003-01-08 Thread Fink, Dan
Title: Message No backup = No recovery! -Original Message-From: Terrian, Tom (Contractor) (DAASC) [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08, 2003 7:19 AMTo: Multiple recipients of list ORACLE-LSubject: Truncate system tables. ummm...I just truncated all

Re: Truncate system tables.

2003-01-08 Thread Rachel Carmichael
you have to recreate, there is no way to recover from the truncate, nothing is written to the rollbacks when do you that. Unless, of course, you want to spend umpty-ump dollars on Oracle's Data Unloader. But if it's a new database, it's probably simpler to recreate. --- "Terrian, Tom (Contractor

RE: Truncate system tables.

2003-01-08 Thread Terrian, Tom (Contractor) (DAASC)
ok -Original Message- Sent: Wednesday, January 08, 2003 10:34 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] you have to recreate, there is no way to recover from the truncate, nothing is written to the rollbacks when do you that. Unless, of course, you want to spend umpty-ump dollars o