Can We Restore a Table that accidantly dropped.

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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


CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

1610


My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

1741


now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

1794


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

2051






How many segment are present in Oracle Manufacturing

1807


What view would you use to determine free space in a tablespace?

1776


WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

1492


PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

1699


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


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

1768


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

1838


Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

6735


What is the use of lockboxes? Steps for lock box : oracle accounts receivable

721


which one is currently in used software cmpanies.

1658