oracle ORA -12953: 请求超出了最大允许的数据库大小 11GB

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/46286018/
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

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-19 03:27:50  来源:igfitidea点击:

ORA -12953: The request exceed the maximum allowed database size of 11GB

oracleoracle11gdatabase-administration

提问by krokodilko

We have oracle express edition 11g i.e. ORACLE XE 64bit. There is 10GB available space in the database. But system tablespace is 98% full, there are 2 system tabalespaces. When we (our startup team) try to ADD or RESIZE the datafile or tablespace using ALTER command we get following error:

我们有oracle express edition 11g,即ORACLE XE 64bit。数据库中有 10GB 可用空间。但是系统表空间已满 98%,有 2 个系统表空间。当我们(我们的启动团队)尝试使用 ALTER 命令添加或调整数据文件或表空间时,我们收到以下错误:

ORA -12953: The request exceed the maximum allowed database size of 11GB

ORA -12953: 请求超出了最大允许的数据库大小 11GB

What should be done to add or resize the datafile?

应该怎么做来添加或调整数据文件的大小?

error

错误

回答by krokodilko

What should be done to add or resize the datafile?

应该怎么做来添加或调整数据文件的大小?

Nothing can be done. The XE version is limited to 11GB of data, see this link

什么也做不了。XE 版本限制为 11GB 数据,请参阅此链接

Oracle Database Express Edition
Oracle Database Express Edition (Oracle Database XE) is an entry-level edition of Oracle Database that is quick to download, simple to install and manage, and is free to develop, deploy, and distribute. Oracle Database XE makes it easy to upgrade to the other editions of Oracle without costly and complex migrations. Oracle Database XE can be installed on any size machine with any number of CPUs, stores up to 11 GB of user data, using up to 1 GB of memory, and using only one CPU on the host machine. Support is provided by an online forum.

Oracle 数据库快捷版
Oracle 数据库快捷版(Oracle 数据库 XE)是 Oracle 数据库的入门级版本,下载速度快,安装和管理简单,可免费开发、部署和分发。Oracle 数据库 XE 可以轻松升级到其他版本的 Oracle,无需进行昂贵且复杂的迁移。Oracle 数据库 XE 可以安装在具有任意数量 CPU 的任意大小的机器上,最多可存储 11 GB 的用户数据,使用最多 1 GB 的内存,并且主机上仅使用一个 CPU。支持由在线论坛提供。



You can purchase Standard or Enterprise edition, which don't have this restriction (but you must pay for it).

You can also register in Oracle's Technology Networkand use any of Oracle's product (including Oracle's Standard and Enterprice database editions from their download site) for free, but only for testing and development purposes.

See this licencefor details:

您可以购买标准版或企业版,它们没有此限制(但您必须付费)。

您还可以在 Oracle 的技术网中注册并免费使用 Oracle 的任何产品(包括其下载站点上的Oracle 标准版和 Enterprice 数据库版本),但仅用于测试和开发目的。

有关详细信息,请参阅此许可证

License Rights and Restrictions
Oracle grants You a nonexclusive, nontransferable, limited license to internally use the Programs, subject to the restrictions stated in this Agreement, only for the purpose of developing, testing, prototyping, and demonstrating Your application and only as long as Your application has not been used for any data processing, business, commercial, or production purposes, and not for any other purpose.

许可权利和限制
Oracle 授予您非排他性、不可转让、有限的内部使用程序的许可,受本协议中规定的限制约束,仅用于开发、测试、原型制作和演示您的应用程序的目的,并且只要您应用程序未用于任何数据处理、业务、商业或生产目的,也未用于任何其他目的。