Option 'enable row movement' not included in Dump 1

[roedelfroe]

Quite possible I miss an obvious thing.

I have taken a dump from a database with followoing options:

compress=n
direct=y
rows=y
indexes=y
constraints=y
grants=y
triggers=y
owner=xxx

Enable row movement is enabled on every table.

Importing the dump works fine, but Enable row movement is gone for every table which is definitely not, what I wanted to happen.

Any Idea why this problem occur?

Thanks for any replies - Roland

 

[karluk]

According to note 466343.1 on the Oracle support website, this is a fundamental limitation of the traditional exp/imp utilities. The metadata in the export simply doesn't contain the "enable row movement" clause. So Oracle is aware of the issue but doesn't seem interested in making a fix.

That leaves you with two alternatives. You can switch to the newer Datapump export/import utilies, which don't have this limitation, or you can write a script to reenable row movement after the import.