Post reply

Urgent HELP Needed... Retriving a deleted table

  • July 19, 2004 at 11:17 am

    #85924

    I have accidentally deleted a table using the EM and am wondering how to retrieve it... or is it even possible to do so without restoring it from tape? I appreciate any and all help.

  • July 19, 2004 at 12:16 pm

    #515106

    You have to restore database and get it from restored daatbase.

  • July 19, 2004 at 12:27 pm

    #515107

    Thank you... That's what I've done.

  • July 19, 2004 at 11:20 pm

    #515148

    LiteSpeed from Imceda, would allow you to recover one individual table from the backup file, without recovering the whole database.

     

    Regards

    Douglas Chrystall

    Imceda Software

    http://www.imceda.com

  • July 20, 2004 at 12:48 am

    #515156

    OR, you can restore the database to a new name (eg: if your database was called SYDSALES, restore a read-only copy as SYDSALES_RESTORE). Then all you've got to do is a cross database insert to copy only the table back into the database (eg: INSERT INTO SYDSALES.MISSINGTABLE SELECT * FROM SYDSALES_RESTORE.MISSINGTABLE).

    Julian Kuiters
    juliankuiters.id.au

  • July 20, 2004 at 5:58 am

    #515210

    Thank you Douglas and Julian. Good work around in recovering the missing table. I'll certainly remember that next time Also will look at Douglas' software. Thanks again. It's so nice to know such a wealth of knowledge is available in just a few clicks away.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply