Home » RDBMS Server » Server Utilities » moving partitioned tables between databases
moving partitioned tables between databases [message #305930] Wed, 12 March 2008 06:19 Go to next message
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

Re: moving partitioned tables between databases [message #305939 is a reply to message #305930] Wed, 12 March 2008 06:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What don't you understand in the example in documentation?

Regadrs
Michel
Re: moving partitioned tables between databases [message #306073 is a reply to message #305930] Wed, 12 March 2008 14:29 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

where is the documentation??
Re: moving partitioned tables between databases [message #306091 is a reply to message #306073] Wed, 12 March 2008 15:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think it is still at http://tahiti.oracle.com

Regards
Michel
Re: moving partitioned tables between databases [message #306344 is a reply to message #305930] Thu, 13 March 2008 16:27 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

thanks michel
Re: moving partitioned tables between databases [message #306345 is a reply to message #305930] Thu, 13 March 2008 16:30 Go to previous message
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:
  


Current Time: Sat Dec 10 14:28:25 CST 2016

Total time taken to generate the page: 0.04551 seconds