orcale数据库创建用户时报的错:下面是错误
第一步
create temporary tablespace test_temp02
--tempfile 'F:\app\Administrator\oradata\meorcl\TEMP01.DBF'
tempfile 'F:\app\Administrator\oradata\meorcl\test_temp02.dbf'
size 32m
autoextend on
next 32m maxsize 1024m
extent management local;
输入--temporary TABLESPACE 已创建。
第二步
create temporary tablespace test_data02
tempfile 'F:\app\Administrator\oradata\meorcl\test_data02.dbf'
size 32m
autoextend on
next 32m maxsize 1024m
extent management local;
输入--temporary TABLESPACE 已创建。
第三步
create user test_user_b identified by root
default tablespace test_data02
temporary tablespace test_temp02;
输入--错误报告:
SQL 错误: ORA-12910: 无法将临时表空间指定为默认表空间
12910. 00000 - "cannot specify temporary tablespace as default tablespace"
*Cause: attempt to assign a temporary tablespace to be a user's
default tablespace
*Action: assign a permanent tablespace to be the default tablespace
这个问题怎么解决,求大神排解
错误描述不是很清楚吗
你建的两个都是临时表空间
删除表空间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;
正确方法:
--------------------------
create temporary tablespace ecms_temptempfile '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;
drop user ecms cascade;
DROP TABLESPACE ecms_temp INCLUDING CONTENTS AND DATAFILES;
创建表空间不限制大小
create tablespace zwgk
datafile 'e:\oracle\product\10.1.0\oradata\njdb\zwgk.dbf' size 500M
autoextend on next 100M maxsize unlimited logging
extent management local autoallocate
segment space management auto
一个表空间文件默认最大的是30g