Skip to Main Content

Database Software

impdp to a compressed tablespace

826230Dec 23 2010 — edited Dec 24 2010
Hi All,

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.
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 21 2011
Added on Dec 23 2010
1 comment