| Import file to DB [message #328246] |
Thu, 19 June 2008 08:39  |
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  |
 |
Mahesh Rajendran
Messages: 10708
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
