Home » RDBMS Server » Server Utilities » Partition table import through Data Pump (oracle, 11g, windows 2008 server.)
Partition table import through Data Pump [message #579284] Mon, 11 March 2013 02:13 Go to next message
muktha_22
Messages: 375
Registered: December 2009
Senior Member
Hello All,

please guide me to IMPORT PARTITION TABLE Through Data Pump.

I have a table with RANGE PARTITION.
I wanted to import this into another server with the same partitions.

But when I imported the table, The table created with the Partition but the data is not inserted in partition wise.

But I could see the Entire table's ROW COUNT.

Regards
Muthu
Re: Partition table import through Data Pump [message #579289 is a reply to message #579284] Mon, 11 March 2013 02:37 Go to previous messageGo to next message
Michel Cadot
Messages: 58641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You did something wrong, fix it and it will be OK.
And post in the CORRECT forum.

Regards
Michel
Re: Partition table import through Data Pump [message #579309 is a reply to message #579289] Mon, 11 March 2013 04:30 Go to previous messageGo to next message
muktha_22
Messages: 375
Registered: December 2009
Senior Member
Hi Michel,

Here is my code.

EXPORT LOG FILE


IMPORT LOG FILE


What is wrong in this.

Regards
Muthu

[EDITED by LF: applied [spoiler] tags] 72.38 MB 939179 rows
. . exported 13.28 MB 172561 rows
. . exported NSEINTRADAYPRICESDPBOSS

[Updated on: Mon, 11 March 2013 08:15] by Moderator

Report message to a moderator

Re: Partition table import through Data Pump [message #579311 is a reply to message #579309] Mon, 11 March 2013 05:04 Go to previous messageGo to next message
Michel Cadot
Messages: 58641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The Oracle versions incompatibillity.

You can also import without the statistics and compute the statistics afterwards.

Regards
Michel
Re: Partition table import through Data Pump [message #579316 is a reply to message #579311] Mon, 11 March 2013 05:35 Go to previous messageGo to next message
muktha_22
Messages: 375
Registered: December 2009
Senior Member
Hi Michel,

Thanks for your reply.

How we can import without Statistics?

Kindly help me out further.

I tried with another server, which is having the same oracle version, but still having the same problem.
Import log


[EDITED by LF: applied [spoiler] tags]

[Updated on: Mon, 11 March 2013 08:15] by Moderator

Report message to a moderator

Re: Partition table import through Data Pump [message #579318 is a reply to message #579316] Mon, 11 March 2013 05:48 Go to previous message
Michel Cadot
Messages: 58641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why do you want to import them and not recompute them?

Regards
Michel
Previous Topic: How to load unstructured data
Next Topic: datadump 11g to 10g
Goto Forum:
  


Current Time: Fri Aug 01 08:15:08 CDT 2014

Total time taken to generate the page: 0.08526 seconds