Pular para o conteúdo

Fóruns Banco de dados Oracle Criar Esquema Criar Esquema

#103336
wljtcc
Participante

    olha o retorno do slect:

    SQL> SELECT * FROM DBA_DIRECTORIES;

    OWNER DIRECTORY_NAME


    DIRECTORY_PATH

    SYS ORACLE_OCM_CONFIG_DIR
    /u01/app/oracle/product/11.2.0/db_1/ccr/state

    SYS DATA_PUMP_DIR
    /u01/app/oracle/admin/dataeasy/dpdump/

    SYS MEDIA_DIR
    /u01/app/oracle/product/11.2.0/db_1/demo/schema/product_media/

    OWNER DIRECTORY_NAME


    DIRECTORY_PATH

    SYS XMLDIR
    /ade/b/2125410156/oracle/rdbms/xml

    SYS DATA_FILE_DIR
    /u01/app/oracle/product/11.2.0/db_1/demo/schema/sales_history/

    SYS LOG_FILE_DIR
    /u01/app/oracle/product/11.2.0/db_1/demo/schema/log/

    OWNER DIRECTORY_NAME


    DIRECTORY_PATH

    SYS SS_OE_XMLDIR
    /u01/app/oracle/product/11.2.0/db_1/demo/schema/order_entry/

    SYS SUBDIR
    /u01/app/oracle/product/11.2.0/db_1/demo/schema/order_entry//2002/Sep