.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

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

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML