OraFAQ Forum: Server Utilities » how to make a dump of the schema script and its data

Home » RDBMS Server » Server Utilities » how to make a dump of the schema script and its data

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to make a dump of the schema script and its data [message #170965]

Sat, 06 May 2006 15:21

haitham
Messages: 60
Registered: February 2006

Member

ill uninstal my oracle9i and i want to know how to make a dump for the schema script ( create statements ) and the stored data ..
and i want to know how to load them again into the database after instaling the oracle 9i again, instead of creating the same tables and inserting the same data again ...
plz help.....

Report message to a moderator

Re: how to make a dump of the schema script and its data [message #170968 is a reply to message #170965]

Sat, 06 May 2006 15:38

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Use the "exp" utility. For more info, see http://www.orafaq.com/faq/import_export

Report message to a moderator

Previous Topic:	Problem to import a file
Next Topic:	sqlplus shows password in clear text under cygwin

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 08:19:05 CDT 2024