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

Popular Posts:

Error: Imported Tabl...

What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...

Import One Table bac...

How To Import One Table Back from a Dump File in Oracle? If you only want to import one table back t...

Connecting SQL Serve...

How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...

Running Queries with...

How to run Queries with "sqlcmd" tool in SQL Server? "sqlcmd" is a client tool that you can use to i...

About dba.FYIcenter....

What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...