| Import data to a different table from an export dmp file [message #68972] |
Fri, 05 October 2001 06:56  |
Misha
Messages: 25
Registered: October 2001
|
Junior Member |
|
|
Hello,
The problem is:
I exported data (export utility) from table t1, but want to use result
dmp file to import data (import utility) from this file to a new empty
table t2 (different table with the same structure as t1). Is it
possible?
I don't have any problem importing data to empty t1 (setting ignore=y)
or creating new t1.
Thank you!
Misha-
----------------------------------------------------------------------
|
|
|
|
| Re: Import data to a different table from an export dmp file [message #68981 is a reply to message #68972] |
Mon, 08 October 2001 13:27  |
Bala
Messages: 205
Registered: November 1999
|
Senior Member |
|
|
Hi
there are other simple methods to transfer data from one table to another like
sqlplus copy command
or
SQL> insert into table_B (select * from table_A);
In the export dmp the table name will be hard coded so you can either overide the existing table or create a new table in the same name in a different schema...
Bala.
----------------------------------------------------------------------
|
|
|
|
| Import data from dmp file [message #69669 is a reply to message #68972] |
Thu, 14 February 2002 20:38 |
umesh
Messages: 23
Registered: March 2000
|
Junior Member |
|
|
i have some serious problem. i format my computer due to some virus problum, so i export my all oracle data in .DMP files. but now the problem is i can't import data from the .DMP file, so please give some solutions for import data. That .DMP file having my all 3 Years data.
umesh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
