ORA-18008: cannot find OUTLN schema

Today, outln disappeared for no reason, and no information was deleted from the alter log in the background. Cannot be created again

Create user outln identified by outln

*

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1

ORA-18008: cannot find OUTLN schema

It was very depressing, and it was not allowed to be created even after it disappeared.

You can only view the cause through the dump file in the background.

Sqlplus/as sysdba

Alter session set events '18008 trace name errorstack level 3 ';

Alter session set events '2017 trace name context forever, level 12 ';

Create user outln identified by outln;

View logs in the background.

We know the trigger problem is: MDSYS. SDO_ST_SYN_CREATE

Alter trigger MDSYS. SDO_ST_SYN_CREATE disable;

Create user outln identified by outln;

Alter trigger MDSYS. SDO_ST_SYN_CREATE enable;

After that, there will be no ORA-18008: cannot find OUTLN schema.

Attached: OUTLN User Creation statement

DECLARE
User_exists EXCEPTION;
Outln_user number;
Outln_tables number;
Extra_outln_tables number;
DDL_CURSOR integer;
BEGIN
Select count (*) into outln_user from user $ where name = 'outln ';

Select count (*) into outln_tables from obj $ where name in
('Ol $ ', 'ol $ HINTS', 'ol $ NODES ') and owner # =
(Select user # from user $ where name = 'outln ');

Select count (*) into extra_outln_tables from obj $ where name not in
('Ol $ ', 'ol $ HINTS', 'ol $ NODES ') and type # = 2 and owner # =
(Select user # from user $ where name = 'outln ');

DDL_CURSOR: = dbms_ SQL .open_cursor;
IF outln_user = 0 THEN
Dbms_ SQL .parse (DDL_CURSOR, 'create user outln identified by outln ',
Dbms_ SQL .native );
Dbms_ SQL .parse (DDL_CURSOR,
'Grant connect, resource, execute any procedure to outln ',
Dbms_ SQL .native );
Dbms_ SQL .parse (DDL_CURSOR, 'create table outln. ol $ ('|
'Ol _ name varchar2 (30), '|
'SQL _ text long,' |
'Textlen number, '|
'Signature raw (16), '|
'Hash _ value number, '|
'Hash _ value2 number, '|
'Category varchar2 (30), '|
'Version varchar2 (64), '|
'Creator varchar2 (30), '|
'Timestamp date, '|
'Flags number, '|
'Hintcount number, '|
'Spare1 number, '|
'Spare2 varchar2 (1000) ', dbms_ SQL .native );
Dbms_ SQL .parse (DDL_CURSOR, 'create table outln. ol $ hints ('|
'Ol _ name varchar2 (30), '|
'Hint # number, '|
'Category varchar2 (30), '|
'Hint _ type number, '|
'Hint _ text varchar2 (512), '|
'Stage # number, '|
'Node # number, '|
'Table _ name varchar2 (30), '|
'Table _ tin number, '|
'Table _ pos number, '|
'Ref _ id number, '|
'User _ table_name varchar2 (64), '|
'Cost FLOAT (126), '|
'Cardinality FLOAT (126), '|
'Bytes FLOAT (126), '|
'Hint _ textoff number, '|
'Hint _ textlen number, '|
'Join _ pred varchar2 (2000), '|
'Spare1 number, '|
'Spare2 number, '|
'Hint _ string clob) ', dbms_ SQL .native );
Dbms_ SQL .parse (DDL_CURSOR, 'create table outln. ol $ nodes ('|
'Ol _ name varchar2 (30), '|
'Category varchar2 (30), '|
'Node _ id number, '|
'Parent _ id number, '|
'Node _ type number, '|
'Node _ textlen number, '|
'Node _ textoff number, '|
'Node _ name varchar2 (64) ', dbms_ SQL .native );
Dbms_ SQL .parse (DDL_CURSOR, 'create unique index outln. ol $ name' |
'On outln. ol $ (ol_name) ', dbms_ SQL .native );
Dbms_ SQL .parse (DDL_CURSOR, 'create unique index outln. ol $ signature '|
'On outln. ol $ (signature, category) ', dbms_ SQL .native );
Dbms_ SQL .parse (DDL_CURSOR, 'create unique index outln. ol $ hnt_num '|
'On outln. ol $ hints (ol_name, hint #) ', dbms_ SQL .native );
Dbms_output.put_line ('outln creation successful ');
ELSE
IF outln_tables! = 3 or extra_outln_tables! = 0 THEN
Dbms_output.put_line ('error-outln user already exists ');
RAISE user_exists;
ELSE
Dbms_output.put_line ('outln creation successful ');
End if;
End if;

EXCEPTION
WHEN user_exists THEN
RAISE;

END;
/

Alter user outln account lock;

10g R2 outln user documentation

Subject: Script. to create user OUTLN in 10.2
Doc ID: 422983.1 Type: SCRIPT
Modified Date: 04-SEP-2008 Status: PUBLISHED

9i reference documents are as follows:
Subject: Script. to create user OUTLN in 9i
Doc ID: 240478.1 Type: SCRIPT
Modified Date: 08-DEC-2008 Status: PUBLISHED

8i reference documents are as follows:
Subject: Script. to create user OUTLN in 8i
Doc ID: 98572.1 Type: BULLETIN
Modified Date: 10-JUN-2003 Status: PUBLISHED

1 2 Next Page