Home » RDBMS Server » Server Utilities » Import & Export Partition tables
Import & Export Partition tables [message #292439] Tue, 08 January 2008 23:20 Go to next message
Messages: 35
Registered: April 2007
Location: Malaysia

I have a table which is very huge in size >400millions records.
I have partition this table into 8 partitions.

I would like export into around 8 dmp files so that I copy the size of the dmp file without problem. And then import it into another database.

How do I export the partition table into different dump files?
Then how to import back the 8 dmp files into another table?
Could share with me the command to do so?
Re: Import & Export Partition tables [message #292464 is a reply to message #292439] Wed, 09 January 2008 00:30 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

You can use "filesize" parameter with export script according your file size specification.


hope this help
Previous Topic: Getting date from header of csv and load it to a table
Next Topic: Error encountered while takin export on owner mode.
Goto Forum:

Current Time: Sat Oct 22 04:40:44 CDT 2016

Total time taken to generate the page: 0.04519 seconds