Recently I tried to export a schema and was surprised with the message, that the size ( 12 GB ) of the DB is exceeded.
I'm using the express edition 21c xe.
Export: Release 21.0.0.0.0 - Production on Di Okt 15 16:35:27 2024
Version 21.3.0.0.0
Copyright (c) 1982, 2021, Oracle and/or its affiliates. All rights reserved.
Angemeldet bei: Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
ORA-31626: Job ist nicht vorhanden
ORA-31637: Job SYS_EXPORT_SCHEMA_01 für Benutzer SIE kann nicht erstellt werden
ORA-06512: in "SYS.KUPV$FT", Zeile 1154
ORA-06512: in "SYS.KUPV$FT", Zeile 1858
ORA-06512: in "SYS.DBMS_SYS_ERROR", Zeile 95
ORA-06512: in "SYS.KUPV$FT_INT", Zeile 1177
ORA-39080: Queues "KUPC$C_1_20241015163528_0" und "KUPC$S_1_20241015163528_0" für Data Pump-Job konnten nicht erstellt werden
ORA-06512: in "SYS.DBMS_SYS_ERROR", Zeile 95
ORA-06512: in "SYS.KUPC$QUE_INT", Zeile 1802
ORA-12954: Die Anforderung überschreitet die maximal zulässige Datenbankgröße von 12 GB.
ORA-06512: in "SYS.DBMS_AQADM_SYS", Zeile 8812
ORA-06512: in "SYS.DBMS_AQADM_SYS", Zeile 8961
ORA-06512: in "SYS.DBMS_AQADM_SYS", Zeile 8637
ORA-06512: in "SYS.DBMS_AQADM_SYS", Zeile 8565
ORA-06512: in "SYS.DBMS_AQADM_SYS", Zeile 8624
ORA-06512: in "SYS.DBMS_AQADM_SYS", Zeile 8722
ORA-06512: in "SYS.DBMS_AQADM_SYS", Zeile 9012
ORA-06512: in "SYS.DBMS_AQADM_SYS", Zeile 8952
ORA-06512: in "SYS.DBMS_AQADM_SYS", Zeile 8801
ORA-06512: in "SYS.KUPC$QUE_INT", Zeile 1743
ORA-06512: in Zeile 1
ORA-06512: in "SYS.KUPC$QUEUE_INT", Zeile 158
ORA-06512: in "SYS.KUPV$FT_INT", Zeile 1070
ORA-06512: in "SYS.KUPV$FT", Zeile 1748
ORA-06512: in "SYS.KUPV$FT", Zeile 1115
I looked for the space occupancy and saw the segment WRI$_ADV_OBJECTS owned by SYS consuming more then 700 MB.
A search in the oracle forum brought me to
system_and_sysaux_tablespaces
respectively https://topic.alibabacloud.com/a/wri_adv_objects-table-too-large-resulting-in-insufficient-sysaux-table-space-for-the-pdb_8_8_30005598.html
As Dimitar Dimitrov told, I also applied Scenario 2, and cleaned the segment named WRI$_ADV_OBJECTS.
Now my questions:
* as you can see in the picture the 'real user' SIE occupies only 4.5 GB whereas SYS occupies more than 4 GB. I thought the 12 GB limit applies only to the real user and does not include system, sys.
* initially I installed apex 21.1 some years ago, and later I upgraded to apex 21.2 Can I safely remove the schema APEX_210100 ( how ? )
* in the actual schema APEX_210200 I saw in the Export Repository a lot of old apps, I will clean the Export Repository too. What else may be cleaned in the APEX_210200 schema ? What else does schema APEX_210200 contain apart from the acutal apps ?
* what else may be cleaned ( and how ) from the SYS ? After cleaning the WRI$_ADV_OBJECTS and its index the owner SYS occupies 2464 MB which is the initially 4227 MB minus the WRI$_ADV_OBJECTS objects ( 1463 MB ) minus additional 300 MB.
* The size of the my latest export-file is about 2 GB. How much space is needed ( below the 12 GB limit ) to carry out a 'export a schema' ?