[ Pobierz całość w formacie PDF ]
.)Note: In V6 compatibility mode, a CHAR variable is variable length, rather thanfixed.Examples VARIABLE balance NUMBERVARIABLE ename CHAR(20)B-36 Oracle Enterprise Manager Administrator s Guide CCompatibility with SQL*DBAThis appendix lists the differences between Oracle7 SQL*DBA and Server ManagerDBA commands.Compatibility with SQL*DBA C-1 Figure C 1 Functional DifferencesFeature SQL*DBA Server ManagerDESCRIBE Lists information about the Lists the definition of the procedure argumentfor PL/SQL procedure argument in a tabularformPRINT Does nothing Prints all defined variablesPRINT SQLDBA> print a SVRMGR> print a(before connect) DBA-00302: not connected to a Adatabase ----------10SET CHARWIDTH Displays a character string Displays the number of characters specified byequivalent to the number of bytes CHARWIDTH regardless of the number of bytesrequired.For example, if used by the character string.For example, ifCHARWIDTH is set to 14 and a CHARWIDTH is set to 14, 14 characters aretwo-byte character set is used, displayed.seven characters are displayed.SET COMPATIBILITY Unsupported Server Manager uses the native SQL of theNATIVE database to which you are connectedSHOW SQLDBA> show Prints current Server Manager settingsshow*DBA-00115: unexpected end ofcommandSPOOL SQLDBA> spool SVRMGR> spoolFile sqldba.l og opened.Name for the spool file: (svrmgr.log)No prompt Prompts for a filename.The default isSVRMGR.LOG.STARTUP If any step of STARTUP fails, If any step of STARTUP fails, Server ManagerSQL*DBA backs out and leaves leaves the database in its current state.Forthe database in a shutdown state.example, if an error is encountered after themount stage, Server Manager leaves the databasemounted.VARIABLE a CHAR Default size is 1 Default size is CHARWIDTH@ SQLDBA> @ SVRMGR> @ORA-07225:.Name of script file:Prints an error Prompts for the name of the fileEmpty line SQLDBA> garbage SVRMGR> garbage2> 2>SQLDBA>; 3>;SQLDBA> garbage *ORA-00900: invalid SQL statementSVRMGR>C-2 Oracle Enterprise Manager Administrator s Guide Figure C 2 Cosmetic DifferencesFeature SQL*DBA Server ManagerSQLDBA> SVRMGR>PromptSQL*DBA Server ManagerProduct BannerSQLDBA> connect internal con- SVRMGR> connect internal con-Connect to idle instancenected.nected to an idle instance.A APRINT a-------------------- 10101 row selected.The variable name is not space padded:The variable name is space padded: A A .Also, no feedback is listed.SQLDBA> set echo on SQLDBA> SVRMGR> set echo onSETEcho ONSVRMGR>Server Manager echoes the new valueDBA-xxxxx:.MGR-xxxxx:.Error Message PrefixWrapping text Writes 80 characters and then wraps Writes the entire width and relies on thedisplay device to deal with wrapping.This is better for wide terminals.Compatibility with SQL*DBA C-3 Figure C 3 Unsupported OptionsFeature SQL*DBA Server ManagerRECOVERY prompt FROM clause is unsup-portedSET FLAGGER ENTRYSET FLAGGER.Unsupported: Use the ALTER SESSIONSET FLAGGER statementSHOW FLAGGER Shows FLAGGER value UnsupportedSET LABELWIDTH UnsupportedSET RETRIES UnsupportedSHOW VARIABLES Shows all defined variables Unsupported: Use the PRINT commandSHOW VAR with no argumentsSHUTDOWN dbname UnsupportedC-4 Oracle Enterprise Manager Administrator s Guide Obsolete FunctionalityObsolete FunctionalityFeature SQL*DBA Server ManagerSET ARRAYSIZE Changes the size of each No longer used: Server Manager au-fetch call tomatically chooses optimum fetch size.SET CYCLE Sets the monitor interval No longer usedSET/SHOW DISP- Line mode No longer usedWIDTHSET HISTORY Screen mode No longer usedSET LINES Screen mode No longer usedSET/SHOW LOG- Line mode No longer usedWIDTHSET TERM Screen mode No longer usedCompatibility with SQL*DBA C-5 Operational DifferencesOperational DifferencesFeature SQL*DBA Server Manager>sqldba @script.sql >svrmgrl command = @script [ Pobierz całość w formacie PDF ]