General MySQL Oracle SQL Server

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.

 

⇒ What Is a Directory Object in Oracle

⇐ Load Data through External Tables in Oracle

⇑ Loading and Exporting Data in Oracle

⇑⇑ Oracle Database Tutorials

2016-11-27, 2084🔥, 0💬

General MySQL Oracle SQL Server