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, 5510👍, 0💬

Popular Posts:

How you will enable ...

How you will enable front-end validation based on the xml in validation.xml? The &lthtml:javascr...

wait(), notify() and...

What is the purpose of the wait(), notify(), and notifyAll() methods? The wait(),notify(), and notif...

How To Enter Binary ...

How To Enter Binary Numbers in SQL Statements? - MySQL FAQs - Introduction to SQL Basics If you want...

How To Remove the To...

How To Remove the Top White Space of Your Web Page? - CSS Tutorials - Introduction To CSS Basics The...

What Is the Differen...

What Is the Difference between Formal Parameters and Actual Parameters? - Oracle DBA FAQ - Creating ...