Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2008
    Posts
    1

    Unanswered: How to restore table data

    Hi All,

    Hi

    I've a table with column XXX having Datatype Varchar2.This table contains data.I have changed the column XXX to Datatype 'Date'.i commited the same.

    But problem when i look in to the table data i lost entire data of that column and was replaced with null values. How to restore the previous data as I didn't take the backup.

    Please provide the solution ASAP.

    Thx & Rgds
    -SS

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so you had a column typed as varchar and changed it to date.... Unless you have got a backup of the data I think you are stuffed.

    what you could do is go back to the backup
    drop any indexes
    rename the old column
    create a new column of type datetime
    and then do an SQL update query to coerce the values from the old column to the new datetime column. you may need to use the MySQL date functions to make sure that you do the conversion correctly
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Mar 2008
    Posts
    4
    no way to be back because you don't have back up. I have a friend who is perform drop database statement in a wrong database and cannot rollback also . So lessons learned.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •