Home » RDBMS Server » Performance Tuning » Importing Partitioning rows from Many Export Files. (oracle version 10g Windows XP)
Importing Partitioning rows from Many Export Files. [message #521453] Tue, 30 August 2011 01:53 Go to next message
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

Re: Importing Partitioning rows from Many Export Files. [message #521456 is a reply to message #521453] Tue, 30 August 2011 02:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Add a unique key.

Regards
Michel

Report message to a moderator

Re: Importing Partitioning rows from Many Export Files. [message #521458 is a reply to message #521456] Tue, 30 August 2011 02:40 Go to previous message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi Mickel,

Thanks a lot...

Report message to a moderator

Previous Topic: different between move and shink table
Next Topic: Memory Fault Error in Tkprof
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 15:13:22 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.