New answers tagged

1

The real error is: ORA-12801: error signaled in parallel query server P000 ORA-01115: IO error reading block from file (block # ) ORA-01115: IO error reading block from file 2 (block # 215616) ORA-27072: File I/O error Additional information: 4 Additional information: 215616 Additional information: 212992 The "solutions" you tried make no sense when you ...


0

There is built-in type called SYS.ODCINUMBERLIST which is a VARRAY(32767) of NUMBER, and EXECUTE privilege is granted on it to everyone (PUBLIC). You can use that for up to 32767 numbers, example: with function f1 (p_numbers SYS.ODCINUMBERLIST) return number as begin return p_numbers.count; end; select f1(SYS.ODCINUMBERLIST(1,2,3,4,5,6,7)) from dual; / F1(...


2

SQL> with cte_test 2 as 3 (select * from emp); (select * from emp) * ERROR at line 3: ORA-00928: missing SELECT keyword SQL> select cte_test as (select * from emp) 2 select * from cte; select cte_test as (select * from emp) * ERROR at line 1: ORA-00923: FROM ...


1

This is only a matter of the metadata being incomplete in the installer. If you have access to Oracle support, then: Reference data is not available for release "12.1" on Linux x86-64 SLES-12 (Doc ID 2127760.1) In the above note, there is a link for the patch for this issue. The workaround is to ignore the prerequisites by starting the installer as: ./...


Top 50 recent answers are included