Oracle8 Error Messages
Release 8.0.4

A58312-01

Library

Product

Contents

Index

Prev Prev Next

00001-00199: SQL*DBA Messages

DBA-00072: warning: name created with compilation errors

Cause: The package, package body, procedure, or function could not be created because there were code errors.

Action: Enter the SHOW ERRORS command and correct the listed compilation errors.

DBA-00073: warning: name created with compilation errors

Cause: The package, package body, procedure, or function could not be created because there were code errors.

Action: Enter the SHOW ERRORS command and correct the listed compilation errors.

DBA-00100: invalid SPOOL filename

Cause: When using the SPOOL command, the name of a file that already exists was specified.

Action: Specify a valid name for a file that does not currently exist.

DBA-00101: extraneous text at end of command

Cause: There were unrecognized commands or other text on the command line.

Action: Check the syntax of the command and issue the command again.

DBA-00102: missing LOG keyword

Cause: The LOG keyword was missing from the ARCHIVE LOG command.

Action: Check the syntax of the command and issue the command again.

DBA-00103: illegal ARCHIVE LOG option

Cause: An option specified was not LIST, STOP, START, NEXT, ALL, a number, or a filename in the ARCHIVE LOG command.

Action: Check the syntax of the command and issue the command again.

DBA-00104: illegal RECOVER option

Cause: An option specified was not DATABASE, MANUAL, UNTIL, TABLESPACE, or DATAFILE in the RECOVER command.

Action: Check the syntax of the command and issue the command again.

DBA-00105: invalid INSTANCE name

Cause: An invalid Net8 CONNECT string was specified for the instance name.

Action: Refer to the Net8 documentation for a complete description of Net8 CONNECT strings.

DBA-00106: invalid ECHO switch

Cause: An invalid option for the SET ECHO command was specified.

Action: Use either ON or OFF as an option for the SET ECHO command.

DBA-00107: invalid TERMOUT switch

Cause: An invalid option for the SET TERMOUT command was specified.

Action: Use either ON or OFF as an option for the SET TERMOUT command.

DBA-00108: invalid TIMING switch

Cause: An invalid option for the SET TIMING command was specified.

Action: Use either ON or OFF as an option for the SET TIMING command.

DBA-00109: invalid CYCLE value

Cause: An invalid value for the SET CYCLE command was specified.

Action: The SET CYCLE command must use an integer between 1 and 3600.

DBA-00110: illegal SET option

Cause: An invalid option for the SET command was specified.

Action: Check the syntax of the SET command in Oracle8 Server Utilities and issue the command again.

DBA-00111: illegal SHOW option

Cause: An invalid option for the SHOW command was specified.

Action: Check the syntax of the SHOW command in Oracle8 Server Utilities and issue the command again.

DBA-00113: invalid PFILE name

Cause: The specified PFILE name is not recognized.

Action: Specify a legal PFILE name.

DBA-00114: invalid database name

Cause: The specified database name is not recognized.

Action: Specify a legal database name.

DBA-00115: unexpected end of command

Cause: An option was specified without any arguments. For example:

SQLDBA> STARTUP OPEN PFILE 

Action: Check the syntax of the command and enter the command again with the appropriate arguments for options that require values.

DBA-00116: illegal SHUTDOWN option

Cause: An option was specified that was not NORMAL, IMMEDIATE, or ABORT for the SHUTDOWN command.

Action: Check the syntax of the command and issue the command again.

DBA-00117: invalid tablespace name

Cause: The specified tablespace name was not recognized.

Action: Specify a legal tablespace name.

DBA-00118: invalid process identifier or invalid statistics class

Cause: Something other than a number for a process identifier, or an invalid class was specified after the MONITOR STATISTICS command.

Action: Specify only numbers as process identifiers or specify a valid class for the MONITOR STATISTICS command.

DBA-00119: illegal STARTUP option

Cause: An option was specified that was not DBA, PFILE, EXCLUSIVE, SHARED, MOUNT, OPEN, RECOVER, or NOMOUNT for the STARTUP command.

Action: Check the syntax of the command and issue the command again.

DBA-00120: invalid STOPONERROR switch

Cause: An invalid option was specified for the SET STOPONERROR command.

Action: Use either ON or OFF as an option for the SET STOPONERROR command.

DBA-00121: illegal MONITOR option

Cause: An illegal option was specified for the MONITOR command.

Action: Check the syntax of the MONITOR command in Oracle8 Server Utilities and issue the command again.

DBA-00122: invalid SET numeric parameter

Cause: A character or an invalid value was specified when a number was expected as a value for a SET command option.

Action: Check the syntax of the command, use an appropriate number for the option, and enter the command again.

DBA-00123: invalid tablespace name list

Cause: An invalid string was specified as one of the values in the list of tablespaces in the ARCHIVE LOG command. For example,'"' is an invalid string.

Action: Check the syntax of the command, use valid tablespace names for all names in the list, and enter the command again.

DBA-00124: invalid ARCHIVE destination

Cause: The specified ARCHIVE destination was not recognized.

Action: Specify a legal ARCHIVE destination.

DBA-00125: integer value overflow

Cause: A numeric value was specified that was too large.

Action: Use a smaller number.

DBA-00126: invalid VERIFY switch

Cause: The VERIFY switch was not recognized.

Action: Specify a legal VERIFY switch.

DBA-00127: invalid combination of STARTUP options

Cause: The specified options of the STARTUP command cannot be used simultaneously. For example, the following command is not valid:

SQLDBA> STARTUP MOUNT OPEN testdb 

Action: Check the syntax of the STARTUP command in Oracle8 Server Utilities for options that can be used together.

DBA-00128: invalid DEBUG switch

Cause: The DEBUG switch was not recognized.

Action: Specify a legal DEBUG switch.

DBA-00129: value out of range (1 - num)

Cause: The specified value was out of range. The valid range is given by the error message.

Action: Use a number within the range specified by this error.

DBA-00131: invalid ARCHIVE TO device

Cause: The specified ARCHIVE TO device was not recognized.

Action: Specify a legal ARCHIVE TO device.

DBA-00132: null hostname/password specified

Cause: hostname/password was not specified.

Action: Specify the correct hostname/password.

DBA-00133: invalid datafile list

Cause: An invalid string was entered as one of the values in the list of datafiles in the ARCHIVE LOG command. For example, '"' is an invalid string.

Action: Check the syntax of the command, use valid datafile names for all names in the list, and enter the command again.

DBA-00134: invalid AUTORECOVERY switch

Cause: An invalid option was specified for the SET AUTORECOVERY command.

Action: Use either ON or OFF as options for the SET AUTORECOVERY command.

DBA-00136: bad variable specification

Cause: A variable was incorrectly specified using the VARIABLE command.

Action: Check the syntax of the command and issue the command again.

DBA-00137: syntax error in PL/SQL Block

Cause: The PL/SQL block contains a syntax error.

Action: Correct the syntax error.

DBA-00139: invalid ALTER DATABASE option

Cause: The specified ALTER DATABASE option was not recognized.

Action: Specify a legal option.

DBA-00140: invalid COMPATIBILITY switch

Cause: The specified COMPATIBILITY switch was not recognized.

Action: Specify a legal COMPATIBILITY switch.

DBA-00141: invalid RETRIES value

Cause: The specified RETRIES value was not recognized.

Action: Specify a legal RETRIES value.

DBA-00142: cannot recognize object type, owner or name

Cause: The specified object type, owner, or name was not recognized.

Action: Specify a legal object type, owner or name.

DBA-00143: variable has not been defined

Cause: The specified variable was not recognized.

Action: Specify an existing variable.

DBA-00144: invalid object type for DESCRIBE

Cause: The specified object type was not TABLE, VIEW, or PROCEDURE.

Action: Check that the object is a table, view, or procedure. If so, check that you specified the correct name and try again. If not, you cannot DESCRIBE the object.

DBA-00145: invalid object name for DESCRIBE

Cause: The specified table, view, stored procedure or function was not recognized.

Action: Check spelling and specify an existing table, view, stored procedure, or function.

DBA-00146: invalid HISTORY value

Cause: The specified HISTORY value was not recognized.

Action: Specify a legal HISTORY value.

DBA-00147: invalid LINES value

Cause: The specified LINES value was not recognized.

Action: Specify a legal LINES value.

DBA-00148: invalid TERM switch (use either PAGE or NOPAGE)

Cause: The specified value was not recognized.

Action: Specify a legal value.

DBA-00149: invalid SERVEROUTPUT switch

Cause: The specified value was not recognized.

Action: Specify a legal value.

DBA-00150: invalid FLAGGER switch

Cause: The specified value was not recognized.

Action: Specify a legal value.




Prev

Top

Next
Oracle
Copyright © 1997 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index