Mess with the directories in 12c

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 29 Jul 2014 17:12:26 +0000 (UTC)
Message-ID: <pan.2014.07.29.17.12.25_at_gmail.com>

DBA_DIRECTORIES views looks like this:
SQL> desc dba_directories
 Name Null? Type

• --------

  ---

  OWNER NOT NULL VARCHAR2(128) DIRECTORY_NAME NOT NULL VARCHAR2(128) DIRECTORY_PATH VARCHAR2(4000) ORIGIN_CON_ID

This is what I get when selecting from PDB:

SQL> column directory_name format a35
SQL> select directory_name,origin_con_id   2 from dba_directories;

DIRECTORY_NAME ORIGIN_CON_ID

----------------------------------- -------------
ORACLE_HOME					1
ORACLE_BASE					1
OPATCH_LOG_DIR					1
OPATCH_SCRIPT_DIR				1
DATA_PUMP_DIR					1
ORACLE_OCM_CONFIG_DIR				1
ORACLE_OCM_CONFIG_DIR2				1
SQLT$UDUMP					3
XSDDIR						3
SQLT$STAGE					3
TRCA$STAGE					3
SQLT$BDUMP					3
TRCA$INPUT1					3
TRCA$INPUT2					3
TMP						3

15 rows selected.

Elapsed: 00:00:00.11
SQL> Directories created in another PDB (CON_ID=1) are appearing as "INVALID" to the expdp/impdp utilities. In particular, DATA_PUMP_DIR can only be used in CDB$ROOT (CON_ID=1).

-- 
Mladen Gogala
The Oracle Whisperer
http://mgogala.byethost5.com

Received on Tue Jul 29 2014 - 19:12:26 CEST