Home » RDBMS Server » Server Utilities » dropping multiple tables
dropping multiple tables [message #73893] Fri, 30 July 2004 06:45 Go to next message
abd1
Messages: 1
Registered: July 2004
Junior Member
I am trying to import a dmp file from another database instance.

The target already has data in the tables, and when I import, I get constraint and other errors.

Is there a quick way to truncate all tables and run the import?
Re: dropping multiple tables [message #73896 is a reply to message #73893] Sun, 01 August 2004 10:44 Go to previous message
ilver
Messages: 50
Registered: January 2004
Member
If you want to replace a schema completly, you should drop it before import. Be carefull about backup and rollback in case your import doesn't succeed.

The syntax for dropping a schema is something like "drop user xxx cascade".

Depending on the database version, import have several fetures you maybe should read about and learn to master before doing the import.

/ilver
Previous Topic: ORA - 12203 TNS Unable to Connect Destination
Next Topic: doing parallel export's
Goto Forum:
  


Current Time: Wed Dec 25 07:16:12 CST 2024