回覆列表
  • 1 # 使用者834195712159

    示例說明:

    SQL> conn / as sysdba

    已連線。

    SQL> create directory sscFjSsc as "D:\his\data\ssc\fj";

    目錄已建立。

    SQL> desc dba_directories

    名稱 是否為空? 型別

    OWNER NOT NULL VARCHAR2(30)

    DIRECTORY_NAME NOT NULL VARCHAR2(30)

    DIRECTORY_PATH VARCHAR2(4000)

    SQL> select count(1) from dba_directories;

    COUNT(1)

    ----------

    2

    SQL> select * from dba_directories;

    OWNER DIRECTORY_NAME

    ------------------------------ ------------------------------

    DIRECTORY_PATH

    --------------------------------------------------------------------------------

    SYS DATA_PUMP_DIR

    D:\oracle\product\10.2.0\db_1\rdbms\log\

    SYS SSCFJSSC

    D:\his\data\ssc\fj

  • 中秋節和大豐收的關聯?
  • “足智多謀”是什麼意思?