ORA-19381: Cannot Create Staging Table In SYS Schema - Learnomate Technologies

ANKUSH THAVALI
17 Dec, 2023
0 Comments
1 Min Read

ORA-19381: Cannot Create Staging Table In SYS Schema

PROBLEM:

While creating a staging table in oracle database for SYS user, for storing baseline, we got this error.

Solution :

Staging tables can’t be created under SYS user. So try to create the staging table from other USERS.

SQL> connect LEARNOMATE
Enter password:
Connected.

SQL> show user
USER is "LEARNOMATE"

SQL> BEGIN
DBMS_SPM.CREATE_STGTAB_BASELINE(
table_name => 'spm_stageing_tab',
tablespace_name => 'USERS');
END;
/
2 3 4 5 6
PL/SQL procedure successfully completed.