-------------------------- create temporary tablespace ecms_temp tempfile 'F:\app\Administrator\oradata\meorcl01\ecms_temp.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;
create tablespace ecms_data logging datafile 'F:\app\Administrator\oradata\meorcl01\ecms_data.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;
create user cms identified by root default tablespace ecms_data temporary tablespace ecms_temp; grant connect,resource,dba to cms; drop user ecms cascade; DROP TABLESPACE ecms_temp INCLUDING CONTENTS AND DATAFILES;
你建的两个都是临时表空间
删除表空间test_data02,重建将其建成普通表空间。
create tablespace test_data02
file 'F:\app\Administrator\oradata\meorcl\test_data02.dbf'
size 32m
autoextend on
next 32m maxsize 1024m
extent management local;
上面将“删除表空间test_data02,重建将其建成普通表空间。”我不知道怎么做,就劳烦大神说具体的操作,向你学习了
--------------------------
create temporary tablespace ecms_temp
tempfile 'F:\app\Administrator\oradata\meorcl01\ecms_temp.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
create tablespace ecms_data
logging
datafile 'F:\app\Administrator\oradata\meorcl01\ecms_data.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
create user cms identified by root
default tablespace ecms_data
temporary tablespace ecms_temp; grant connect,resource,dba to cms; drop user ecms cascade;
DROP TABLESPACE ecms_temp INCLUDING CONTENTS AND DATAFILES;