Oracle Server Manager User's Guide

Contents Index Home Previous Next

Functional Differences

Feature SQL*DBA Server Manager
DESCRIBE DESCRIBE <object name> DESCRIBE <object type> <object name>
DESCRIBE for PL/SQL Lists information about the procedure's arguments in a tabular form Lists the definition of the procedure's arguments
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 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.log 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.
VARIABLE a CHAR 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
Empty line SQLDBA> garbage 2> SQLDBA>; SQLDBA> SVRMGR> garbage 2> 3>; garbage * ORA-00900: invalid SQL statement SVRMGR>
Table C - 1. Functional Differences


Contents Index Home Previous Next