Oracle - Restrictions on External Table Columns in Oracle

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

Popular Posts:

INSERT, UPDATE and D...

Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...

Getting Year, Month ...

How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...

sys.server_principal...

How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...

Windows Applications...

How Can Windows Applications Connect to Oracle Servers in Oracle? A Windows application can connect ...

What Causes Index Fr...

What Causes Index Fragmentation in SQL Server? Index fragmentation is usually caused by deleting of ...