12345
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.123456789101112131415161718192021222324252627
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.