ora02180;急急急!
create temporary tablespace abc_tem tempfile 'abc_tem' size 100m autoextent on next 100m maxsize 1024m extent management local;
linux opensuse,orcle10g;
ora02018:invalid option for create tablespace
请各位大神告诉在下到底是什么问题。谢谢
------解决方案--------------------临时表空间应该为UNIFORM 方式吧,
For example:
CREATE SMALLFILE TEMPORARY TABLESPACE "ASIT_TEMP"
TEMPFILE 'D:\ORACLE\ORA_DATA\ASIT_TEMP_001'
SIZE 500M
AUTOEXTEND ON
NEXT 100M MAXSIZE 2000M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M