----脚本:
---------------------------------------------------------------------------------
---创建表空间:
CREATE SMALLFILE
TABLESPACE "TABES"
LOGGING
DATAFILE 'E:\oracle\product\10.2.0\oradata\devl\TABES.ora'
SIZE 500M REUSE AUTOEXTEND
ON NEXT 5120K MAXSIZE 32767M EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO ;
---------------------------------------------------------------------------------
---创建临时表空间:
CREATE SMALLFILE
TEMPORARY TABLESPACE "TABESTEMP" TEMPFILE
'E:\oracle\product\10.2.0\oradata\devl\TABESTEMP.ora' SIZE
50M REUSE AUTOEXTEND
ON NEXT 5120K MAXSIZE 32767M EXTENT MANAGEMENT LOCAL
UNIFORM. SIZE 1024K;
---------------------------------------------------------------------------------
---提交:
commit;
---------------------------------------------------------------------------------
/* USER:表空间,TABESTEMP:临时表空间 */
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/295691/viewspace-211640/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/295691/viewspace-211640/