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 SYSTEM SET SHARED POOL SIZE M 16 察看 CONTROLFILE SQL SELECT FROM V CONTROLFILE 17 察看 REDO LOG SQL SELECT FROM V CONTROLFILE 18 察看所有的用户 SQL SELECT USERNAME FROM DBA USERS 19 在 Offline 状态下搬迁数据库文件 关闭数据库 SQL SHUTDOWN IMMEDIATE 搬迁数据文件 连接数据库 SQL CONN AS SYSDBA SQL STARTUP MOUNT SQL Alter database rename file e to c SQL ALTER DATABAS