ORA-01400: cannot insert NULL into ("SYS"."WRI$_SQLSET_PLAN_LINES"."CON_DBID")
Hello All,
When trying to Capture STS from Cursor Cache below error is seen.
Please advice.
Env:
AIX 7.1
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit
SQL> set timing on
SQL> set serveroutput on
SQL> prompt
SQL> prompt Creating STS for Cursor Cache
STS for Cursor Cache
SQL> prompt
SQL> prompt
SQL> prompt
SQL>
SQL>
SQL> BEGIN
2 SYS.DBMS_SQLTUNE.CREATE_SQLSET (
3 sqlset_name => 'STS_Upg_Cache',
4 description => 'Plans before DB upgrade');
5 END;
6 /
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.30
SQL> prompt
SQL> prompt Capturing STS from Cursor Cache
Capturing STS from Cursor Cache
SQL> prompt
SQL> prompt
SQL> prompt
SQL>