Home » SQL & PL/SQL » SQL & PL/SQL » how to dump oracle database?
icon5.gif  how to dump oracle database? [message #256882] Tue, 07 August 2007 00:19 Go to next message
jeeva07
Messages: 7
Registered: June 2007
Junior Member
Razz
Re: how to dump oracle database? [message #256885 is a reply to message #256882] Tue, 07 August 2007 00:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What do you mean with "dump"?
In which format do you want the "dump"?
What is your Oracle version?

Regards
Michel
Re: how to dump oracle9i database? [message #256899 is a reply to message #256885] Tue, 07 August 2007 01:16 Go to previous messageGo to next message
jeeva07
Messages: 7
Registered: June 2007
Junior Member
it is oracle 9i database.i want dump that database and i want to use it in another system.
Re: how to dump oracle9i database? [message #256901 is a reply to message #256899] Tue, 07 August 2007 01:21 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Export/Import.

MHE
Re: how to dump oracle9i database? [message #256903 is a reply to message #256899] Tue, 07 August 2007 01:28 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If another system means another Oracle database then export/import.
If another system means another rdbms then use either SQL*Plus, select and spool or an external program.

Regards
Michel
Previous Topic: ORA-01722 during Procedure execution
Next Topic: mutating trigger
Goto Forum:
  


Current Time: Sun Dec 04 10:26:51 CST 2016

Total time taken to generate the page: 0.11194 seconds