DEV: GUP: ORA-14108 When Used ASM

(Doc ID 2349072.1)

Last updated on FEBRUARY 01, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

[oracle@dbv-005 ~]$ sqlplus bgi_edw/------@bgisit

SQL*Plus: Release 12.1.0.2.0 Production on Mon Sep 4 11:49:20 2017

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Last Successful login time: Tue Aug 29 2017 17:44:24 +02:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options

SQL>
SQL>
SQL> CREATE TABLE t2 (
cust_id NUMBER(5) NOT NULL,
member_id NUMBER(38) NOT NULL
)
PARTITION BY RANGE (cust_id) INTERVAL (1)
(PARTITION p_zero VALUES LESS THAN (0))
/ 2 3 4 5 6 7

Table created.

SQL> INSERT INTO t2 PARTITION FOR (1) (cust_id, member_id) SELECT 1, 0 FROM dual;
INSERT INTO t2 PARTITION FOR (1) (cust_id, member_id) SELECT 1, 0 FROM dual
  *
ERROR at line 1:
ORA-14108: illegal partition-extended table name syntax


SQL>

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms