Home » RDBMS Server » Server Administration » XE ORA-12954: The request exceeds the maximum allowed database size of 12 GB (DB18c XE )
XE ORA-12954: The request exceeds the maximum allowed database size of 12 GB [message #686574] Fri, 14 October 2022 06:23 Go to next message
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
Senior Member
I have a problem: an 18c XE database that has reached the 12GB limit. My job is to extract everything and transfer it into a properly licensed 19c SE2 environment, but Data Pump fails:
-bash-4.2$ expdp \"sys/oracle@xepdb1 as sysdba\" directory=dump file=schemas.dmp schemas=<redacted>

Export: Release 18.0.0.0.0 - Production on Fri Oct 14 11:04:57 2022
Version 18.4.0.0.0

Copyright (c) 1982, 2018, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
ORA-31626: job does not exist
ORA-31633: unable to create master table "SYS.SYS_EXPORT_SCHEMA_05"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1142
ORA-12954: The request exceeds the maximum allowed database size of 12 GB.
ORA-06512: at "SYS.KUPV$FT", line 1035
ORA-06512: at "SYS.KUPV$FT", line 1023
I've purged the recyclebin, I've resized the datafiles down as far as they will go. I think a lot of the problem is one LOB that is about 5G, but I cant re-organize it:
xepdb1> alter table <redacted> move lob(<redacted>) store as securefile (enable storage in row) online update indexes;
alter table <redacted> move lob(<redacted>) store as securefile (enable storage in row) online update indexes
                *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 2
ORA-12954: The request exceeds the maximum allowed database size of 12 GB.
Any idea how I can get past this?

Thank you for any insight.




Re: XE ORA-12954: The request exceeds the maximum allowed database size of 12 GB [message #686575 is a reply to message #686574] Fri, 14 October 2022 07:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

The problem with Data Pump is that it first creates and fills a (master) table before starting the export, so if you already reached the limit it can't do that.
If you have still some space you can try creating the master table in a tablespace using small storage parameters, smaller than SYSTEM ones.

Otherwise, maybe it is possible you export this table or partition using the original export (exp) and then the rest using Data Pump.

[Updated on: Sat, 15 October 2022 02:50]

Report message to a moderator

Re: XE ORA-12954: The request exceeds the maximum allowed database size of 12 GB [message #686576 is a reply to message #686575] Sat, 15 October 2022 05:41 Go to previous message
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
Senior Member
THanks for replying. It looks though the old exp is the only way, and it is awful. I don't think the tool has been updated since release 10, any number of bugs reported in MOS, the "solution" is always "legacy export is not supported or patched, use Data Pump instead" or words to that effect. Trying a FULL export fails immediately, USER level exports partially succeed. So I'm writing a shedload of code to extract all the stuff that exp can't do.

I did wonder about unplugging the PDB from XE and plugging it into a 19.x DB, and exporting from there. Problem is that would mean installing Enterprise Edition, and the site isn't licensed at all (this is all to move to OCI, SE2).

The lesson learnt is: If you have an XE DB, write an alert that will tell you well before it reaches the 12GB limit.
Previous Topic: Using OCI storage for BLOBs
Next Topic: gather statistics on partition table who runs it
Goto Forum:
  


Current Time: Fri Nov 15 17:27:12 CST 2024