Home » RDBMS Server » Server Administration » How to export a dump file of a database (Oracle 9i,Windows)
icon6.gif  How to export a dump file of a database [message #324883] Wed, 04 June 2008 07:31 Go to next message
rakeshramm
Messages: 175
Registered: September 2006
Location: Oracle4u.com
Senior Member
How to export a dump file of a database .Usually i export dump file of a particular user of a database using 'EXP' command by logging into that username .Can any one help me how to export a dump file of an entire database. Thanks in Advance

Report message to a moderator

Re: How to export a dump file of a database [message #324885 is a reply to message #324883] Wed, 04 June 2008 07:33 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
do the export as SYSTEM user.

Report message to a moderator

Re: How to export a dump file of a database [message #324887 is a reply to message #324883] Wed, 04 June 2008 07:35 Go to previous message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Check this link.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/exp_imp.htm#i1021654

Regards

Raj

Report message to a moderator

Previous Topic: ORA-01045: user SYSTEM lacks CREATE SESSION privilege; logon denied
Next Topic: Upgrade from 10g to 11g
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 09 03:38:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.