Oracle Enterprise Manager Administrator'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 DBA commands.

Functional Differences

Please refer to the following table for information.
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.

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>

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.

Unsupported Options
Feature

SQL*DBA

Server Manager

RECOVERY prompt

FROM <log source> clause is 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

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

Operational Differences
Feature

SQL*DBA

Server Manager

Executing a SQL script from the operating system command line

>sqldba @script.sql

>svrmgrl command = @script.sql

Executing a server command from the operating system command line

Unsupported

>svrmgrl command="connect x/y@z"

Entering a Server Manager command spanning multiple lines

Unsupported

Type a backslash (\) at the end of each line to indicate continuation.

SVRMGR> connect \
2> myrdb/password

Entering a quoted string spanning multiple lines

Type a backslash (\) at the end of each line to indicate continuation.

SVRMGR> select *
2> from emp
3> where ename = 'A\
4> BCDEF';

Exiting the application

SQLDBA> exit

SVRMGR> exit
or
SVRMGR> quit

Aborting a command

Hit <Return> twice
or
Enter a period (.) by itself on a line.

Enter a period (.) by itself on a line. This procedure applies to Server Manager l
Line Mode only.

SVRMGR> delete from emp
2> .
SVRMGR>

Executing the current SQL statement

Enter a slash (/) by itself on a line.

SVRMGR> select *
2> from emp
3> /




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