Oracle Data Load - What Is a Directory Object

What Is a Directory Object

Q

What Is a Directory Object? - Oracle DBA FAQ - Loading and Exporting Data

✍: FYIcenter.com

A

A directory object is a logical alias for a physical directory path name on the operating system. Directory objects can be created, dropped, and granted access permissions to different users. The following tutorial exercise shows you some good examples:

>sqlplus /nolog

SQL> connect SYSTEM/fyicenter

SQL> CREATE DIRECTORY test_dir AS '/oraclexe/test';
Directory created.

SQL> GRANT READ ON DIRECTORY test_dir TO hr;
Grant succeeded.

SQL> GRANT WRITE ON DIRECTORY test_dir TO hr;
Grant succeeded.

SQL> CREATE DIRECTORY temp_dir AS '/oraclexe/temp';
Directory created.

SQL> DROP DIRECTORY temp_dir;
Directory dropped.

2007-04-30, 4356👍, 0💬

How To Define an External Table with a Text File
How To Define an External Table with a Text File? - Oracle DBA FAQ - Loading and Exporting Data You can use the CREATE TABLE statement to create external tables. But you need to use ORGANIZATION EXTERNAL clause to specify the external file location and the data access driver. The tutorial exercise b... 2007-04-30, 4493👍, 0💬

What Is a Directory Object
What Is a Directory Object? - Oracle DBA FAQ - Loading and Exporting Data A directory object is a logical alias for a physical directory path name on the operating system. Directory objects can be created, dropped, and granted access permissions to different users. The following tutorial exercise sh... 2007-04-30, 4357👍, 0💬

How To Load Data through External Tables
How To Load Data through External Tables? - Oracle DBA FAQ - Loading and Exporting Data If you have data stored in external files, you can load it to database through an external table by the steps below: Create an external table with columns matching data fields in the external file. Create a regul... 2007-04-30, 4344👍, 0💬

How To Run Queries on External Tables
How To Run Queries on External Tables? - Oracle DBA FAQ - Loading and Exporting Data If you have an external table defined as a text file with the ORACLE_LOADER driver, you can add data to the text file, and query the text file through the external table. By default, data fields in the text file sho... 2007-05-01, 4269👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.