oracle 12c 如何修改表空间的最大大小
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/25309417/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to modify the max size of a tablespace oracle 12c
提问by einstein007
I have a table space called ts witch has a maximum size 10go I need to add a 1go how can I proceed?
我有一个名为 ts 的表空间，最大大小为 10go 我需要添加一个 1go 我该如何继续？
Thanks
谢谢
回答by Marco Baldelli
Are you talking about the automatic extension of data files?
你说的是数据文件的自动扩展吗？
In that case the command you need will be similar to this:
在这种情况下，您需要的命令将类似于：
alter database datafile 'filename' autoextend on next 512K maxsize 11G;
See the section Enabling and Disabling Automatic Extension for a Data Fileof the Oracle 12.1 Database Administrator's Guide.
回答by Richard Hansell
According to the documentation:
根据文档：
http://docs.oracle.com/database/121/SQLRF/statements_3002.htm
http://docs.oracle.com/database/121/SQLRF/statements_3002.htm
I guess this only makes sense if you have autoextend enabled? If you do then you can pick out the syntax from the documentation, something like this?
我想这只有在您启用自动扩展时才有意义吗？如果你这样做，那么你可以从文档中挑选出语法，像这样？
ALTER TABLESPACE myTableSpace RESIZE 11G
