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