Can We Restore a Table that accidantly dropped.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we modify approve purchase order?if yes what is navigation?

1524


as a technical developer in oracle applications which type errors feced in your experience sofar

1740


What is auto invoicing? : oracle accounts receivable

629


how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

1881


What is db_recovery_file_dest in oracle? When do you need to set this value?

626






I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2023


WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

1613


How would you determine what sessions are connected and what resources they are waiting for?

1587


How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

1607


What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

624


Difference between negative and positive adjustments : oracle accounts receivable

594


Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

646


difference of using cursor for loop and open,fetch,close.which one is better

1230


Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

1932


What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

3960