OraFAQ Forum: Server Utilities » moving partitioned tables between databases

Home » RDBMS Server » Server Utilities » moving partitioned tables between databases

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

moving partitioned tables between databases [message #305930]

Wed, 12 March 2008 06:19

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

hi guys

I want to partition a table called FT_CUR_TRANS_HEADER containing rows and move the entire data to another table called FT_PRV_TRANS_HEADER using expdb and impdp. Can anybody tell me the steps to proceed??

Regards,
Balaji

Report message to a moderator

Re: moving partitioned tables between databases [message #305939 is a reply to message #305930]

Wed, 12 March 2008 06:31

Michel Cadot
Messages: 68771
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What don't you understand in the example in documentation?

Regadrs
Michel

Report message to a moderator

Re: moving partitioned tables between databases [message #306073 is a reply to message #305930]

Wed, 12 March 2008 14:29

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

where is the documentation??

Report message to a moderator

Re: moving partitioned tables between databases [message #306091 is a reply to message #306073]

Wed, 12 March 2008 15:08

Michel Cadot
Messages: 68771
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I think it is still at http://tahiti.oracle.com

Regards
Michel

Report message to a moderator

Re: moving partitioned tables between databases [message #306344 is a reply to message #305930]

Thu, 13 March 2008 16:27

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

thanks michel

Report message to a moderator

Re: moving partitioned tables between databases [message #306345 is a reply to message #305930]

Thu, 13 March 2008 16:30

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

let me first go through the documentation and will reply you if i get struck somewhere .

[Updated on: Thu, 13 March 2008 16:31]

Report message to a moderator

Previous Topic:	schema after export and import slowlier
Next Topic:	Import Failed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 28 11:29:14 CST 2025