Solution : https://service.sap.com/sap/support/notes/1013049 (SAP Service marketplace login required)
Summary :
SAP Note addresses the application and technical nuances of Oracle Data Pump in the context of SAP systems. It clarifies that Data Pump, which was introduced in Oracle 10g, supersedes the older EXP/IMP utilities, offering enhanced capabilities, including parallel processing, restart options, and advanced queueing. The compatibility between Data Pump and EXP/IMP is highlighted as limited, urging users to be cautious about interchangeability. Details on technical components such as the EXPDP/IMPDP tools, DBMS_DATAPUMP package, and Data Pump Master processes are provided. For SAP environments, usage guidance is tied to specific SAP Notes and the limitations, like handling tables with LONG or LONG RAW columns in certain Oracle versions, are addressed. BRSPACE configurations for reorganization using Data Pump are extensively discussed, emphasizing the precautions and steps to ensure smooth data migration and system reorganization scenarios.
Key words :
customer component bc-db-ora oracle priority recommendations / additional info category faq validity, /o-intensive database operations 1039393 datapump creates corruptions, /o-intensive database operations 793113 faq, __%pdfstyle%__ / } symptom important, sap notes 1039393 datapump creates corruptions, default directory $oracle_home/rdbms/log, data pump-specific sessions dba_directories, data pump initialization phase takes, oracle memory areas 778426 special exports, export job create directory references
Related Notes :
| 1039393 | DATAPUMP creates corruptions in tables with LONG (RAW) |
| 1034126 | ORA-00832 when using Oracle Data Pump |
| 976435 | Support for Oracle Data Pump in BRSPACE |
| 806554 | FAQ: I/O-intensive database operations |
| 793113 | FAQ: Oracle I/O configuration |
| 789011 | FAQ: Oracle memory areas |
| 778426 | Special exports and imports with BRSPACE |
| 619188 | FAQ: Oracle wait events |
| 105047 | Support for Oracle functions in the SAP environment |