Interested to Buy Any Domain ? << Click Here >> for more details...
Can We Restore a Table that accidantly dropped.
- 8 Answers
- 15422 Views
- TCS, I also Faced
- E-Mail Answers
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 is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?
Explain accounting for invoice in advance and arrears. : oracle accounts receivable
What is the difference between recovery and restoring of the oracle database?
What is db_recovery_file_dest in oracle? When do you need to set this value?
Difference between negative and positive adjustments : oracle accounts receivable
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
0 Answers Pathway Technologies,
deference between & and &&
What is Restricted Mode of Instance Startup in Oracle?
What is $FLEX$ and $PROFILES$?
What is an Oracle database Partial Backup?
Can anybody tell which is the best training institute for learning Oracle in chennai...? And i also i want placement assurance
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.
Oracle General 
