Home » RDBMS Server » Server Utilities » Import Utility Problem
Import Utility Problem [message #73200] Mon, 01 March 2004 21:37 Go to next message
sahaslad
Messages: 23
Registered: May 2002
Junior Member
Hi,
It's about Import/Export utility in Oracle.
I have created two database in my oracle through Database Config. Assistant option.
The two database are named as database1 and database2 respectively.
Now i am having a .DMP file from which i want to import some tables to database2.
I am using the import utility of oracle but it always transfer to database1.
I have tried a lot but in vain.
Can u suggest/help me to solve this problem.

Thanks for your help.

Report message to a moderator

Re: Import Utility Problem [message #73201 is a reply to message #73200] Tue, 02 March 2004 02:59 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
create a tns entry to connect to seperatly to both databases.
say db1 and db2
use these entreis to do the export/imp
imp user/pass@db1 .... ... ... # import into db1
imp user/pass@db2 .... ... ... # import into db2

or
set ur ORACLE_SID to db2 (SID of database2)
then do the import
imp user/pass ......    # since sid is defualt to
                        # DB2 , it will import into db2

Report message to a moderator

Previous Topic: export to cd
Next Topic: connecting to oracle
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 05:35:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.