truncate system tables.

2003-01-10 Thread Antje . Sackwitz
Hi, just to lighten you up - it's old but good (found on the web) --- Yesterday, All those backups seemed a waste of pay. Now my database has gone away. Oh I believe in yesterday. Suddenly, There's not half the files there used to be, And there's a milestone hanging over me The system crashed

RE: Truncate system tables.

2003-01-08 Thread Bernardus Deddy Hoeydiono
[mailto:[EMAIL PROTECTED]]On Behalf Of Terrian, Tom (Contractor) (DAASC)Sent: Wednesday, January 08, 2003 9:19 PMTo: Multiple recipients of list ORACLE-LSubject: Truncate system tables. ummm...I just truncated all of the system tables in a new database (that's not good). 

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
ts of list ORACLE-LSubject: Truncate system tables. ummm...I just truncated all of the system tables in a new database (that's not good).  No backups yet.  Anyway to recover from this or do I have to recreate the database?   Thanks, Tom Terrian

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
m: Terrian, Tom (Contractor) (DAASC) [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08, 2003 9:19 AMTo: Multiple recipients of list ORACLE-LSubject: Truncate system tables. ummm...I just truncated all of the system tables in a new database (that's not good).  No backups yet

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

Truncate system tables.

2003-01-08 Thread Terrian, Tom (Contractor) (DAASC)
Title: Message ummm...I just truncated all of the system tables in a new database (that's not good).  No backups yet.  Anyway to recover from this or do I have to recreate the database?   Thanks, Tom Terrian