Wednesday, 7 June 2017

Export/Import DataPump Parameter ACCESS_METHOD

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].

No comments:

Post a Comment