Cause
DDL operations like creation tables, views etc. and transaction control statements such as commit/rollback cannot be performed inside a query or a DML statement.
DDL operations like creation tables, views etc. and transaction control statements such as commit/rollback cannot be performed inside a query or a DML statement.
Either (1) Specify an object-level default tablespace (or partition-level default tablespace for the appropriate partition, if composite partitioning is used) for the partitioned local index/LOB column and then retry the DDL command, OR (2) Ensure that tablespaces of the correct block size are specified for all new partitions/subpartitions being created. Also ensure that neither of TABLESPACE DEFAULT and STORE IN (DEFAULT) is specified for a local index whose block size does not match that of the base table.
Try the following links for this error:
http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm
https://community.oracle.com/message/9268781
https://community.oracle.com/message/690496
https://community.oracle.com/message/139198
https://community.oracle.com/message/3195481
https://community.oracle.com/message/2206136
https://community.oracle.com/message/11121037
https://community.oracle.com/message/607731
https://community.oracle.com/message/11229053
https://community.oracle.com/message/2685726
https://community.oracle.com/message/881718
https://community.oracle.com/message/11070055
https://community.oracle.com/message/10233079
https://community.oracle.com/message/1221450
https://community.oracle.com/message/1106389
https://community.oracle.com/message/10814276
Browse all solutions to database errors from Oracle, MS SQL, or MySQL