impdp to a compressed tablespace
826230Dec 23 2010 — edited Dec 24 2010Hi All,
I've been given a project to test performance of an application with & without Compression.
Oracle: 11.2.0.2
My requirement is to import a schema from instance1 to instance2. When it resides into instance2, it should be in compressed form.
What I have tried till now?
- Pre-created a Commpressed tablespace in instance2.
- Classic exp/imp does the transfer but tables are not compressed.
- Tried datapump, but facing issue with impdp.
What attributes do I need to use so that all the tables would be compressed? Any other method for doing this?
Thanks.
P.S I'm no Oracle DBA, pls dont mind if my question sounds silly.