Code = 2644 No more room in database

Tools & Utilities
Enthusiast

Re: Code = 2644 No more room in database

Here, Wasted time space will be released or permanently occupied?

Not applicable

Re: Code = 2644 No more room in database

Add space to DB

 MODIFY DATABASE A AS PERM = 1e9;

Enthusiast

Re: Code = 2644 No more room in database

Hi Fred,

 

How do we see when the actual space is more than wasted sapce and we are getting no more space in database?

 

SyntaxEditor Code Snippet

table                                             actual sapce                            wasted sace
VG30_RCPT_TBL                          45,379,907,072.00                 3,625,251,328.00
VG30_RCPT_BKP                       42,970,040,832.00                 3,536,107,008.00
VG62_RATEMAKER_TBL                176,272,896.00                 321,575,424.00
VV30_INSPECTION_TBL                     6,136,215,040.00                 241,441,280.00
V045_830RLSE_TBL                       11,438,800,896.00                206,352,384.00
VV10_VCHR_FJL                              51,134,644,224.00                 202,715,136.00
VF01_NAV_SRMINI_TBL                      4,735,264,768.00                169,121,792.00
V016_MRSREL_TBL                                   22,622,766,592.00                150,891,008.00
VG52_PL_SUP_PLT_TBL                      1,527,831,040.00                  137,500,160.00
VMA4_862SUPP_CHILD_TBL                 26,468,389,376.00                     82,353,664.00
Highlighted
BMR
Fan

No more room in database

could some one please help me for resolving spool space.?

Please find the explain plan of the query

 

 

 

BMR
Fan

Re: Code = 2644 No more room in database

 

Hi