Can We Restore a Table that accidantly dropped.




Answers were Sorted based on User's Feedback



Can We Restore a Table that accidantly dropped. ..

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

Can We Restore a Table that accidantly dropped. ..

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

Can We Restore a Table that accidantly dropped. ..

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




Can We Restore a Table that accidantly dropped. ..

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

Can We Restore a Table that accidantly dropped. ..

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

Can We Restore a Table that accidantly dropped. ..

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

Can We Restore a Table that accidantly dropped. ..

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

Can We Restore a Table that accidantly dropped. ..

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

Post New Answer



More Oracle AllOther Interview Questions

What are the main diff. between oracle 7.3 and oracle 8i?

1 Answers  


How client makes connection with server in client/server architecture?

1 Answers   CA,


I am working in Oracle Clinical 4.5.1 Please explain a bit.How to create Views in OC

4 Answers   Icon,


Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

0 Answers  


how to replace not in with not exist?

0 Answers   IBM,






What is store procedure?and how do u take the values from database and run in scripts?

2 Answers   Polaris,


Describe the P2P cycle ?

1 Answers  


Whats the purpose of using Nextval while creating the sequence.

2 Answers   HCL,


we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

0 Answers   Accenture,


Explain materialized views and how they are used.

2 Answers  


How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun

8 Answers  


Name two files used for network connection to a database.

1 Answers  






Categories