OraFAQ Forum: Performance Tuning » Importing Partitioning rows from Many Export Files.

Home » RDBMS Server » Performance Tuning » Importing Partitioning rows from Many Export Files. (oracle version 10g Windows XP)

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

Importing Partitioning rows from Many Export Files. [message #521453]

Tue, 30 August 2011 01:53

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi All,

Kindly guide me for the below:

1) I have 5 Exported Dump files.
2) All of those 5 dump files were taken in different time periods.
3) Many of those Dump files are having the same Partition records.
eg:-
Dump 1:- 01-06-2010 to 31-11-2010
Dump 2:- 01-09-2010 to 31-12-2010

4) Now i want to import all those partitioning data into a single table, without having any duplication.

Kindly guide me on this...

Thanks & Regards
Muktha

Report message to a moderator