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

Report message to a moderator

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: 68757
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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.

Report message to a moderator

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: 7065
Registered: December 2001
Senior Member
Export/Import.

MHE

Report message to a moderator

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: 68757
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 19 10:55:40 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.