Tom,
It appears that your ".RB1"/".RX1" file is corrupt. The NONE
tomtinventorytab SYSTEM TABLE inventory table temp1 17 23 -16
274
Is being shown in the spot reserved for SYS_REPORT2 table. Have you looked at
you database in
RScope.
Since you cannot use, I assume, the "UNLOAD ALL" command have you tried
unloading individual tables with their data from the Database Explorer.
If you can that may be the only way to save you data. If your database is the
32bit version contact me offline I have several RMD files to automate the
extraction process.
Another question. Do you have a backup copy of your database where the problem
does not occur?
Jim Bentley,
American Celiac Society
1-504-737-3293
From: TOM HART <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Tuesday, June 9, 2015 9:36 PM
Subject: [RBASE-L] - Strange sys_table
I had posted about the corrupt database which is giving my fits, what I have
found out is that a temp table shows up as a sys_table as follows(the
highlighted is the temp table)
SYS_TABLE_QUAL SYS_TABLE_OWNER SYS_TABLE_NAME SYS_TABLE_TYPE
SYS_COMMENT SYS_SCHEMA_NAME SYS_TABLE_ID SYS_NUM_COLUMNS
SYS_NUM_ROWS SYS_ROW_SIZE SYS_TEMPORARY
NONE SYS_COMMENTS SYSTEM TABLE temp1 1 2 238 4104
NONE SYS_DEFAULTS SYSTEM TABLE temp1 2 4 8 80
NONE SYS_RULES SYSTEM TABLE temp1 3 6 4 4120
NONE SYS_VIEWS SYSTEM TABLE temp1 4 3 2 4108
NONE SYS_CONSTRAINTS SYSTEM TABLE temp1 7 7 30
4124
NONE SYS_TABLES SYSTEM TABLE temp1 8 11 -4 4200
NONE SYS_COLUMNS SYSTEM TABLE temp1 9 14 -4 4170
NONE SYS_INDEXES SYSTEM TABLE temp1 10 24 -4 138
NONE SYS_FORMS SYSTEM TABLE temp1 11 3 92
NONE SYS_REPORTS SYSTEM TABLE temp1 12 3 92
NONE SYS_LABELS SYSTEM TABLE temp1 13 3 92
NONE SYS_LAYOUTS SYSTEM TABLE temp1 14 2 4138
NONE SYS_TYPES SYSTEM TABLE temp1 15 14 -4 4170
NONE SYS_FORMS2 SYSTEM TABLE temp1 16 4 4152
NONE tomtinventorytab SYSTEM TABLE inventory table temp1 17
23 -16 274
NONE SYS_LABELS2 SYSTEM TABLE temp1 18 4 4152
NONE SYS_SERVERS SYSTEM TABLE temp1 19 4 4112
NONE SYS_PROCEDURES SYSTEM TABLE temp1 20 10 4164
NONE SYS_PROC_MODS SYSTEM TABLE temp1 21 8 4156
NONE SYS_PROC_COLS SYSTEM TABLE temp1 22 10 4136
NONE SYS_TRIGGERS SYSTEM TABLE temp1 23 4 16
NONE SYS_FORMS3 SYSTEM TABLE temp1 24 5 130 4168
NONE SYS_REPORTS3 SYSTEM TABLE temp1 25 5 52 4168
NONE SYS_LABELS3 SYSTEM TABLE temp1 26 5 7 4168
NONE SYS_MERGE SYSTEM TABLE temp1 27 6 4172
NONE SYS_LAYOUTS3 SYSTEM TABLE temp1 28 3 4154
What happened? If I do a reload it is still there. I also have tried
unloading but Rbase crashes. Any help
Tom Hart
