Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


i deleted 4 records form the table.after i have applied commit
.now i want to get back those records.how?

Answers were Sorted based on User's Feedback



i deleted 4 records form the table.after i have applied commit .now i want to get back those recor..

Answer / serena

Using flashback table:
# enable row movement
1) alter table test2 enable row movement;
# flashback test2 to 10 minutes ago.
2) FLASHBACK TABLE test2 TO TIMESTAMP SYSTIMESTAMP -
INTERVAL '10' MINUTE;

Is This Answer Correct ?    16 Yes 0 No

i deleted 4 records form the table.after i have applied commit .now i want to get back those recor..

Answer / bipin maurya

first of all u can executed first query after that u can executed sec query

ALTER TABLE table2 ENABLE ROW movement

flashback TABLE table2 TO timestamp systimestamp-interval
'100' minute

Thanks
Bipin Maurya
Mo-+919812630225

Is This Answer Correct ?    5 Yes 0 No

i deleted 4 records form the table.after i have applied commit .now i want to get back those recor..

Answer / asnani_satish@yahoo.com

Flashback table feature is available from Oracle 9i onwards
only. Before that deleted records once committed cannot be
rolled back. As far as Oracle 9i onwards the solution
specified by Bipin Maurya is correct. But i would like to
add something. For using FLASHBACK TABLE the user must be
granted privilege for the same. But there is another way out.

create table temp_new as select * from temp as of timestamp
to_timestamp('11/01/2011 08:45:00','dd/mm/yyyy hh24:mi:ss');

This will bring the table to the point in time specified by
timestamp.

Is This Answer Correct ?    4 Yes 1 No

i deleted 4 records form the table.after i have applied commit .now i want to get back those recor..

Answer / manojkumar

Wow really excellent.(Asnani_satish,Bipin ,serena)
Thanks a lot

Is This Answer Correct ?    1 Yes 0 No

i deleted 4 records form the table.after i have applied commit .now i want to get back those recor..

Answer / venkata

No,But some limitation time ... we can get a DBA

Is This Answer Correct ?    1 Yes 0 No

i deleted 4 records form the table.after i have applied commit .now i want to get back those recor..

Answer / yash

NO We can't get back those records once commit has been done.

Is This Answer Correct ?    15 Yes 18 No

i deleted 4 records form the table.after i have applied commit .now i want to get back those recor..

Answer / kishore

NO We can't get back those records once commit has been done.

Is This Answer Correct ?    1 Yes 5 No

Post New Answer

More Oracle General Interview Questions

What is a data segment ?

1 Answers  


What is where clause in oracle?

0 Answers  


Is java required for oracle client?

0 Answers  


What is a system tablespace and when it is created?

0 Answers  


what is the difference between authorization and authentication?

4 Answers   MAHINDRA, PUCIT,


How to use subqueries in the from clause in oracle?

0 Answers  


What is the difference between "as" and "is" in an oracle stored procedure?

0 Answers  


How many categories of data types?

0 Answers  


Explain the use of owner option in exp command.

0 Answers  


How to call a stored procedure inside a trigger? Give an example.

1 Answers   Exilant,


In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

0 Answers   IBM,


How can I combine multiple rows into a comma-delimited list in oracle?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1809)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)