Database Administration (MOSC)

MOSC Banner

How to create Partitioned External Table in Oracle Autonomous database cloud?

edited Feb 25, 2023 4:12PM in Database Administration (MOSC) 7 commentsAnswered ✓


I am trying to create a Partitioned External Table in my Oracle Autonomous database in OCI.


I created a storage Bucket and the files (for different quarters) are stored in the folders shown below:

../ostf2/REAC/2021/Q4/REAC2021Q1.txt

../ostf2/REAC/2021/Q4/REAC2021Q2.txt

../ostf2/REAC/2021/Q4/REAC2021Q3.txt

../ostf2/REAC/2021/Q4/REAC2021Q4.txt


Now when I do the CREATE_EXTERNAL_PART_TABLE call (as shown below), where years and quarter are in the column_list but not in field_list, as the files do not have years and quarter columns.

I get error:

ORA-20011: Invalid partitioning column in -

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center