创建表空间及添加数据文件
1、创建表空间
create tablespace tablespacename
datafile ‘/u02/oradata/$ORACLE_SID/datafilename’size 128M
autoextend on next 2048K
maxsize 2048M,
‘u02/oradata/$ORACLE_SID/datafilename’ size 128M
autoextend on next 2048K
maxsize 2048M
logging
extent management local autoallocate
segment space management auto
flashback on
2、添加数据文件
alter tablespace tablespacename add datafile
‘u02/oradata/$ORACLE_SID/datafilename’size 128M
autoextend on next 2048K
maxsize 2048M
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7419833/viewspace-227921/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7419833/viewspace-227921/