i deleted 4 records form the table.after i have applied commit
.now i want to get back those records.how?
Answer Posted / 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 |
Post New Answer View All Answers
What is user managed backup in Oracle?
What is recovery manager in Oracle?
Respected sir, Please send me technical questions related to oracle apps..
How to create a table index in oracle?
How to shutdown your 10g xe server?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How to delete a column in an existing table in oracle?
How remove data files before opening a database?
Query to retrieve record for a many to many relationship ?
How to convert a date to char in oracle? Give one example.
How to convert characters to dates in oracle?
What is a tns service name?
How to define a record variable to store a table row?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
How to open a cursor variable?