Hi All,
I have just installed the IOTC package in an Oracle 12c database following SAP Note http://service.sap.com/sap/support/notes/1856270
But it errors.
sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Aug 3 14:43:12 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> create or replace directory "~IOT_DIR" as '/tmp';
Directory created.
SQL> grant read, write on directory "~IOT_DIR" to sapsr3;
Grant succeeded.
SQL> grant execute on DBMS_REDEFINITION to sapsr3;
Grant succeeded.
SQL> exit
sqlplus sapsr3
SQL*Plus: Release 12.1.0.2.0 Production on Wed Aug 3 14:43:44 2016
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter password:
Last Successful login time: Wed Aug 03 2016 14:35:12 +01:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> start iotc
Package created.
No errors.
Package body created.
No errors.
SQL> exec iotc.convert (10);
Processing the 10 largest tables
Processing table SAPSR3.SCPRSVALS
0:: Error_Stack...
0:: ORA-01031: insufficient privileges
0::
0:: Error_Backtrace...
0:: ORA-06512: at "SYS.DBMS_REDEFINITION", line 180
0:: ORA-06512: at "SYS.DBMS_REDEFINITION", line 3780
0:: ORA-06512: at "SAPSR3.IOTC", line 718
0::
0:: Fatal error - See preceding lines
0:: Error_Stack...
0:: ORA-01031: insufficient privileges
0::
0:: Error_Backtrace...
0:: ORA-06512: at "SAPSR3.IOTC", line 844
0:: ORA-06512: at "SAPSR3.IOTC", line 601
0::
0:: Fatal error - See preceding lines
BEGIN iotc.convert (10); END;
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SAPSR3.IOTC", line 619
ORA-06512: at line 1
So I tried again reducing the number
SQL> exec iotc.convert (5);
BEGIN iotc.convert (5); END;
*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "SAPSR3.IOTC", line 619
ORA-06512: at line 1
SQL> quit
Any ideas what's causing this and how I can fix it?
Thanks
Craig