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博客 ” ，链接：https://blog.itpub.net/24756186/viewspace-742656/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
生成statspack 报告
下一篇：
修改归档模式
请登录后发表评论
登录
全部评论
