Increasing the Size of a Tablespace
You can increase the size of a tablespace by either increasing the size of a datafile in the tablespace or adding one
Additionally, you can enable automatic file extension (
AUTOEXTEND) to datafiles and bigfile tablespaces
1.ALTER DATABASE DATAFILE '' RESIZE [K|M|G];
2.alter tablespace test_t add datafile '/u01/app/oracle/oradata/orcl/test_t02.dbf' size 1m;
3.alter database datafile'/u01/app/oracle/oradata/orcl/test_t01.dbf' autoextend on maxsize unlimited;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24756186/viewspace-742656/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24756186/viewspace-742656/