Home » RDBMS Server » Backup & Recovery » IMPDP data from a source table into a destination table with more columns? (12c , Solaris 10)
IMPDP data from a source table into a destination table with more columns? [message #679384] Thu, 27 February 2020 02:42 Go to next message
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,
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 Go to previous messageGo to next message
John Watson
Messages: 8388
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?
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 Go to previous messageGo to next message
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.
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 Go to previous message
Michel Cadot
Messages: 67440
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:
  


Current Time: Tue Oct 20 18:53:36 CDT 2020