impdp to a compressed tablespace
826230Dec 23 2010 — edited Dec 24 2010
I've been given a project to test performance of an application with & without Compression.
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?
P.S I'm no Oracle DBA, pls dont mind if my question sounds silly.