RE: Truncate system tables.

MessageHi 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
4. recreate the application user and import the export file.

I hope this solution can help you.

Thank's

Bernardus Deddy Hoeydiono.
  -----Original Message-----
  From: root_at_fatcity.com [mailto:root_at_fatcity.com]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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bernardus Deddy Hoeydiono
  INET: deddy_at_sdi.co.id

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-Mail message
to: ListGuru_at_fatcity.com (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).