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 file is valid 100%.
3. run the script catalog.sql from directory $ORACLE_HOME/rdbms/admin
3. recreate the application user and import the export file.
 
I hope this solution can help you.
 
Thank's
 
Bernardus Deddy Hoeydiono.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Terrian, Tom (Contractor) (DAASC)
Sent: Wednesday, January 08, 2003 9:19 PM
To: Multiple recipients of list ORACLE-L
Subject: 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

Reply via email to