ORA-14511 是一个 Oracle 数据库错误代码,具体含义为:“cannot perform a DML operation inside a query”。这个错误表明在 SQL 查询中尝试执行了数据操作语言(DML,如 INSERT、UPDATE、DELETE)操作,而这是不被允许的。 2. 可能导致 ORA-14511 错误的原因 子查询中的 DML 操作:在 SELECT 语句的子查询中尝试执行...
1、ERROR at line 1: ORA-14511: cannot perform operation on a partitioned object 2、表空间重命名 alter tabspace ts_name1 rename to ts_name2; 3、实例: #!/bin/sh nm=$(date +%Y%m -d 1month) ts_name=test_${nm} sqlplus -s system/121point << EOF set hea off set linesize 200 co...
ORA-14511: cannot perform operation on a partitioned object which I would assume means we better not eliminate TS_EXF My question is, ¿how do we disassociate the table exf.part_table from the tablespace TS_EXF in order that we can delete the Tablespace in question?
ORA-14511: cannot perform operation on a partitioned object which I would assume means we better not eliminate TS_EXF My question is, ¿how do we disassociate the table exf.part_table from the tablespace TS_EXF in order that we can delete the Tablespace in question?