Background documentationAccess to Objects Locate this document in the navigation structure

 

The SQL syntax elements for Oracle Version 7 and SAP MaxDB in ORACLE SQL mode differ with regard to object access, among other things.

If a schema is not specified when a database object is accessed, and no object belonging to the current user exists with this name, the following procedure (which is different from Oracle) applies for MaxDB when the database object is accessed:

  1. SAP MaxDB searches for this object in the PUBLIC synonyms.

  2. If the object was not found, SAP MaxDB searches for this object in the part of the database catalog of the database administrator that the current user generated.

  3. If the object was not found, SAP MaxDB searches for this object in the database administrator's part of the database catalog.

More Information

SQL Syntax Elements: Differences