What Are the Restrictions on External Table Columns

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 Are the Restrictions on External Table Columns

Q

What Are the Restrictions on External Table Columns? - Oracle DBA FAQ - Loading and Exporting Data

✍: FYIcenter.com

A

When creating external table columns, you need to watch out some restrictions:

"PRIMARY KEY" is not allowed.
"NOT NULL" is not allowed.
"DEFAULT value" is not allowed.

2007-04-30, 5544👍, 0💬

Popular Posts:

Incremental Operatos...

What will be printed as the result of the operation below: main() { int x=20,y=35; x=y++ + x++; y= +...

printf() and sprint(...

What is the difference between "printf(...)" and "sprintf(...)"? sprintf(...) writes data to the cha...

Java String Intervie...

If we have the following in a Java code: String s="abc"; String s2="abc"; Then what will be output o...

Can one change the m...

Can one change the mouse pointer in Forms? The SET_APPLICATION_PROPERTY build-in in Oracle Forms all...

How Oracle Handles D...

How Oracle Handles Dead Locks? - Oracle DBA FAQ - Understanding SQL Transaction Management Oracle se...