Database Utilities (MOSC)

MOSC Banner

Importing partial dump over full dump

edited Jul 22, 2014 9:15AM in Database Utilities (MOSC) 5 commentsAnswered ✓

Dear All,

Am using

  1. SQL> select * from v$version; 
  2. BANNER 
  3. ---------------------------------------------------------------- 
  4. Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod 
  5. PL/SQL Release 10.2.0.1.0 - Production 
  6. CORE    10.2.0.1.0      Production 
  7. TNS for 32-bit Windows: Version 10.2.0.1.0 - Production 
  8. NLSRTL Version 10.2.0.1.0 - Production 

I have requirement that Due to huge size and time taking more than 8 hours to take dump using expdp.So I plan to take full on week end and partial dump that is (few tables have been partition into 3 parts which has more 2 GB  such part1,part2,part3. Part3 always have latest data(maxvalue) . I Used to backup of all tables(non partition tables) with part3 partition table data's.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center