Oracle7 Server Manager User's Guide Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents
Go to Index
Index



Go to previous file in sequence Go to next file in sequence

Compatibility with SQL*DBA


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


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


Cosmetic Differences

Feature SQL*DBA 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 SQL*DBA 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




Go to previous file in sequence Go to next file in sequence
Prev Next
Oracle
Copyright © 1996 Oracle Corporation.
All Rights Reserved.
Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents
Go to Index
Index