Can We Restore a Table that accidantly dropped.
Answers were Sorted based on User's Feedback
Answer / ganesh
Upto Oracle 9i its not possible
but in 10g there is a new feature called flashback option
as
flashback table <tablename> to before drop
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / pinkey
yes u can restore a table when it is dropped using
follwing command
Flashback Table Tablename to before drop
Try this
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / attitude girl
Ofcourse Its Possible in New ORACLE 10g EDITION
you have to use flashback command for this.
Syntax:
FLASHBACK TABLE YOURTABLENAME TO BEFORE DROP;
LIKE
FLASHBACK TABLE EMP TO BEFORE DROP;
FLASHBACK COMPLETE.
YOU'LL BE AMAZED BY THIS.
THE BEST THIG IS THAT IT'LL EVEN GET YOUR DATA BACK AS WELL.
TRY THIS COMMAND.
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / sonu
Flashback features is new in Oracle 10G, but we can also
restore a table that accidently dropped.
1. With the previously taken backup of the table or the
database.
2. With the SCN, if one know it and
3. With the timestamp, we can restore the table.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / bon vivant
Hey... The question was to restore the table that is
accedentially dropped... Why u connecting Purging with
this...
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / david
coz...it is also related to recyclebin ...thats y m asking ........
do u have any answer for dis ..??
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / chintan_db
create table dropedemo(a number(10)); --will create table
commit;
insert into dropedemo values (dbms_random.value(0,100)) ; --
data inserted
commit;
drop table dropedemo; --drope table
flashback table dropedemo to before drop; --will restore
table
select * from dropedemo;
--will create magic and give u proof of data is back
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / david
as all of you said about the flashback ....but what if u
purged the recyclbin ....will u get the data back from
their.....
hv you any answer dear...????
david
Is This Answer Correct ? | 0 Yes | 2 No |
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
How would you determine who has added a row to a table?
why r u using etl tool.
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
Compare and contrast TRUNCATE and DELETE for a table.
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?
TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
what are basic modules required to implement oracle application in any oraganisation?