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

Popular Posts:

How To Wirte a Simpl...

How To Wirte a Simple JUnit Test Class? This is a common test in a job interview. You should be able...

Vector and ArrayList...

What is the main difference between a Vector and an ArrayList? Java Vector class is internally synch...

What Articles Have Y...

What Articles Have You Read about JUnit? There are a number of JUnit articles that you should read: ...

Regarding C Coding...

Regarding C Coding Given: Line in file Contents 30 int * someIDs, theFirst, *r; 110 someIDs =GetSome...

printf() and sprint(...

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