i********g
发帖数: 41 | 1 在sql server 2000里，我花了8个小时，生成了一个表，却不小心drop掉，又生成了一
个同名的表。请问有什么办法恢复原来table的数据啊？ |
w*******e
发帖数: 1622 | 2 if no backup, then, forget it.
(or take another 8hr? to pump in data)
【在 i********g 的大作中提到】
: 在sql server 2000里，我花了8个小时，生成了一个表，却不小心drop掉，又生成了一
: 个同名的表。请问有什么办法恢复原来table的数据啊？
|
a*******s
发帖数: 324 | 3 do you have replication and backup?
【在 w*******e 的大作中提到】
: if no backup, then, forget it.
: (or take another 8hr? to pump in data)
|
c*****d
发帖数: 6045 | 4 you cannot rollback ddl statement |
u******u
发帖数: 595 | 5 let's say you have a table named t, you did drop that table by:
drop table t;
under Oracle 10g, you can easily recover the dropped table by typing:
flashback table t to before drop;
You get the table back.
All my Oracle 10g SQL 101 students and my Oracle 11g DBA students knew how
to do this simple stuff.
Please visit my URL: amieeister.homeunix.com if you have more questions.
Thanks! USA LaoTu, 20 years USA industry experience and top Oracle expert in
Silicon Valley |
B*****g
发帖数: 34098 | 6 use FLASHBACK？
in
【在 u******u 的大作中提到】
: let's say you have a table named t, you did drop that table by:
: drop table t;
: under Oracle 10g, you can easily recover the dropped table by typing:
: flashback table t to before drop;
: You get the table back.
: All my Oracle 10g SQL 101 students and my Oracle 11g DBA students knew how
: to do this simple stuff.
: Please visit my URL: amieeister.homeunix.com if you have more questions.
: Thanks! USA LaoTu, 20 years USA industry experience and top Oracle expert in
: Silicon Valley
|
c*****d
发帖数: 6045 | 7 人家是SQL Server，不要气人家了
in
【在 u******u 的大作中提到】
: let's say you have a table named t, you did drop that table by:
: drop table t;
: under Oracle 10g, you can easily recover the dropped table by typing:
: flashback table t to before drop;
: You get the table back.
: All my Oracle 10g SQL 101 students and my Oracle 11g DBA students knew how
: to do this simple stuff.
: Please visit my URL: amieeister.homeunix.com if you have more questions.
: Thanks! USA LaoTu, 20 years USA industry experience and top Oracle expert in
: Silicon Valley
|
c*****d
发帖数: 6045 | 8 nod, flashback using Oracle 10g New Feature: recycle bin
【在 B*****g 的大作中提到】
: use FLASHBACK？
:
: in
|
B*****g
发帖数: 34098 | 9
【在 c*****d 的大作中提到】
: nod, flashback using Oracle 10g New Feature: recycle bin
|
B*****g
发帖数: 34098 | 10 ft，看来你还真有两把刷子，怎么还在学校里混？
【在 c*****d 的大作中提到】
: nod, flashback using Oracle 10g New Feature: recycle bin
|
c*****d
发帖数: 6045 | 11 不在学校混咋办
一般的公司不想去
好公司一听要办H1直接把我放在最后一个考虑
所以一句话：学什么都不如有绿卡
^_^
【在 B*****g 的大作中提到】
: ft，看来你还真有两把刷子，怎么还在学校里混？
|
