Release 1.6.0
A63734-01
Library |
Product |
Contents |
Index |
| Oracle
Enterprise Manager Messages Manual
Release 1.6.0 A63734-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. Can not 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 can not currently be analyzed or tuned through Oracle SQL Analyze.
VMQ-00004: Unable to fetch data.
Cause: Oracle SQL Analyze could not view the parameters for the connected database. This might be because Oracle SQL Analyze does not supprot 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 error occurred.
Action: Retry the operation. If this message continues, contact Oracle Worldwide Customer Support.
VMQ-00006: SQL syntax error.
Cause: A SQL statement 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 dataabse.
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: Incorrect hint syntax in the query.
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 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-00015: This user connection is not connected.
Cause: An oepration was performed against a database that has not been connected.
Action: Expand the database node in the Navigator window to connect the database. Then re-try the operation.
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 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 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.
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.
Cause: Oracle SQL Analyze could not read the specified object. The database might be corrupted.
Action: Contact Oracle Worldwide Customer Support.
VMQ-00024: TopSQL operation cannot be performed. None of the sessions for this database are connected.
Cause: Oracle SQL Analyze was unable to connect to the target database.
Action: Change your preferred credentials, save your repository, and close SQL Analyze. Then re-open SQL Analyze.
VMQ-00026: Unable to create PLAN_TABLE
Cause: Oracle SQL Analyze could not create a plan table because the appropriate CREATE TABLE privileges are not available, or there is not enough rooom 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
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: 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
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. Enter a new label that is not empty and contains fewer than 256 characters.
Cause: A SQL statement was entered that was either empty or more than 255 haracters long.
Action: Enter a new label for the statement that has at least one character and is less than 256 characters long.
VMQ-00040: The Explain Plan operation could not complete because the SQL statement contains ambiguous references. The 'Choose An Owner' dialog was canceled.
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: Oracle SQL Analyze was unable to access the V$version table for this information.
Action: Ensure that you have access privileges for V$version.
VMQ-00045: Can not drop! The database is either not connected or busy.
Cause: A drag and drop operation failed because the target database was not connected.
Action: Expand the target database, then drag the SQL statement over the database object in the Navigator window.
