Restrictions on External Table Columns in Oracle

Q

What Are the Restrictions on External Table Columns in Oracle?

✍: 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.

 

Loading and Exporting Data in Oracle

⇒⇒Oracle Database Tutorials

2016-11-27, 210👍, 0💬