Summary_Oracle创建表空间及其用户

/*创建临时表空间*/

select name from v$tempfile;--查询临时表空间

CREATE TEMPORARY TABLESPACE CKYX_TEMP
TEMPFILE ' H:\DATABASE\ORACLE\ORACLE11G\ORADATA\SYSTEM\ CKYX_TEMP.dbf' 
SIZE 50M REUSE 
AUTOEXTEND ON NEXT 20M 
MAXSIZE 200M;

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

/*创建用户表空间文件的绝对路径*/

select name from v$datafile;--查询用户表空间文件的绝对路径：

CREATE TABLESPACE CKYX_DATA
DATAFILE ' H:\DATABASE\ORACLE\ORACLE11G\ORADATA\SYSTEM\ CKYX_DATA.dbf' 
SIZE 1000M REUSE 
AUTOEXTEND ON NEXT 100M 
MAXSIZE UNLIMITED ;

drop tablespace CKYX including contents and datafiles;--删除用户表空间文件的绝对路径

/*创建用户*/
create user CKYX identified by ckyx-- ACCOUNT UNLOCK 是否解锁（默认设定是登陆时密码错几次之后锁定）
default tablespace CKYX_DATA temporary tablespace CKYX_TEMP;




/*赋予权限*/
grant dba to CKYX;
grant connect,resource to CKYX;