Oracle7 Server Messages

Contents Index Home Previous 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 SQL*Net CONNECT string was specified for the instance name.
Action:Refer to the SQL*Net documentation for a complete description of SQL*Net 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 Oracle7 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 Oracle7 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 Oracle7 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 Oracle7 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.


Contents Index Home Previous Next