OraFAQ Forum: Backup & Recovery » IMPDP data from a source table into a destination table with more columns?

Home » RDBMS Server » Backup & Recovery » IMPDP data from a source table into a destination table with more columns? (12c , Solaris 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

IMPDP data from a source table into a destination table with more columns? [message #679384]

Thu, 27 February 2020 02:42

daulat01
Messages: 62
Registered: May 2011
Location: Delhi

Member

Hi,

Table 1 has 5 columns. Table 2 has the same 5 columns, plus an additional column. Can we use datapump or any other utility to copy the data from Table 1 to Table 2.

It is a large table with partitions.

Thanks,

Report message to a moderator

Re: IMPDP data from a source table into a destination table with more columns? [message #679386 is a reply to message #679384]

Thu, 27 February 2020 03:28

John Watson
Messages: 8454
Registered: January 2010
Location: Global Village

Senior Member

Data Pump cannot do that. Why look for a utility? Is an INSERT statement not the easiest way?

Report message to a moderator

Re: IMPDP data from a source table into a destination table with more columns? [message #679401 is a reply to message #679386]

Thu, 27 February 2020 10:54

daulat01
Messages: 62
Registered: May 2011
Location: Delhi

Member

Yes it's an easiest way but the table is very large. So i am looking a simplest way to do that.

Report message to a moderator

Re: IMPDP data from a source table into a destination table with more columns? [message #679402 is a reply to message #679401]

Thu, 27 February 2020 11:57

Michel Cadot
Messages: 67640
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

In this case, the easiest is also the simplest. What can be simpler than a single INSERT SELECT statement?
Or are you searching for a drag and drop tool?

[Updated on: Thu, 27 February 2020 11:57]

Report message to a moderator

Previous Topic:	Restore 10.2.0.4 RAC Backup to 11.2.0.4 dbhome
Next Topic:	19c pdb duplication

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 18 08:41:26 CST 2021