This content has been marked as final. Show 9 replies
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??
Or as some might suggest, use network link and be done with it.
friends thank you for quick reply...
License on compress with expdp not sure since I couldn't find that in book... but yes advance table compression requires license..
I guess I misunderstood full compress part... I thought initally I might require to compress dump file but as somebody suggested it's only 25gb so why to do it... makes sense..
actually after 2nd thought I realize requirement is below:
(I don't worry about license, it should be there)
to setup compression on tablespace level and
all data will be compressed during import using direct path import level...
my next problem is...
how to get compression on tablespace level?
how to have data compress directly during import?
basically I want to have schema data always compressed where it resides in db...
changed compress request..
To activate at the tablespace level.
alter tablespace xx default compress for all operation;
will activate it.
When you import in you have to specify
to strip of the attributes of the table (i.e. the nocompress' option that will be set in the source database at the table level. Stripping this off means it takes the tablespce default and is compressed.
Advanced compression doesn;t compress indexes though so if you want thos compressed you need to do it the old style way.