Home » RDBMS Server » Server Utilities » Change the structure of a partitioned with expdp/impdp (Oracle 10gR1)
Change the structure of a partitioned with expdp/impdp [message #323942] Fri, 30 May 2008 02:06 Go to next message
mafc73
Messages: 38
Registered: November 2006
Member
I have to load a partitioned table from database A to database B, but I have to change the partition type in the process. I think that the only form to do this is exports rows from database A, after that create the table with the new partition type in database B and then with impdp imports only the rows. Can I automatize the process with expdp/impdp without create the table in B manually.

Thanks
Re: Change the structure of a partitioned with expdp/impdp [message #323969 is a reply to message #323942] Fri, 30 May 2008 03:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't think so.

Regards
Michel
Re: Change the structure of a partitioned with expdp/impdp [message #323970 is a reply to message #323942] Fri, 30 May 2008 03:16 Go to previous messageGo to next message
asangapradeep
Messages: 128
Registered: October 2005
Location: UK
Senior Member
can't change the partition type during the import
Re: Change the structure of a partitioned with expdp/impdp [message #325196 is a reply to message #323942] Thu, 05 June 2008 05:04 Go to previous message
lalitm_2003
Messages: 86
Registered: May 2005
Location: delhi
Member
Hi,
You need to create the table on the target database with different structure, then only you can import. Without table creation, this is not possible.

Regards
Lalit
Previous Topic: import database from 8.1.7.dmp to 10g with OEM
Next Topic: Compressed size EXP
Goto Forum:
  


Current Time: Sat Dec 10 15:02:22 CST 2016

Total time taken to generate the page: 0.15172 seconds