ORA-14704: Create table as select disallowed for SYSTEM patitioned tables

You are here: Home // Oracle 11g // ORA-14704: Create table as select disallowed for SYSTEM patitioned tables

Cause: User attempted to create a SYSTEM partitioned table by doing a create table as select. See the solution below.

Error solution: Do a create table followed by an insert as select into each partition.

Database version: Oracle 11g Release 2 (11.2)