External Table Properties

From ER/Studio Data Architect
Jump to: navigation, search

Go Up to Defining Table Storage

The External Table Properties dialog allows you to manage external table properties for Oracle 12c and later. External tables allow Oracle to query data stored in flat files that are outside of the database. Make any necessary updates, and then click OK to save your changes, which then are reflected in the DDL.

  • Access Driver. Options include ORACLE_LOADER and ORACLE_DATAPUMP.
    • ORACLE_LOADER (Default) The ORACLE_LOADER driver performs only data loads and that data must come from text datafiles. Loads from external tables to internal tables occur by reading from the external tables' text-only datafiles.
    • ORACLE_DATAPUMP The ORACLE_DATAPUMP can perform both loads and unloads, but the data must come from binary dump files. Loads to internal tables from external tables occur by fetching from the binary dump files while unloads from internal tables to external tables occur by populating the external tables' binary dump files.
  • Default Directory. Specifies the default directory object location of files read or written by external tables.
  • Access Parameters. Specifies the external data source and implements the external table type. Each type of external table has its own access driver that provides access parameters unique to that type of external table.
  • Location. Specifies the location of the external data as a list of directory objects and filenames. If the directory object is not specified, then the default directory object is used as the file location.