Re: help with full filesystem corruption

> 314: Table (load_comma) currently in use.> 2: No such file or directory yes gone ... hum.... use dbaccess or isql's query language do a select * from systables where tabname ="load_comma" it should give you dirpath. if dirpath is a fully qualified directoryname/somefilename ex: /data/mydatabase/load_comma then do a ls of /data/mydatabase/load_comma.* if the name is load_c000101 or something simular, goto the directory where your database reside cd into the <databasename>.dbs and do a ls of load_c000101 .* if there is nothing there, you lost the table. try to get the schema of load_comma dbschema -d <yourdbname> -t load_comma -ss load_comma.sql (ahum not sure if you can use -ss.....) and fingers crossed that thisworks otherwise you have to get this info from the system catalog and retype the create table statement.... create a dummy database use load_comma.sql to recreate load_comma maybe you need to modify it if dirpath is /data/mydatabase/load_comma add in /data/mydatabase/load_comma after the create table in this case you can manually delete the dummy db since you have an new empty table in your db. if dirpath was load_c000101 you can copy the idx and dat files to your production database directory. again i would really check for backups and see if you have a valid one. Superboer.