<<Previous Next>>
Oracle - What
is an External Table? - June 27, 2009
at 11:00 AM
What is an External Table?
A table with its data stored outside the database as an OS file
is an external table.
The ORACLE_LOADER and ORACLE_DATAPUMP drivers are used to access
data of external tables.
External tables can be used to load data
from external files into database, or unload data from database to
external files.
Also read
Nested Table is a table inside a table. It can have several rows
for each row of its parent table............
Clusters group together tables that share common columns. These
tables are often used together.........
Use the ALTER TABLE command to do this ALTER TABLE employee ADD
(department VARCHAR2);.........
Ordinary (heap-organized) table, Clustered table, Index-organized
table, Partitioned table...........
Use the command DESC and the table name to view the information
about the columns..........
|
