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.

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.

 

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>

 

Figure C-2 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.

 

Figure C-3 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 © 1997 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