Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
We can create a new “Database Directory” without using existing database directories in the database.
1 2 3 4 5 6 7 8 9 | *$ mkdir -p /u01/app/oracle/admin/cc/expimp_dir *SQL> create directory expimp_dump as '/u01/app/oracle/admin/cc/expimp_dir'; Directory created. *SQL> grant read, write on directory expimp_dump to emrah; Grant succeeded. |
We can view the directories that exist in the database by default and are created by us with the DBA_DIRECTORIES file.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | *SQL> select directory_name, directory_path from dba_directories; DIRECTORY_NAME DIRECTORY_PATH -------------------------------------------------------------------------------- SUBDIR /u01/app/oracle/product/11.2.0/db_1/demo/schema/order_entry//2002/Sep SS_OE_XMLDIR /u01/app/oracle/product/11.2.0/db_1/demo/schema/order_entry/ *EXPIMP_DUMP /u01/app/oracle/admin/cc/expimp_dir LOG_FILE_DIR /u01/app/oracle/product/11.2.0/db_1/demo/schema/log/ MEDIA_DIR /u01/app/oracle/product/11.2.0/db_1/demo/schema/product_media/ DATA_FILE_DIR /u01/app/oracle/product/11.2.0/db_1/demo/schema/sales_history/ XMLDIR /u01/app/oracle/product/11.2.0/db_1/rdbms/xml DATA_PUMP_DIR /u01/app/oracle/admin/cc/dpdump/ ORACLE_OCM_CONFIG_DIR /u01/app/oracle/product/11.2.0/db_1/ccr/hosts/cc.localdomain/state ORACLE_OCM_CONFIG_DIR2 /u01/app/oracle/product/11.2.0/db_1/ccr/state |
The database directory marked(*) above was created by us.
