ORA -12953:请求超出了最大允许的数据库大小11GB [英] ORA -12953: The request exceed the maximum allowed database size of 11GB
问题描述
我们有Oracle Express 11g，即ORACLE XE 64bit.数据库中有10GB的可用空间.但是系统表空间已满98％，有2个系统Tabalespace. 当我们(我们的启动团队)尝试使用ALTER命令添加或调整数据文件或表空间的大小时，会出现以下错误:
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:
ORA -12953:请求超出了允许的最大数据库大小11GB
ORA -12953: The request exceed the maximum allowed database size of 11GB
如何添加或调整数据文件的大小?
What should be done to add or resize the datafile?
推荐答案
如何添加或调整数据文件的大小?
What should be done to add or resize the datafile?
什么也做不了. XE版本限于11GB的数据，请参见此链接
Nothing can be done. The XE version is limited to 11GB of data, see this link
Oracle Database Express版
Oracle Database Express版(Oracle Database XE)是Oracle数据库的入门级版本， 可以快速下载，易于安装和管理，并且可以免费 开发，部署和分发. Oracle Database XE使您轻松实现 无需昂贵和复杂地升级到其他版本的Oracle 迁移. Oracle Database XE可以安装在任何大小的计算机上 在具有任意数量的CPU的情况下，最多可存储11 GB的用户数据，最多可使用 1 GB的内存，并且仅在主机上使用一个CPU.支持是 由在线论坛提供.
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 Standard和免费从其下载网站)输入价格数据库版本，但仅用于测试和开发目的.
有关详细信息，请参见此许可证:
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 Network and 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 licence for details:
许可权利和限制
Oracle授予您非独占性， 在内部使用这些程序的不可转让的有限许可， 在遵守本协议规定的限制的前提下，仅适用于 开发，测试，制作原型和演示您的目的 申请，并且只要您的申请尚未用于 任何数据处理，商业，商业或生产目的，以及 不得用于其他任何目的.
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.
这篇关于ORA -12953:请求超出了最大允许的数据库大小11GB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
