ORA-01653: unable to extend table SYSADM.WEBBINFILES by 8192 in tablespace QTDATA_1 at Oracle.DataAccess.Client.OracleException.HandleEr
Anybody have the docs on how to add more space, or know from Oracle experience? I'm thinking I need to add QT1DAT7.DBF.
******* Tablespaces *******
Tablespace Total Size Free Pct Block Extent Alloc Seg Space Extent Info
Name (MB) Space Full Size Management Type Management Initial Next Min
------------ ---------- -------- ----- ------- ---------- -------- ---------- ------- ---- ----
QTDATA_1 229,188 153 100 8,192 LOCAL SYSTEM AUTO 65536 1 1
QTDATA_2 32,060 1,336 96 8,192 LOCAL SYSTEM AUTO 65536 1 1
QTDATA_3 27,960 1,843 93 8,192 LOCAL SYSTEM AUTO 65536 1 1
QTINDEX_1 131,382 43,928 67 8,192 LOCAL SYSTEM AUTO 65536 1 1
QTINDEX_2 66,100 6,321 90 8,192 LOCAL SYSTEM AUTO 65536 1 1
QTUSER_1 70,284 61,129 13 8,192 LOCAL SYSTEM AUTO 65536 1 1
SYSAUX 1,460 123 92 8,192 LOCAL SYSTEM AUTO 65536 1 1
SYSTEM 880 8 99 8,192 LOCAL SYSTEM MANUAL 65536 1 1
UNDOTBS1 86,695 86,379 0 8,192 LOCAL SYSTEM MANUAL 65536 1 1
******* Data Files *******
Tablespace File Name Size(MB) AutoExt Avail Status
------------ ----------------------------------------------- --------- --------------- ---------
QTDATA_1 F:\RELIUS\ADMIN\RADB\DATAFILES\QT1DAT0.DBF 32,710 YES AVAIL ONLINE
QTDATA_1 F:\RELIUS\ADMIN\RADB\DATAFILES\QT1DAT1.DBF 32,710 YES AVAIL ONLINE
QTDATA_1 F:\RELIUS\ADMIN\RADB\DATAFILES\QT1DAT2.DBF 32,768 YES AVAIL ONLINE
QTDATA_1 F:\RELIUS\ADMIN\RADB\DATAFILES\QT1DAT3.DBF 32,750 YES AVAIL ONLINE
QTDATA_1 F:\RELIUS\ADMIN\RADB\DATAFILES\QT1DAT4.DBF 32,738 YES AVAIL ONLINE
QTDATA_1 F:\RELIUS\ADMIN\RADB\DATAFILES\QT1DAT5.DBF 32,756 YES AVAIL ONLINE
QTDATA_1 F:\RELIUS\ADMIN\RADB\DATAFILES\QT1DAT6.DBF 32,756 YES AVAIL ONLINE
QTDATA_2 F:\RELIUS\ADMIN\RADB\DATAFILES\QT2DAT0.DBF 11,200 YES AVAIL ONLINE
QTDATA_2 F:\RELIUS\ADMIN\RADB\DATAFILES\QT2DAT1.DBF 10,640 YES AVAIL ONLINE
QTDATA_2 F:\RELIUS\ADMIN\RADB\DATAFILES\QT2DAT2.DBF 10,220 YES AVAIL ONLINE
QTDATA_3 F:\RELIUS\ADMIN\RADB\DATAFILES\QT3DAT0.DBF 9,620 YES AVAIL ONLINE
QTDATA_3 F:\RELIUS\ADMIN\RADB\DATAFILES\QT3DAT1.DBF 9,540 YES AVAIL ONLINE
QTDATA_3 F:\RELIUS\ADMIN\RADB\DATAFILES\QT3DAT2.DBF 8,800 YES AVAIL ONLINE
QTINDEX_1 F:\RELIUS\ADMIN\RADB\DATAFILES\QT1IDX0.DBF 32,710 YES AVAIL ONLINE
QTINDEX_1 F:\RELIUS\ADMIN\RADB\DATAFILES\QT1IDX1.DBF 32,730 YES AVAIL ONLINE
QTINDEX_1 F:\RELIUS\ADMIN\RADB\DATAFILES\QT1IDX4.DBF 16,564 YES AVAIL ONLINE
QTINDEX_1 F:\RELIUS\ADMIN\RADB\DATAFILES\QT1IDX3.DBF 16,628 YES AVAIL ONLINE
QTINDEX_1 F:\RELIUS\ADMIN\RADB\DATAFILES\QT1IDX2.DBF 32,750 YES AVAIL ONLINE
QTINDEX_2 F:\RELIUS\ADMIN\RADB\DATAFILES\QT2IDX1.DBF 21,690 YES AVAIL ONLINE
QTINDEX_2 F:\RELIUS\ADMIN\RADB\DATAFILES\QT2IDX0.DBF 22,390 YES AVAIL ONLINE
QTINDEX_2 F:\RELIUS\ADMIN\RADB\DATAFILES\QT2IDX2.DBF 22,020 YES AVAIL ONLINE
QTUSER_1 F:\RELIUS\ADMIN\RADB\DATAFILES\QTUSER1.DBF 23,411 YES AVAIL ONLINE
QTUSER_1 F:\RELIUS\ADMIN\RADB\DATAFILES\QTUSER0.DBF 23,390 YES AVAIL ONLINE
QTUSER_1 F:\RELIUS\ADMIN\RADB\DATAFILES\QTUSER2.DBF 23,483 YES AVAIL ONLINE
SYSAUX F:\RELIUS\ADMIN\RADB\DATAFILES\SYSAUX01.DBF 1,460 YES AVAIL ONLINE
SYSTEM F:\RELIUS\ADMIN\RADB\DATAFILES\SYSTEM01.DBF 880 YES AVAIL SYSTEM
TEMP F:\RELIUS\ADMIN\RADB\DATAFILES\TEMP01.DBF 32,493 YES ONLIN ONLINE
UNDOTBS1 F:\RELIUS\ADMIN\RADB\DATAFILES\UNDOTBS01.DBF 32,768 YES AVAIL ONLINE
UNDOTBS1 F:\RELIUS\ADMIN\RADB\DATAFILES\SYSAUX02.DBF 32,767 YES AVAIL ONLINE
UNDOTBS1 F:\RELIUS\ADMIN\RADB\DATAFILES\UNDOTBS02.DBF 21,160 YES AVAIL ONLINE
--- -----------
Sum 678,502 Megabytes total
******* Redo Log Files *******
Group Members Size (MB) Sequence Status File Name(s)
------ ------- ---------- --------- --------- --------------------
1 1 20 204412 ACTIVE F:\RELIUS\ADMIN\RADB\DATAFILES\REDO01.LOG
2 1 20 204413 CURRENT F:\RELIUS\ADMIN\RADB\DATAFILES\REDO02.LOG
3 1 20 204411 ACTIVE F:\RELIUS\ADMIN\RADB\DATAFILES\REDO03.LOG
******* Control Files *******
F:\RELIUS\ADMIN\RADB\DATAFILES\CONTROL01.CTL
F:\RELIUS\ADMIN\RADB\DATAFILES\CONTROL02.CTL
F:\RELIUS\ADMIN\RADB\DATAFILES\CONTROL03.CTL
@ben.edester & @Kenneth Sullivan - I'm sorry for the delayed response. If I remember correctly, the QT Clean stored proc (spQtClean) will only delete records from webbinfiles if the records are flagged with WebCd = 'A'. You could just set WebCd = 'A' for the records that you want to be deleted, but I think the stored proc is missing the webbinfilescontent table (i.e. there should be a total of webbinfiles* tables). If so, you probably just want to copy the code from the QT Clean stored proc, and create your own process.