一、创建临时表空间
create temporary tablespace test_temptempfile '/data/oracle/oradata/test/test_temp01.dbf'
size 6000M
autoextend on
next 500M maxsize 10000M
extent management local;
二、创建数据表空间
create tablespace test_datalogging datafile '/data/oracle/oradata/test/test_data01.dbf'
size 10000M
autoextend on
next 500M maxsize 20000M
extent management local;
三、创建用户并指定表空间
create user oracle identified by 123456default tablespace test_datsa
temporary tablespace test_temp;
四、给用户授予权限
grant connect to oracle;grant resource to oracle;
grant create view to oracle;
GRANT DEBUG ANY PROCEDURE TO oracle;
五、其他
1) 查看用户信息(
账号,密码,状态,默认表空间,用户创建时间)
conn /as sysdba
select username,password,account_status,default_tablespace,created from dba_users;
2)查看用户权限
conn oracle/123456
select * from user_sys_privs;
3)
修改用户密码
alter user 用户名 identified by新密码;
4)删除用户
drop user 用户名 cascade; --//执行该语句请小心,会级联删除该用户下所有对象。
5)解除授权
revoke dba from 用户名;
revoke dba from 用户名;
6)删除表空间
drop tablespace test_temp including CONTENTS and datafiles;
drop tablespace test_temp including CONTENTS and datafiles;
7)临时表空间的进一步了解