1. orcle 创建可扩展表空间

1.创建表空间

a).

create tablespace tablespacename

datafile 'D:\tablespace\tablespacename.dbf'

size 200m autoextend on

extent management local uniform size 64k

segment space management auto;

 

 b).

create tablespace test datafile 'E:\oracle\product\10.2.0\oradata\orcl\test.dbf' size 200m autoextend on next 10m maxsize unlimited;

create user test identified by test default tablespace test temporary tablespace temp;

grant connect,resource to test;
grant exp_full_database to test;
grant imp_full_database to test;

 

 

2.创建临时表空间

CREATE TEMPORARY TABLESPACE temptspmdata
TEMPFILE 'D:\tablespace\tempspmdata.dbf'
SIZE 200m
AUTOEXTEND ON
NEXT 32m MAXSIZE 2048m
EXTENT MANAGEMENT LOCAL;