Home » RDBMS Server » Server Utilities » import/export options (Oracla 10gR2)
import/export options [message #347629] Fri, 12 September 2008 07:41 Go to next message
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
Senior Member

Hello,

I would like to know whether there's a way to drop the content of a schema user without actually dropping the user itself.

Precisely, I am working on a schema on which tests are made. I make a dump everytime a major thing has been added to that schema and when an error is applied, I have to drop the schema and import it from the previous dump. It's quite a work because I issue a drop user cascade, then I recreate the user, then I make the import. So am asking whether there is an option in the drop user that only drops the content of the schema, without actually dropping the user itself. Likewise, is there a way to import only the content of an import file?

Thanks in advance.
Re: import/export options [message #347632 is a reply to message #347629] Fri, 12 September 2008 08:02 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
A simple script will do. Just drop all the objects.
Query user_objects, create sql with drop statement,spool output and execute it.
Re: import/export options [message #347634 is a reply to message #347629] Fri, 12 September 2008 08:10 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.orafaq.com/forum/m/334405/102589/?#msg_334405

Regards
Michel
Previous Topic: oracle database to another oracle test server
Next Topic: Export/Import of the database on one server to database on another server
Goto Forum:
  


Current Time: Sun Dec 04 12:42:58 CST 2016

Total time taken to generate the page: 0.08933 seconds