Hello Friends,
I was facing issues with the export – import task .
The source schema tables was having datatype as Long Raw and it was making issues during import.
Then i came to know new parameter ACCESS_METHOD.
Use below command during export -
expdp dumpfile=xxxxxxx logfile=xxxxxxxxx tables=owner.tablename access_method=direct_path
Use below command during import -
impdp dumpfile=xxxxxxxxx logfile=xxxxxxxx access_method=direct_path remap_schema=(optional) remap_tablespace=(optional) table_exists_action=replace ( optional )
It worked without any errors/warnings.
Reference Metalink Id –
Export/Import DataPump Parameter ACCESS_METHOD – How to Enforce a Method of Loading and Unloading Data ? [ID 552424.1].
I was facing issues with the export – import task .
The source schema tables was having datatype as Long Raw and it was making issues during import.
Then i came to know new parameter ACCESS_METHOD.
Use below command during export -
expdp dumpfile=xxxxxxx logfile=xxxxxxxxx tables=owner.tablename access_method=direct_path
Use below command during import -
impdp dumpfile=xxxxxxxxx logfile=xxxxxxxx access_method=direct_path remap_schema=(optional) remap_tablespace=(optional) table_exists_action=replace ( optional )
It worked without any errors/warnings.
Reference Metalink 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