http://www.itpub.net/showthread.php?threadid=302228--最初由 lucky_lau 发表:
You cannot use the ALTER TABLESPACE statement, with the TEMPORARY keyword, to change a locally managed permanent tablespace into a locally managed temporary tablespace. You must use the CREATE TEMPORARY TABLESPACE statement to create a locally managed temporary tablespace.
不能将本地管理的永久表空间更改为临时表空间,字典管理的可以。
You cannot use the ALTER TABLESPACE statement, with the TEMPORARY keyword, to change a locally managed permanent tablespace into a locally managed temporary tablespace. You must use the CREATE TEMPORARY TABLESPACE statement to create a locally managed temporary tablespace.
不能将本地管理的永久表空间更改为临时表空间,字典管理的可以。
解决方案 »
- ORCLE 服务器的访问
- 往表里插入一条记录的时候,为什么没有产生redo信息?
- sql取值问题
- 导入数据报错误ORA-01659
- (求助)有关rman恢复问题
- 从excel中向oracle中导入一张表后怎么将导入字段的空格去掉?这个sql语句怎么写?
- 新手写了个触发器,编译有错误,求指点下,万分感激!
- 在linux下用proc/c++往oracle里写汉字的问题(汉字给拆了,不知如何解决)
- 在oracle中还原表时怎样覆盖原来的表?
- 请教高手一个存储过程问题!!!急急急!!!在线等!!!!
- Update MA10K010 set priKey=72705118 where priKey=72705116;如何更新主键值
- oracle安全问题?如何限制用户使用sqlplus "/as sysdba"???
datafile '' size 100M
extent management dictionary;alter tablespace tmpSpacep temporary;--更改成功!--设置为数据库的默认临时表空间alter database default temporary tablespace tmpSpacep;
create tablespace tmpSpacep
datafile 'D:\oracle\oradata\AppData\data1.dbf' size 100M
extent management dictionary;
这个语句不行啊,
会出现ORA-12913错误
Create temporary tableSpace tmpQry tempfile 'd:\oracle\oradata\TEMPQRY01.dbf' SIZE 10M;