Background documentationNamespace Locate this document in the navigation structure

 

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

Differences in the namespace

Oracle 7

SAP 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.

More Information

SQL Syntax Elements: Differences