› Fóruns › Banco de dados Oracle › Criar Esquema › Criar Esquema
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