oracle什么时候创建表空间,oracle创建表空间



oracle 创建表空间：

/*分为四步 */

/*第1步：创建临时表空间  */(可以省略)

create temporary tablespace user_temp

tempfile 'D:\oracle\oradata\Oracle9i\user_temp.dbf'

size 50m

autoextend on

next 50m maxsize 20480m

extent management local;

/*第2步：创建数据表空间  */

create tablespace EXIMMETA

datafile 'D:\Work\Oracle\win64_11gR2_database\app\Administrator\oradata\orcl\EXIMMETA.dbf'

size 50m

autoextend on

next 50m maxsize 4096m

extent management local;

create tablespace EXIMSYS

datafile 'D:\Work\Oracle\win64_11gR2_database\app\Administrator\oradata\orcl\EXIMSYS.dbf'

size 50m

autoextend on

next 50m maxsize 4096m

extent management local;

create tablespace EXIMTRX

datafile 'D:\Work\Oracle\win64_11gR2_database\app\Administrator\oradata\orcl\EXIMTRX.dbf'

size 50m

autoextend on

next 50m maxsize 4096m

extent management local;

create tablespace EXIMUSER

datafile 'D:\Work\Oracle\win64_11gR2_database\app\Administrator\oradata\orcl\EXIMUSER.dbf'

size 50m

autoextend on

next 50m maxsize 4096m

extent management local;

/*第3步：创建用户并指定表空间  */

create user EXIMMETA identified by EXIMMETA

default tablespace EXIMMETA

temporary tablespace TEMP;

create user EXIMSYS identified by EXIMSYS

default tablespace EXIMSYS

temporary tablespace TEMP;

create user EXIMTRX identified by EXIMTRX

default tablespace EXIMTRX

temporary tablespace TEMP;

create user EXIMUSER identified by EXIMUSER default tablespace EXIMUSER temporary tablespace TEMP;   /*第4步：给用户授予权限  */ grant connect,resource,dba,exp_full_database,imp_full_database to EXIMMETA; grant connect,resource,dba,exp_full_database,imp_full_database to EXIMSYS; grant connect,resource,dba,exp_full_database,imp_full_database to EXIMTRX; grant connect,resource,dba,exp_full_database,imp_full_database to EXIMUSER;