Home » RDBMS Server » Backup & Recovery » Export (Oracle 9i, Windows XP)
Export [message #436886] Tue, 29 December 2009 06:26 Go to next message
zahidbashir
Messages: 34
Registered: September 2009
Member
Hi,
I have two databases running on the system. I issued the export command:
exp system/password file=c:\temp\example.exp log=c:\temp\example.log full=y

The export command completed successfully. Now, I have no idea which database has it exported? Only the default one or both?
How can i specify the database which i want to export. I guess with specifying it in the userid clause like
exp  userid = hr/hr@finance

or there is some other method?

Please help

Regards

Report message to a moderator

Re: Export [message #436889 is a reply to message #436886] Tue, 29 December 2009 06:47 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Import_Export_FAQ This will help you

sriram Smile

Report message to a moderator

Re: Export [message #436892 is a reply to message #436886] Tue, 29 December 2009 07:10 Go to previous messageGo to next message
zahidbashir
Messages: 34
Registered: September 2009
Member
Sory but still couldn't find answers

Report message to a moderator

Re: Export [message #436893 is a reply to message #436886] Tue, 29 December 2009 07:10 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
 
exp user/pass@tnsentry
or
export ORACLE_SID=mySid
exp user/pass

Report message to a moderator

Re: Export [message #436894 is a reply to message #436886] Tue, 29 December 2009 07:12 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> Only the default one or both?
You tell us.
There is nothing "default".
Whatever is defined in OS variable ORACLE_SID will be in effect.

Report message to a moderator

Re: Export [message #436899 is a reply to message #436886] Tue, 29 December 2009 07:27 Go to previous message
zahidbashir
Messages: 34
Registered: September 2009
Member
Tnx Mahesh, Thats alot better answer Smile

Report message to a moderator

Previous Topic: Control file Autobackup
Next Topic: Unregister Database from Recovery catalog
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 18:45:34 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.