Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How come a compress enable table (name as ABC) when created (Oracle 11g R1), but after merging with a partitioned table's partition with data which is not compressed, then the table (ABC) auto becoming nonecompress?

share|improve this question

closed as unclear what you're asking by Max Vernon, RolandoMySQLDBA, Phil, ypercubeᵀᴹ, Erik Mar 24 at 16:31

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

do you mean exchange partition with the table? If not, can you show the code you are executing, including ddl for the tables. – ik_zelf Dec 15 '11 at 9:29

Browse other questions tagged or ask your own question.