1

Topic: impdp

Good afternoon. Prompt as it is possible to make import through impdp with switching-on of compression of tables/lob'ov and ? (Option Advanced Compression) whether Is such possibility, something anywhere did not find...?

2

Re: impdp

12c +

impdp TRANSFORM=LOB_STORAGE:SECUREFILE,TABLE_COMPRESSION_CLAUSE: "ROW STORE COMPRESS ADVANCED"

Or so:

imdp CONTENT=METADATA_ONLY
...
alter table XXX COMPRESS FOR OLTP... DEDUPLICATE...;
...
impdp CONTENT=DATA_ONLY TABLE_EXISTS_ACTION = [TRUNCATE/APPEND]