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

Report message to a moderator

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: 68651
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't think so.

Regards
Michel

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 17 03:38:24 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.