expdp/impdp
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