Download the guide. Learn more... This will produce a list of drop statements.
Normally, it is simplest to drop and add the user. Drop all tables or Drop Schema Oracle 10g I'm using Imp "dmp" file to import into my existing database. Alan Kendall Alan Kendall 71 2.
Edit Related wikiHows. Databases Print Edit Send fan mail to authors.
To be honest, I don't see a lot of use for oracle's recycle bin, and wish i could disable it, but anyway:. Is that an option to "drop all tables"?
I found this script: What is your goal? Get started today Stand Out as the employee with proven skills. I wear a lot of hats...
This is the preferred method if you have system or sysdba access to the database. If step 6 fails then you need to identify the remaining objects preventing your user from being deleted and add them to the above script.
If the user's schema contains tables, then Oracle Database drops the tables and automatically drops any referential integrity constraints on tables in other schemas that refer to primary and unique keys on these tables.
LVL 75. Book List.