Oracle Solution for Error ora-14704
ORA-14704: Create table as select disallowed for SYSTEM patitioned tables
What triggered the Error:
User attempted to create a SYSTEM partitioned table by doing a create table as select.What should we do to fix it:
Do a create table followed by an insert as select into each partition.
If this was not sufficient go over to:
Oracle Official Support Knowledge Center
Or maybe those geeks at: StackOverflow Board
Or maybe those geeks at: StackOverflow Board
