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

Answer / pinkey

yes u can restore a table when it is dropped using
follwing command

Flashback Table Tablename to before drop

Try this

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.

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.

Answer / bon vivant

Hey... The question was to restore the table that is
accedentially dropped... Why u connecting Purging with
this...

Answer / david

coz...it is also related to recyclebin ...thats y m asking ........


do u have any answer for dis ..??

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

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

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

0 Answers  

key flexfield structure

0 Answers   Infosys,

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?

2 Answers   CTS,

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

0 Answers  

Give the two types of tables involved in producing a star schema and the type of data they hold.

1 Answers  

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

0 Answers  

What is cardinality?

4 Answers  

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

0 Answers   Pathway Technologies,

What is auto invoicing? : oracle accounts receivable

0 Answers  

Differentiate between transaction type and transaction source? : oracle accounts receivable

0 Answers  

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

1 Answers   HCL,