This appendix lists the differences between Oracle7 SQL*DBA and Server Manager DBA commands.
Figure C-1 Functional Differences
Feature
SQL*DBA
Server Manager
DESCRIBE for PL/SQL
Lists information about the procedure argument in a tabular form
Lists the definition of the procedure argument
PRINT <no args>
Does nothing
Prints all defined variables
PRINT (before connect)
SQLDBA> print a DBA-00302: not connected to a database
SVRMGR> print a A ---------- 10
SET CHARWIDTH
Displays a character string equivalent to the number of bytes required. For example, if CHARWIDTH is set to 14 and a two-byte character set is used, seven characters are displayed.
Displays the number of characters specified by CHARWIDTH regardless of the number of bytes used by the character string. For example, if CHARWIDTH is set to 14, 14 characters are displayed.
SET COMPATIBILITY NATIVE
Unsupported
Server Manager uses the native SQL of the database to which you are connected
SHOW <no args>
SQLDBA> show show * DBA-00115: unexpected end of command
Prints current Server Manager settings
SPOOL <no args>
SQLDBA> spool File sqldba.l og opened... No prompt
SVRMGR> spool Name for the spool file: (svrmgr.log) Prompts for a filename. The default is SVRMGR.LOG.
STARTUP
If any step of STARTUP fails, SQL*DBA backs out and leaves the database in a shutdown state.
If any step of STARTUP fails, Server Manager leaves the database in its current state. For example, if an error is encountered after the mount stage, Server Manager leaves the database mounted.
VARIABLEaCHAR
Default size is 1
Default size is CHARWIDTH
@<no args>
SQLDBA> @ ORA-07225: ... Prints an error
SVRMGR> @ Name of script file: Prompts for the name of the file