Home » RDBMS Server » Server Utilities » Import data to a different table from an export dmp file
Import data to a different table from an export dmp file [message #68972] Fri, 05 October 2001 06:56 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: Re: Loader-522 Message (lfiopn failed for file)
Next Topic: DBMS_JOBS
Goto Forum:
  


Current Time: Thu Mar 28 11:43:23 CDT 2024