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
win3vin
Messages: 35
Registered: April 2007
Location: Malaysia
Member
Hi,

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?
thanks

Report message to a moderator

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.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_export.htm#sthref117

hope this help

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 28 15:39:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.