Data Pump Directory

Follow these steps if the expdp command in the backup script fails.

Note:

You must shut down the SDM server before you complete the steps in this section.

1. Connect to your Oracle database as sysdba.

   cd $ORACLE_HOME/bin
   ./sqlplus / as sysdba 

2. Change the streams pool size to generate data pump files.

   ALTER SYSTEM SET streams_pool_size=128M;

3. Shutdown the Oracle database.

   SHUTDOWN IMMEDIATE;

4. Restart the Oracle database.

   STARTUP;

5. Verify the change took place with the following command:

   SHOW PARAMETER streams_pool_size;