ORA-14046: a partition may be split into exactly two new
partitions
Answer / guest
Cause: ALTER TABLE|INDEX SPLIT PARTITION did not contain
descriptions of exactly two new partitions into which an
existing table or index partition was to be split
Action: Ensure that the statement describes exactly two
partition into which an existing partition is to be split
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...
RMAN-06143: LIKE may only be specified with COPY
ORA-27196: skgfpbk: sbtpcbackup returned error
RMAN-06092: error while looking up backup piece
PLS-00398: wrong number of columns in UNION, INTERSECT, or MINUS expression
RMAN-08503: piece handle=string comment=string
RMAN-08521: offline range recid=string stamp=string
DRG-11831: Precondition Failed
QSM-02073: non-primary key RepAPI mv is not fast refreshable
ORA-12462: undefined compartment string for policy string
RMAN-20250: offline range not found in the recovery catalog
NNL-00800: Query requests received: number