CREATE DIRECTORY

Purpose

This statement is used to create a directory object.

Privilege requirements

• To create a directory object, you must have the CREATE ANY DIRECTORY system privilege. For more information about OceanBase Database privileges, see Privilege classification in Oracle-compatible mode.

• To ensure the security of file operations, when creating a file directory object, you must set the system variable secure_file_priv to a specified secure directory. For more information, see secure_file_priv.

Syntax

CREATE [ OR REPLACE ] DIRECTORY directory AS 'path_name';

Parameters

Examples

Follow these steps to create a directory object.

1. Set the global secure path.

   Notice

   Due to security reasons, when setting the system variable secure_file_priv, you can only execute the SQL statement to modify this global variable through a local Socket connection to the database. For more information, see secure_file_priv.

   1. Connect to OceanBase Database through a local Unix Socket. Example:

      obclient -S /home/admin/test421/oceanbase/run/sql.sock -usys@oracle001 -p******
      

   2. Set the global secure path.

      obclient [SYS]> SET GLOBAL secure_file_priv = "/usr/sqldump";
      

2. Log out.

   Note

   Since secure_file_priv is a GLOBAL variable, you need to execute \q to log out for the change to take effect.

   obclient [SYS]> \q
   

3. Reconnect to the database.

   obclient -hxxx.xxx.xxx.xxx -P2881 -utest_user001@oracle001 -p******
   

4. Create a directory object named sql_file_dir.

   obclient [TEST_USER001]> CREATE OR REPLACE DIRECTORY sql_file_dir AS '/usr/sqldump';
   

References

• secure_file_priv
• DROP DIRECTORY