Namespace

The SQL syntax elements for Oracle Version 7 and MaxDB in SQL mode ORACLE differ, among other things, in the definition of namespaces.

Differences in the namespace

Oracle 7

MaxDB

All indexes of a database instance form a namespace.

All indexes of a table form a namespace.

All constraints of a database instance form a namespace.

All constraints of a table form a namespace.

All triggers of a database instance form a namespace.

All triggers of a table form a namespace.

All sequences, together with the tables, views, synonyms, procedures, and further objects, form a namespace.

All sequences of a database instance form a separate namespace.

All procedures, together with the tables, views, synonyms, and further objects, form a namespace.

All database procedures of a database instance form a separate namespace.