SQL*DBA to Oracle Server Manager Migration Guide | ![]() Library |
![]() Product |
![]() Contents |
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.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> |
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. |
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 | |
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 |
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> / | |
![]() ![]() Prev Next |
![]() Copyright © 1996 Oracle Corporation. All Rights Reserved. |
![]() Library |
![]() Product |
![]() Contents |