Oracle

External Tables [1]

Figo Kim 2006. 12. 7. 13:54
336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.

 

An External Table :

  • A read-only table
  • Only meta-data is stored in the database
  • No DML operations are possible, No indexes.
  • CREATE TABLE AS SELECT statement is possible.
  • Two major access drivers
    • ORACLE_LOADER
    • ORACLE_DATAPUMP : import and export data
      • CREATE TABLE AS SELECT statement is possible.
      • Read data from a table in the database and insert it into an external table.
      • After initial population, NO DML is possible.

Preceding work for Creating a Directory for the External Table

  • Create a directory object where the external table will be located.

Examples)

CREATE OR REPLACE DIRECTORY emp_dir

AS '/…/emp_dir';

 

GRANT REAN ON DIRECTORY emp_dir TO hr;

 

Syntax)

CREATE [OR REPLACE] DIRECTORY AS 'path_name';

 

In the syntax:

Directory : the name of the directory object. Maximum length is 30 bytes.

 

'Oracle' 카테고리의 다른 글

Creating an External Table  (0) 2006.12.07
External Tables [1]  (0) 2006.12.07
The secret about her  (0) 2006.12.05
Performing Flashback Database with SQL*Plus  (0) 2006.12.04
Performing Flashback Database with SQL*Plus  (0) 2006.12.04