Oracle常用sql语句

--创建表空间
create tablespace WT
datafile 'H:\WT.dbf'
size 1024M autoextend on next 200M maxsize unlimited;

--创建临时表空间
create temporary tablespace WT_TEMP
tempfile 'H:\WT_TEMP.dbf'
size 500M
autoextend on
next 100M maxsize 1024M;

--创建用户
create user wt identified by a
default tablespace WT
temporary tablespace WT_TEMP
account unlock;

--修改密码
alter user wt identified by admin;

--解锁
alter user wt account unlock;

--赋权
grant resource,connect,DBA to wt;

--查看进程
select username,sid,serial# from v$session;

--杀死进程
alter system kill session'147,1250';

--删除用户
DROP USER wt CASCADE;

--删除表空间
alter tablespace WT offline;
drop tablespace WT including contents and datafiles;

--删除临时表空间
drop tablespace WT_TEMP including contents and datafiles;

--导出用户数据
exp wt/a@orcl file=h:\data.bmp log=h:\log

--导入用户数据
imp wt/a@orcl file=h:\data.dmp log=h:\log full=y ignore=y

--查看当前进程运行个数
select count(*) from v$process;

--查看进程上限
select value from v$parameter where name = 'processes';

--修改进程数量
alter system set processes=400 scope=spfile;

--查看当前会话运行个数
select count(*) from v$session;

--查看会话上限
select value from v$parameter where name = 'sessions';

--修改会话数量
alter system set sessions=455 scope=spfile;

--远程登录
sqlplus username/password@远程ip:端口/实例
--例
sqlplus username/paassword@10.1.123.93:1521/orcl

--telnet
telnet 10.1.123.93 1521