This content has been marked as final. Show 3 replies
I need to do below steps:Are you instructed to do the above by Oracle Support? Please note that such export/import is not supported.
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
No if I export data of the table PAY_RUN_RESULTS using below syntax, it says table not foundThis table under HR schema -- http://etrm.oracle.com/pls/et1211d9/etrm_pnav.show_object?c_name=PAY_RUN_RESULTS&c_owner=HR&c_type=TABLE
expdp syste/manager directroy=expbkp dumpfile=payrun.dmp logfile=payrun.log table=PAY_RUN_RESULTS
Yes, this is update from Oracle Support
"Please review Note 226987.1 - Oracle 11i & R12 Human Resources (HRMS) & Benefits (BEN) Tuning & System Health Checks Appendix C - INITRANS & PCTFREE Settings, which is holding a clear description on what to set."
Please let me know how can I export the contents of this table?