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

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.



Action:


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