Oracle7 Server Manager User's Guide

**Compatibility with SQL*DBA**

Functional Differences
Cosmetic Differences
Unsupported Options
Obsolete Functionality

This appendix lists the differences between Oracle7 SQL*DBA and Server Manager.

Functional Differences

*Feature*	**SQLDBA***	*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

Cosmetic Differences

*Feature*	**SQLDBA***	*Server Manager*
Prompt	`SQLDBA>`	`SVRMGR>`
Product Banner	`SQL*DBA`	`Server Manager`
Connect to idle instance	`SQLDBA> connect internal Connected.`	`SVRMGR> connect internal Connected to an idle instance.`
PRINT a	`A ---------- 10 1 row selected.` The variable name is space padded: "A ".	`A ---------- 10` The variable name is not space padded: "`A`". Also, no feedback is listed.
SET	`SQLDBA> set echo on SQLDBA>`	`SVRMGR> set echo on Echo ON SVRMGR>` Server Manager echoes the new value
Error Message Prefix	`DBA-xxxxx: ...`	`MGR-xxxxx: ...`
Wrapping text	Writes 80 characters and then wraps	Writes the entire width and relies on the display device to deal with wrapping. This is better for wide terminals.

Table C - 2. Cosmetic Differences

Unsupported Options

*Feature*	**SQLDBA***	*Server Manager*
RECOVERY prompt		FROM <logsource> clause is unsupported
SET FETCHROWS	Limits the total number of rows to fetch	Unsupported
SET FLAGGER...	`SET FLAGGER ENTRY`	Unsupported: Use the ALTER SESSION SET FLAGGER statement
SHOW FLAGGER	Shows FLAGGER value	Unsupported
SET LABELWIDTH		Unsupported
SET RETRIES		Unsupported
SHOW VARIABLES SHOW VAR	Shows all defined variables	Unsupported: Use the PRINT command with no arguments
SHUTDOWN dbname		Unsupported
VARIABLE a DATE		Unsupported

Table C - 3. Unsupported Options

Obsolete Functionality

Feature	SQL*DBA	Server Manager
SET ARRAYSIZE	Changes the size of each fetch call	No longer used: Server Manager automatically chooses optimum fetch size.
SET CYCLE	Sets the monitor interval	No longer used
SET/SHOW DISPWIDTH	Line mode	No longer used
SET HISTORY	Screen mode	No longer used
SET LINES	Screen mode	No longer used
SET/SHOW LOGWIDTH	Line mode	No longer used
SET TERM	Screen mode	No longer used

Table C - 4. Obsolete Functionality

Copyright © 1996 Oracle Corporation.
All Rights Reserved.