Just did a quick test on Oracle --
SQL> select * from test;
no rows selected
SQL> drop table test;
Table dropped.
SQL> rollback;
Rollback complete.
SQL> select * from test;
select * from test
*
ERROR at line 1:
ORA-00942: table or view does not exist
---
Delete can definitely be rolled back since it's a DML command, but not DROP. Do you agree? Feel free to show me an example if I missed anything here...
Elaine
-----Original Message-----
From: naheed [mailto:[Email Address Removed] Tuesday, July 09, 2002 5:18 PM
To: Fang, Elaine; [Email Address Removed] RE: Just made an error -- need help!!!
Hi
I guess you can rollback if you did not commit.
Best Regards
InfoCom Support
-----Original Message-----
From: Fang, Elaine [mailto:Elaine.[Email Address Removed] Tuesday, July 09, 2002 5:04 PM
To: naheed; [Email Address Removed] RE: Just made an error -- need help!!!
I doubt that since drop table is DDL instead of DML, which means once it's
done, it can not be roll back, right?
-----Original Message-----
From: naheed [mailto:[Email Address Removed] Tuesday, July 09, 2002 4:58 PM
To: Fang, Elaine; [Email Address Removed] RE: Just made an error -- need help!!!
Hi
I know there is a way to get the droped tables in oracle databases if you
did not commit after dropping.
I am sure there is a way to do that in SQL2K also.
Best Regards
InfoCom Support
-----Original Message-----
From: Fang, Elaine [mailto:Elaine.[Email Address Removed] Tuesday, July 09, 2002 4:34 PM
To: [Email Address Removed] Just made an error -- need help!!!
Hi list,
It's a test db w/o old backup. I just dropped the tables that I should have
kept. Is that anyway for me to bring them back?
Can I take a backup of the transaction log and restore the db back to the
point that the error was made?
Your quick response will be greatly appreciated!!!
Elaine
---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page