How to Fix LONG RAW Import Issues Using ACCESS_METHOD in Data Pump
Hello Friends,
While performing an export-import task using Oracle Data Pump, I encountered issues with tables that had the data type LONG RAW. The import would fail or throw warnings.
After investigating, I found that using the ACCESS_METHOD parameter during export and import helps avoid this problem.
✅ Export Using ACCESS_METHOD
expdp dumpfile=your_export.dmp \
logfile=your_export.log \
tables=owner.tablename \
access_method=direct_path
✅ Import Using ACCESS_METHOD
impdp dumpfile=your_export.dmp \
logfile=your_import.log \
access_method=direct_path \
remap_schema=old:new \
remap_tablespace=old_ts:new_ts \
table_exists_action=replace
After using access_method=direct_path, the import completed successfully without any errors or warnings.
🔗 Reference
Oracle Metalink Doc ID:
Export/Import DataPump Parameter ACCESS_METHOD – How to Enforce a Method of Loading and Unloading Data? [ID 552424.1]
No comments:
Post a Comment