Can We Restore a Table that accidantly dropped.

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

1768


i want to know about the javaBean.what is its purpose and how it can use in Forms.

1833


Explain the payment term in ar. : oracle accounts receivable

615


Could you please let me know the interfaces in OM / FA??

1734


i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

1851






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

668


What is chargeback invoice? How do we create it? : oracle accounts receivable

725


I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

1820


what is difference between inner join & nested query or subqueries

2480


if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

1542


please send me oracle pl/sql exp resume. and also faqs...

2036


1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

1646


Explain the use of table functions.

1796


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

3985


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.

1624