ORA-02065: illegal option for ALTER SYSTEM
Answer / guest
Cause: The option specified for ALTER SYSTEM is not supported
Action: refer to the user manual for option supported
Please add more information about this Error
| Is This Answer Correct ? | 1 Yes | 6 No |
PLS-00993: Cursor Variables cannot be passed as RPC arguments or results
ORA-07577: no such user in authorization file
SQL*Loader-00652: Invalid zoned decimal byte.
ORA-02001: user SYS is not permitted to create indexes with freelist groups
NCR-03024: NCRO: Transport type LIST not supported
VID-00705: unsupported input format
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...
ORA-19361: ONLINE option not allowed with this type of index
ORA-12452: label tag string already exists
ORA-25198: only range, list, and hash partitioning are supported for index-organized table
DRG-51101: argument processing callback failed
ORA-12354: secondary object being dropped