sqlplus sys/oracle as sysdba
或
sqlplus / as sysdba
conn/ as sysdba
基本操作
show user 查看当前用户身份
查看用户表结构描述
describe dba_users;
查询数据
select username,ACCOUNT_STATUS from dba_users;
对查询做列限制
col username for a30;
col ACCOUNT_STATUS for a30;
a order by 1;
锁账号
密码过期
alter user scott password EXPIRED;
修改密码
alter user scott identified by 111;
锁定
alter user scott account lock;
解锁
alter user scott account unlock;
库操作
停库
shut abort;
启库
startup
查看sql默认配置
show all
set linesize 190
set pagesize 100
修改默认配置
cd $ORACLE_HOME/sqlplus/admin
gsqlplus.sql 连接时候的配置