Home » RDBMS Server » Server Utilities » Import file to DB
Import file to DB [message #328246] Thu, 19 June 2008 08:39 Go to next message
prashanthgs
Messages: 89
Registered: May 2005
Location: chennai
Member
Hi,

I am having an export file dump of DB1 (Table Name: ACCOUNT, CONTACT, COLLECTION).

I need to import the dump file to DB2. (Table Name: ACCOUNT1, CONTACT1, COLLECTION1)

Though the table name is different, the structure is same.

Can u pls tell me what parameter I need to mention to implement this.

imp system/manager file=exp.dmp log=imp.log fromuser=col1 touser=col2 ignore=y commit=y tables=???

DB: Oracle 10gR2
OS: Unix

Pls help it out.

Thanks and Regards,
Prashanth
Re: Import file to DB [message #328283 is a reply to message #328246] Thu, 19 June 2008 10:41 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> Though the table name is different, the structure is same.
Just import the tables with the original names and rename table after import in target.
Previous Topic: Getting Error In SQL Loader
Next Topic: Update using sqlldr
Goto Forum:
  


Current Time: Fri Dec 02 14:06:20 CST 2016

Total time taken to generate the page: 0.13192 seconds