Interested to Buy Any Domain ? << Click Here >> for more details...
Can We Restore a Table that accidantly dropped.
- 8 Answers
- 15948 Views
- TCS, I also Faced
- E-Mail Answers
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
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
1. What is PO rate variance gain and loss?
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
what are basic modules required to implement oracle application in any oraganisation?
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
What is chargeback invoice? How do we create it? : oracle accounts receivable
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
Explain prerequisites and post activities of oracle database installation
how to replace not in with not exist?
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
what are the API of GL,PO,AP
Difference between negative and positive adjustments : oracle accounts receivable
What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
