Forum Stats

  • 3,851,951 Users
  • 2,264,054 Discussions
  • 7,904,915 Comments

Discussions

impdp to a compressed tablespace

826230
826230 Member Posts: 9
edited Dec 24, 2010 7:32PM in Advanced Compression
Hi 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.

Answers

  • damorgan
    damorgan Member Posts: 14,464 Bronze Crown
    Based solely upon what you've written here's what I would do.

    1. In source schema grant select on tables to schema 2
    2. In schema 2 do the following:

    INSERT /*+ APPEND */ INTO <target_table>
    SELECT * FROM <source_schema.source_table>;

    If this is not what you need then you need to clarify your requirements and post sample DDL for the target tables.
This discussion has been closed.