psychicblue
asked on
How to delete all objects of a schema or db?
With what sql statement(s) can I delete all objects of a db in oracle 9i? (Without deleting and recreating the database)
Regards,
pb
Regards,
pb
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It is a lot easier to recreate the database. For that you can use DBCA (database create assistant). You can create a template from existing database and use it to rebuild.