Do we need special oracle license to use compress option?Yes, you need Oracle Advanced Compression option.
don't want to export first then compress and move files which is older way...Traditional exp already allowed you to compress export files on the fly, using pipes.
khallas301 wrote:I think compress=all will require advanced compression option (I am not licensing expert but wouldn't hurt to check) , but then again, why don't you want to compress after dump is generated? 25gb is peanuts, and i bet out of it most will be index segments, which wont occupy more than few bytes in the dumpfile (metadata compression is possible).
friends and oracle gurus,
DB: Oracle 11.2
Schema size: 25G
I am trying to figure out best strategy to MOVE schema from warehouse to different database (11g) in compressed format on the fly... don't want to export first then compress and move files which is older way...
basically data should always be compressed during expdp n impdp...
so far I can think of below....
1. Lock user on warehouse
2. Expdp user with expdp parameter compress=all
3. Import user
4. drop user from warehouse
I think it's as simple as this but...
Just wondering am I missing any key element for compress part?
Do we need special oracle license to use compress option?
any other tips or steps??