Oracle Enterprise Manager Administrator's Guide

Library

Product

Contents

Index

Compatibility with SQL*DBA

• 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. 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 orSVRMGR quit Aborting a command Hit twiceorEnter a period (.) by itself on a line. Enter a period (.) by itself on a line. This procedure applies to Server Manager lLine 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 Index

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

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.

Prev Next

Copyright © 1996 Oracle Corporation. All Rights Reserved.

Library

Product

Contents

Index