At 07:11 PM 9/26/2005, Claudine Robbins wrote:
One of my databases has the syslayouts3 corrupted. RScope 7.5 reports:
Syslayouts3 -- The LOB column value address (1156579328) is beyond the end
of LOB data file (file 4) at 4583424.
Any idea how I can attempt to manually fix this or should I just put a cross
on today's work and start over tomorrow with last week's backup?
I get a "Error - Internal error -- out of dynamic space" and "database files
are out of sync (2520)"
Claudine,
Without knowing all details, here's how to fix your specific situation:
Example:
01. Start RBG7 or RBG75
02. CONNECT dbname
03. At the R> Prompt:
DELETE ROWS FROM SYS_LAYOUTS3
RELOAD abcd
DISCONNECT
DELETE dbname.RB?
RENAME abcd.rb? dbname.rb?
04. CONNECT dbname
Notes:
. Substitute dbname with the name of your actual database.
. With LAYOUT set to ON, you'll need to re-define data browser's layout
settings, if you wish.
That's all there is to it!
Have fun!
Very Best R:egards,
Razzak.