rescue some data out of ibdata1
hi, it's very frustrating! I have a database with two tablespaces. One for developing, the other for some productive storage. While testing I needed to delete all coloms from the tables and did so. ...no effect. So I did it again. What I did not know: my sql-client use the first configured login by default and makes a connection with this login if there is none while executing a statement... so ( you probably know what ) I deleted all data in my producive tablespace!!!!! I already wrote a special tool to backup the data from the database and just wanted to test it in my test-tablespace... so I have nothing... except: ibdata1; ib_logfile0; ib_logfile1 and some other stuff.
Why I think I probably can save some data: because I can read them in the ibdata1 - file!
CAN YOU HELP ME?????
Mathias
Subject
Views
Written By
Posted
rescue some data out of ibdata1
4463
January 28, 2005 02:18PM
3055
February 03, 2005 01:21AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.