Importing partial dump over full dump
Dear All,
Am using
- SQL> select * from v$version;
- BANNER
- ----------------------------------------------------------------
- Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
- PL/SQL Release 10.2.0.1.0 - Production
- CORE 10.2.0.1.0 Production
- TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
- 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.