Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

expdp/impdp

user3714906May 30 2012 — edited Jun 7 2012
Hi,

I have a situation where I have to change INITRANS of the tables, so I need to perform below steps:

1.Export the contents of the table
2. Recreate the table and associated index(s) with the correct INITRANS settings
3. Re-import the table data

for export If I use:

expdp system/manager directory=export dumpfile=PAY_RUN_RESULTS.dmp logfile=PAY_RUN_RESULTS.log content=data_only

do I need to specify any other option with expdp and what about the indexes and views associated with it?

Thanks and regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 5 2012
Added on May 30 2012
15 comments
742 views