Oracle:directory

retour vers Oracle

Objet repertoire sous Oracle

Liste des repertoire dans Oracle

SQL> desc dba_directories
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
OWNER                                     NOT NULL VARCHAR2(30)
DIRECTORY_NAME                            NOT NULL VARCHAR2(30)
DIRECTORY_PATH                                     VARCHAR2(4000)

 SQL> SELECT * FROM dba_directories;
 OWNER                          DIRECTORY_NAME           DIRECTORY_PATH
 ------------------------------ -------------------------------------------------------------
 SYS                            EXPDIR                   /oradata/expora
 SYS                            DATA_PUMP_DIR            /oracle/product/11.2.0.1.0/rdbms/log/
 SYS                            ORACLE_OCM_CONFIG_DIR    /oracle/product/11.2.0.1.0/ccr/state

Definition d'un répertoire dans Oracle

 SQL> CREATE DIRECTORY dmpdir AS '/opt/oracle';
 Directory created.

 SQL> GRANT read, write ON DIRECTORY dmpdir TO scott;
 Grant succeeded.