DP - Error when createing Tablespace Extension file

  • KM00478443
  • 16-Jul-2013
  • 24-Jul-2013

Archived Content: This information is no longer maintained and is provided "as is" for your convenience.

Summary

Error about the size of the Tablespace extension file

Error

When trying to create a Database Tablespace Extension file, there is an error:

[12:1290] Tablespace file above allowed limit

This was attempted with smaller values, with the same results

This is true for any Extension file

dirs.dat
fn1.ext
fn2.ext
fn3.ext
fn4.ext

 

Cause

Running

     omnidbutil -extendinfo

shows that the tablespace is full

Base file "fn2.ext":
    Device               = F:/Program Files/OmniBack/db40/datafiles/cdb
    Number of extensions = 1
    Maximum size         = 2097152 [kB]
    Current size         = 2097152 [kB]
Extension file "fn2.ext1":
    Device       = F:/Program Files/OmniBack/db40/datafiles/cdb
    Maximum size = 2096128 [kB]
    Current size = 2096128 [kB]
Maximum size with extensions = 4193280 [kB]
Current size with extensions = 4193280 [kB]

'fn2.ext' shown for illustration, so the creation of the new extension is calculating the data of the present
Sizes – not the added amount.

Fix

Run the purge preview report,

      omnirpt -report db_purge_preview

 pick a couple of the larger clients and run a force purge against these.

       omnidbutil -purge -filenames [hostname] -force               Do not include the [   ] marks

You may do this for more than hostname at a time, for example

         omnidbutil -urge -filenames [host1] [host2] [host3] -force

Then do a writedb/readdb

Stop/start DP

Create new extentions.