oracle»ù±¾ÃüÁî

һЩ»ù±¾µÄOracleÃüÁî
»ù±¾ÃüÁî
Á¬½ÓÊý¾Ý¿â
C:>SQLPLUS /NOLOG
SQL>CONN / AS SYSDBA
1.Oracle ¹Ø±Õ
SQL>SHUTDOWN (ABORT|IMMEDIATE|NORMAL)
2.Oracle Æô¶¯
SQL>STARTUP (REMOUNT|MOUNT|OPENT)
3.SQL> HELP SHOW
SHOW
----
Shows the value of a SQL*Plus system variable, or the
current SQL*Plus environment.
SHO[W] option
where option represents one of the following terms or clauses:
     system_variable
     ALL
     BTI[TLE]
     ERR[ORS] [{FUNCTION | PROCEDURE | PACKAGE | PACKAGE BODY | TRIGGER
        | VIEW | TYPE | TYPE BODY | DIMENSION | JAVA CLASS} [schema.]name]
     LNO
     PARAMETERS [parameter_name]
     PNO
     REL[EASE]
     REPF[OOTER]
     REPH[EADER]
     SGA
     SPOO[L]
     SQLCODE
     TT[ITLE]
     USER
SHOW SPOOL is not available in iSQL*Plus
4.TNSPING
TNSÁ¬½ÓÎÊÌâ¼ì²â
TNSNAME.ORA
5.Ö´ÐÐSQL Script
SQL>@C:\RUN.SQL
6.²é¿´Ö´Ðнá¹û£¨¿ªÆô/¹Ø±Õ£©
SQL>SET ECHO ON(OFF)
7.³£ÓÃÅäÖÃ
SQL>SET LINESIZE 1000
SQL>ECHO ON
SQL>SET TIMING ON
SQL>SPOOL C:\TEST.LOG
SQL>SELECT * from XXXXX
SQL>SPOOL OFF
8.ÊÚȨ
½¨Á¢Á¬½Ó GRANT CREATE SESSION TO USERNAME
ÒƳýÁ¬½Ó REVOKE CREATE SESSION TO USERNAME
ÆäËûÊÚȨ
GRANT SELECT,INSERT,DELETE,UPDATE ON SCOTT.EMP TO USERNAME
È·Èϸü¸Ä
SQL>COMMIT
9.¸ü¸ÄÃÜÂë
Alter user username identified by password
10.²ì¿´Datafile
SQL>SELECT * from V$DATAFILE
11²ì¿´½á¹¹
SQL>DESC V$DATAFILE
12,²ì¿´DB File
SQL>SELECT * from V$DBFILE
13.²ì¿´Tablespace
SQL>SELECT * from V$TABLESPACE
14.²ì¿´SGA´óС
SQL> SHOW PARAMETER SGA
15.¸ü¸Ä SGA´óС£¬
SQL>ALTER SY