oracle 基本操作

--给用户解锁
alter user scott account unlock;
--锁定用户
alter user scott account lock;

--查询表空间
select * from v$tablespace;

--创建表空间
create tablespace t04 datafile 'C:\JAVAprogram\Oracle\oradata\orcl\t0401.dbf' size 50m ;

select autoextensible ,tablespace_name from dba_data_files;
--删除表空间
drop tablespace t04 including contents and datafiles;

 

--创建表空间
create tablespace t04 datafile 'C:\JAVAprogram\Oracle\oradata\orcl\t0401.dbf' size 50m
autoextend on next 10m maxsize 100m;

create tablespace t05 datafile 'C:\JAVAprogram\Oracle\oradata\orcl\t0501.dbf' size 50m,
'C:\JAVAprogram\Oracle\oradata\orcl\t0502.dbf' size 50m
autoextend on next 10m maxsize 100m;

drop tablespace t05 including contents and datafiles;

--创建用户
create user cqs identified by accp default tablespace users;

--授权限 connect 连接数据库的权限 resourse 操作表空间的数据对象 角色权限
grant connect ,resource to cqs;

--修改用户密码
alter user cqs identified by tiger;

--给用户解锁
alter user scott account unlock;
--锁定用户
alter user scott account lock;

--删除用户
drop user cqs cascade;

--角色权限
--创建一个角色
create role tea ;
grant connect ,resource to tea;
grant tea to cqs;