DBA Cockpit: SQL Command Editor and table namespace

July 23, 2009 at 8:48 am

[] [] [] [] [] [] [] [] []

  1. ORA: Schema name is ignored in DBA Cockpit Setup WizardSymptom On the first screen of the DBA Cockpit setup wizard in the SAP Solution Manager, the user provides the database schema. On the next screen, this information is lost (user name)....
  2. DB6: DBA Cockpit Correction Collection SAP Basis 7.00 / 7.10Symptom This SAP Note is used as a collection of corrections for the DBA Cockpit in SAP Basis Release 7.00 and SAP Basis Release 7.10. This SAP Note includes other required SAP...
  3. DB6: DBA Cockpit Correction Collection SAP Basis 7.01 / 7.11Symptom This SAP Note is used as a collection of corrections for the DBA Cockpit in SAP Basis Release 7.01 and SAP Basis Release 7.11. This SAP Note includes other required SAP...
  4. Applications must not be created in customer namespaceSymptom It was possible to create and ship applications at SAP with names in the customer namespace: Y* or Z*. Reason and Prerequisites Program error Solution Correction ...
  5. DBACOCKPIT: Display error if system change DBA/backup logsSymptom When you use the “Backup Logs” or “DBA Logs” function in the DBA Cockpit and change the selected remote system, the detail display of the log may not work and the...

Symptom

This note is valid for the DBA Cockpit on SAP with the Oracle database.
The SQL Command Editor in Basis Releases 7.00 and 7.10 cannot process tables that have a namespace entry. In an SQL statement, if you use //

tables, such as
select * from “//
”
(the double quotation marks are important),
(even though the table exists and can be accessed), the system
issues the following error messages:
“The following table does not exist:
”
and
“Insufficient privilege to access specified table”.

Other terms

DBA Cockpit, SQL Command Editor
Reason and Prerequisites

This problem is caused by a program error.
Solution

Implement the corrections or import the relevant Support Package.

[Slashdot] [Digg] [Reddit] [del.icio.us] [Facebook] [Technorati] [Google] [StumbleUpon]

Leave a Comment