Reserved schema names
In general, for certain objects, schema names that begin with the prefix SYS are reserved. The schema name for these objects cannot begin with SYS except for certain exceptions.
The schema name for the objects listed in the following table must follow the restrictions listed in the table.
Recommendation: Do
not to use SESSION as a schema name.
Object | Schema name restriction | Schema name exceptions |
---|---|---|
Distinct types | Cannot begin with SYS | The schema name can be:
|
User-defined functions | Cannot begin with SYS | The schema name can be:
|
Stored procedures | Cannot begin with SYS | The schema name can be:
|
Sequences | Cannot begin with SYS | The schema name can be:
|
Triggers | Cannot begin with SYS | The schema name can be:
|
Column masks | Cannot begin with SYS | The schema name can be:
|
Row permissions | Cannot begin with SYS | The schema name can be:
|
Notes:
|