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
Messages: 89
Registered: May 2005
Location: chennai

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,
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: 10673
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: Thu Jul 20 15:49:27 CDT 2017

Total time taken to generate the page: 0.12187 seconds