Oracle Enterprise Manager Messages Manual Release 9.0.1 Part Number A88758-01 |
|
VMQ-00001: Cannot use Hint Wizard here. Use Create Like to duplicate this SQL, then use Hint Wizard.
Cause: The Hint Wizard was launched on a read-only SQL statement. A SQL statement cannot be edited after an explain plan has been generated for it.
Action: Select File=>Create Like to create a copy of the statement on the Navigator Tree. Select the copy, then use the Hint Wizard with this file.
VMQ-00002: Hint Wizard will not add hints to INSERT, UPDATE or DELETE statements.
Cause: The Hint Wizard was launched on a statement containing INSERT, UPDATE, or DELETE statements. These statements are not currently supported.
Action: No action to be taken.
VMQ-00003: Not a DML (DELETE, INSERT, SELECT, UPDATE) statement. Cannot get the explain plan.
Cause: The statement does not use Data Manipulation Language (DML) commands. Statements that do not use DML commands do not have explain plans.
Action: This statement cannot currently be analyzed or tuned through Oracle SQL Analyze.
VMQ-00004: Unable to fetch database session parameters.
Cause: Oracle SQL Analyze could not view the parameters for the connected database. This might be because Oracle SQL Analyze does not support databases before Release 7.2, or because the V$parameter table is corrupted.
Action: If the database is Release 7.2 or above, contact Oracle Worldwide Customer Support.
VMQ-00005: Internal Error.
Cause: An internal error occurred.
Action: Retry the operation. If this message continues, contact Oracle Worldwide Customer Support.
VMQ-00006: Cannot validate SQL Syntax error: <string>.
Cause: A SQL statement was generated that was not syntactically correct.
Action: Review the statement for syntactical errors. Check the statement for possible spelling and typing errors.
VMQ-00007: This session must be connected to perform this operation.
Cause: The operation tried to access an unconnected database.
Action: Expand the database node in the Navigator window. This will connect the database and allow operations to be performed upon it.
VMQ-00008: The list of hints in the selected subquery cannot be parsed.
Cause: The query has an incorrect hint syntax.
Action: Review the hint syntax or remove hints altogether. Hints can be added to the statement with the Hint Wizard, which automatically verifies the syntax.
VMQ-00009: Internal error: invalid parameters specified for ANALYZE command
Cause: The percentage specified for the Estimate Statistics option of the Tuning Wizard was not an integer between 1 and 100.
Action: Specify a percentage between 1 and 100.
VMQ-00010: Unable to find Oracle8 ObjectID.
Cause: Oracle SQL Analyze could not locate the Oracle database.
Action: The database might be corrupted. Contact Oracle Worldwide Customer Support.
VMQ-00011: Unable to set parameter <parameter> at the session level.
Cause: An attempt was made to edit one of database parameters that cannot be changed from within Oracle SQL Analyze.
Action: Close Oracle SQL Analyze and change the parameter using Instance Manager, or by editing the init.ora file manually.
VMQ-00012: The alias or table name you chose conflicts with another name in the list.
Cause: The alias or table name chosen conflicts with another name in the list.
Action: Choose a valid alias or table name.
VMQ-00017: Cannot validate SQL statement.
Cause: Oracle SQL Analyze could not find a table or view referred to by the statement. An identifier in the SQL statement could not be resolved.
Action: Check to be sure you have privileges for that object.
VMQ-00018: An internal data format error occured. Can't proceed with the requested operation.
Cause: A data inconsistency within Oracle SQL Analyze triggered an internal error.
Action: Contact Oracle Worldwide Customer Support.
VMQ-00019: No bind variables have been specified because the bind variables dialog was canceled.
Cause: The bind variables dialog was canceled before bind variables could be specified.
Action: Retry the operation and do not cancel the bind variables dialog.
VMQ-00020: Object <object> exists, but is not a table or a view.
Cause: One of the identifiers in the SQL statement was not a table or a view. The operation called for by the SQL statement requires a table or view (for example, the statement may have tried to SELECT from an index).
Action: Check the SQL statement and correct the identifier.
VMQ-00021: The object <object> exists, but it is not the expected object type.
Cause: Oracle SQL Analyze could not read the object. The database might be corrupted.
Action: Contact Oracle Worldwide Customer Support.
VMQ-00022: The following value is inappropriate for this bind variable: <value>.
Cause: A non-numeric value was supplied for a numeric bind variable type.
Action: Enter a number for the bind variable value.
VMQ-00023: Unable to determine the type of the object <object>.
Cause: Oracle SQL Analyze could not read the specified object. The database might be corrupted.
Action: Contact Oracle Worldwide Customer Support.
VMQ-00026: Unable to create PLAN_TABLE
Cause: Oracle SQL Analyze could not create a plan table either because the appropriate CREATE TABLE privileges are not available, or because there is not enough room on the specified disk.
Action: Check to make sure you have CREATE TABLE privileges, and that the specified disk has enough space.
VMQ-00027: Unable to drop PLAN_TABLE
Cause: The plan table was the wrong version for the database. The appropriate access privileges may not be available.
Action: Consult with your database administrator (DBA) to drop the database.
VMQ-00028: Object not found error.
Cause: An attempt to validate a SQL query failed because the table or view referenced in the statement does not exist.
Action: Review the statement for syntactical errors. Check the statement for possible spelling and typing errors.
VMQ-00030: Tuning Wizard will not improve INSERT, UPDATE or DELETE statements.
Cause: The Tuning Wizard was launched on a statement containing INSERT, UPDATE, or DELETE statements. These statements are not currently supported.
Action: No action to be taken.
VMQ-00031: No session parameters can be set at the session level for Oracle 7.2 or earlier.
Cause: An attempt was made to edit one of database parameters that cannot be changed from within Oracle SQL Analyze.
Action: Close Oracle SQL Analyze and change the parameter using Instance Manager or by editing the init.ora file manually.
VMQ-00032: Repository manager cannot validate repository.
Cause: The Repository Manager failed or the repository was corrupted.
Action: Contact Oracle Worldwide Customer Support.
VMQ-00033: Unable to validate SQL statement: <string>.
Cause: An identifier in the SQL statement could not be resolved unambiguously.
Action: Check your statement for syntax, spelling, or typing errors.
VMQ-00034: The Oracle Enterprise Manager SDK is unavailable. The Oracle Enterprise Manager Console must be running while Oracle SQL Analyze is being used.
Cause: Either Oracle SQL Analyze was started before Oracle Enterprise Manager was started, or Oracle Enterprise Manager was closed while Oracle SQL Analyze was running.
Action: Re-start Oracle Enterprise Manager and leave it running while Oracle SQL Analyze runs.
VMQ-00035: Oracle Enterprise Manager SDK call failed: <string>.
Cause: The Oracle Enterprise Manager console failed for an undetermined reason.
Action: Contact Oracle Worldwide Customer Support.
VMQ-00036: Oracle Enterprise Manager SDK array access failed.
Cause: The Oracle Enterprise Manager console failed for an undetermined reason.
Action: Contact Oracle Worldwide Customer Support.
VMQ-00037: Session connection is being attempted on this database. Either stop this operation or wait until it finishes.
Cause: A second attempt to connect a database was made while the first attempt was still processing.
Action: Avoid clicking repeatedly on the database node. Stop this operation using something >= Cancel This Operation, or wait until it finishes.
VMQ-00038: You cannot delete this SQL item because there is a background operation in progress on it. Please cancel the current Explain Plan or Execute operation before deleting it.
Cause: A SQL statement could not be deleted because an Explain Plan or Execute option was being run against it.
Action: Cancel the operation, then delete the statement.
VMQ-00039: SQL statement labels must be between 1 and 255 characters long.
Cause: A SQL statement label was entered incorrectly.
Action: Enter a new label that is not empty and contains fewer that 256 characters.
VMQ-00040: The Explain Plan operation could not complete because the SQL statement contains ambiguous references.
Cause: The Choose an Owner dialog was canceled.
Action: Retry the Explain Plan operation. Do not cancel the dialog while the operation is in progress.
VMQ-00041: The SQL statement could not be validated because it contains ambiguous references. The 'Choose An Owner' dialog was canceled.
Cause: The Choose an Owner dialog was canceled.
Action: Bring up the Hint or Tuning Wizard. When the Choose An Owner dialog is opened, do not cancel the dialog until you have chosen the appropriate owner.
VMQ-00042: The 'Connect to Repository' operation cannot be canceled. Please wait for it to complete or exit Oracle SQL Analyze.
Cause: An attempt was made to cancel a repository connection while it was in progress.
Action: Wait for the operation to complete or exit Oracle SQL Analyze.
VMQ-00043: The 'Load Repository' operation cannot be canceled. Please wait for it to complete or exit Oracle SQL Analyze.
Cause: An attempt was made to cancel a repository connection while it was in progress.
Action: Wait for the operation to complete or exit Oracle SQL Analyze.
VMQ-00044: The Oracle RDBMS version is unavailable.
Cause: SQL Analyze cannot locate the Oracle RDBMS version it is expecting.
Action: Contact Oracle Worldwide Customer Support.
VMQ-00045: Unable to drop this SQL statement.
Cause: This database is either not connected or busy.
Action: Cancel the current operation on this database.
VMQ-00047: Cannot access private database link.
Cause: An attempt was made to access a database link that was created by another user. To access this link, Preferred Credentials must be set in the database.
Action: If possible, set up Preferred Credentials in the target database.
VMQ-00048: This service has already been discovered.
Cause: An attempt was made to discover a database that was previously discovered.
Action: Specify a different database.
VMQ-00049: Unable to contact the Oracle Management Server.
Cause: The Oracle Management Server may not be running or the repository may be unavailable.
Action: Ensure that the Oracle Management Server is running and that the repository database is available.
VMQ-00050: Internal error: unable to obtain repository credentials from the Oracle Management Server.
Cause: The client machine cannot obtain the repository credentials from the Oracle Management Server.
Action: Verify that the Oracle Management Server is running and that the client machine has access to it.
VMQ-00057: Error loading repository.
Cause: An error occurred while attempting to load this repository.
Action: Contact Oracle Worldwide Customer Support.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|