- In other words, they want to export their Oracle schema to send for analysis (for example to troubleshoot a problem).
Resolving The Problem
- Database name = ccr
- Controller schema name = controllerlive
- Oracle database's SYS password = mypassword
- Oracle's SYSTEM password = mypassword
In this scenario, ask your Oracle DBA (administrator) to:
1. Check that your Oracle server is configured to have a 'data pump' folder.
If one does not exist, then you can create one by:
- Create a folder (for example "C:\DATA_PUMP_DIR") on your Oracle server, for use by the data pump feature
- Run the following script to configure the data pump folder:
CONN sys/mypassword@ccr AS SYSDBA
CREATE OR REPLACE DIRECTORY data_pump_dir AS 'C:\DATA_PUMP_DIR';
GRANT READ, WRITE ON DIRECTORY data_pump_dir TO controllerlive,system;
2. If your Oracle database server is based on Windows, launch a command prompt (CMD)
3. Run the following command:
expdp SYSTEM/mypassword@ccr schemas=controllerlive directory=data_pump_dir dumpfile=controllerlive.dmp logfile=controllerlive.log
4. Open the data pump folder
5. Locate the new DMP file (created by the above script)
6. Compress this file (for example to ZIP or 7z)
7. Please send both the compressed file and the log file (for example 'controllerlive.log') to IBM Support
Was this topic helpful?
22 April 2020