What Is an External Table

Categories:

.NET (357)

C (330)

C++ (183)

CSS (84)

DBA (2)

HTML (4)

Java (574)

JavaScript (106)

JSP (66)

Oracle (114)

Perl (46)

Perl (1)

PHP (1)

RSS (51)

Software QA (13)

XHTML (173)

Other Resources:

Software QA Resources

Developer Resources

Windows Tutorials

File Extensions

Security Certificates

Regular Expression

Link Directories

Interview Q & A

Biotech Resources

Cell Phone Resources

Travel Resources

Frequently Asked Questions

FYIcenter Forum

Home > Oracle > Data Load

What Is an External Table

Q

What Is an External Table? - Oracle DBA FAQ - Loading and Exporting Data

✍: FYIcenter.com

A

An external table is a table defined in the database with data stored outside the database. Data of an external table is stored in files on the operating systems. Accessing data of external tables are done through data access drivers. Currently, Oracle supports two data access drivers: ORACLE_LOADER and ORACLE_DATAPUMP.

External tables can be used to load data from external files into database, or unload data from database to external files.

2007-04-30, 5623👍, 0💬

Popular Posts:

Can one execute dyna...

Can one execute dynamic SQL from Forms? Yes, use the FORMS_DDL built-in or call the DBMS_SQL databas...

What are Daemon thre...

.NET INTERVIEW QUESTIONS - What are Daemon threads and how can a thread be created as Daemon? Daemon...

How Many Types of Ta...

How Many Types of Tables Supported by Oracle? - Oracle DBA FAQ - Managing Oracle Database Tables Ora...

urlencode() and urld...

What are urlencode() and urldecode() functions in PHP? string urlencode(str) - Returns the URL encod...

String Concatenation...

What will be printed as the result of the operation below: main() { char *p1; char *p2; p1=(char *)m...