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

Popular Posts:

What Information Is ...

What Information Is Needed to Connect SQL*Plus an Oracle Server? - Oracle DBA FAQ - Introduction to ...

How To Retrieve Inpu...

How To Retrieve Input Values for Checkboxes Properly? - PHP Script Tips - Processing Web Forms If mu...

Conditional Statemen...

What will be printed as the result of the operation below: main() { int a=0; if (a==0) printf("Cisco...

How do you locate th...

How do you locate the first X in a string txt? A) txt.find('X'); B) txt.locate('X'); C) txt.indexOf(...

What is application ...

What is application domain? Explain. An application domain is the CLR equivalent of an operation sys...