Recover deleted table

Hi Is there any way to recover a table that was dropped ??? DB engine is IDS 9.21 running on Unixware 7.1.1 We dont want to restore the entire database backup. Does the deleted table gets stored anywhere ???? Any help is appreciated. Thanks Avichal

Hi, I don't know any other solution than restoring the whole database to another server and unloading the table. Bye Andreas > ------------------------------------------- SPAR Oesterreichische Warenhandels-AG Hauptzentrale Europastrasse 3 A - 5015 Salzburg Tel: +43 662 4470 24223 Mobile: +43 664 6259575 E-Mail: Andreas.KUTSCHE@spar.at Internet: http://www.spar.at ------------------------------------------- -----Urspr|ngliche Nachricht----- > Von: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org]Im > Auftrag von Avichal A N.... > Gesendet: Montag, 24. Oktober 2005 02:55 > An: ids@iiug.org > Betreff: Recover deleted table [5889] > > > Hi > > Is there any way to recover a table that was dropped ??? DB > engine is IDS 9.21 > running on Unixware 7.1.1 > > We dont want to restore the entire database backup. Does the > deleted table > gets stored anywhere ???? > > Any help is appreciated. > > Thanks > > Avichal

It's --possible-- to recover the data, but tedious and non-trivial. You'd have to find the deleted partition page that used to hold the table's extent list within the free list or 'unused' pages in the correct dbspace's tablespace tablespace and read the extent list from it. Then you could read through the extents (assuming no other table has already coopted the disk space) parse the slot table on each page and extract the data and write it to a file as a binary record or convert it to text. If you write the data in binary you can use my ul.ec utility (in utils2_ak) to reload the data to a new table that matches the original's schema. If you write the data in text, you can use the dbaccess LOAD verb, dbload, or Jonathan Leffler's sqlload utility from the sqlcmd package. As I said non-trivial. Best solution, as already mentioned, is to restore an archive from prior to the dropping of the table, possibly including any logical logs from the archive time until shortly before the table was dropped, to another machine and extract the data from that instance using the normal tools. Art S. Kagel ----- Original Message ----- From: Avichal A N.... <avichal@cjpatel.com.fj> At: 10/23 23:02 Hi Is there any way to recover a table that was dropped ??? DB engine is IDS 9.21 running on Unixware 7.1.1 We dont want to restore the entire database backup. Does the deleted table gets stored anywhere ???? Any help is appreciated. Thanks Avichal