ORA-19381: Cannot Create Staging Table In SYS Schema

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarKiran Dalvi
  • 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.