| dropping multiple tables [message #73893] |
Fri, 30 July 2004 06:45  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
