Can We Recover OME Table From Recycle Bin?

Suppose OME table has been dropped by the application user so suppse flashback on we can recover it from recycle bin but what is the retention upto which we can get back that table?

Kindly share your valuable views here.

Thanks in advance.

Comments

Abhijeet Mudgal |

| 06 Nov 2015 12:07 pm

Helpful answer

It specifies the upper limit (in minutes) on how far back in time the database may be flashed back. How far back one can flashback a database depends on how much flashback data Oracle has kept in the flash recovery area.

That is something related to flashback destnation ie how many days flashback logs we have in our target area but re-cycle bin is a entirely defferent part.

Enterprise Structure Related SAP FICO Interview Questions and AnswersFAQ: Enterprise Structure related SAP FICO What are the various organizational assignments to a company code?Company Code is a legal entity for which financial statements like Profit and Loss and Balance Sheets are generated. Plants are assigned to the company code, Purchasing organization is...

SAP BASIS Interview Questions For Beginner LevelI am unable to give the answer for following questions. If anybody knows the answer, please update the answers and replay to all. It is really very help to all sap basis consultant.1.What is the difference between System Trace, Developer Trace and System Log?2.Incase, My sap system was down (Users...

Importance of HANA and Hadoop in SAP.HANA and Hadoop are known to be very friendly however there are quite a few differences between the two of them. While on one hand one can use HANA for storing high-value, typically meant for data related purposes, Hadoop on the other hand is more often used for persisting information to be used...

20 Tips and Tricks to Crack Jobs in SAPThe most common problem that most of us have faced at the beginning of our career is how do we get our first job without any experience, and the dilemma is we can’t get an experience without a job! However, many a times employers prefer fresher’s who come with a fresh bent of mind...

How Can I Recover Instance from SMON?
Hello Experts,Could you please let me know that what exactly SMON process do? And what will happen if we kill it forcefully?Kindly share your valuable views here, thanks in advance.

How to Recover Database?
Hello Friends,I have a query that I need to share with you guys. Please have a look:I issued the following command \"rman>backup current controlfile;\" and then I deleted all the controlfiles of...

Can We Restore Control file from Auto-Backup?
Hello Experts,Suppose If we have lost all multiplexed control files. can we restore control file from autobackup?How oracle will identify RMAN meta data information about autobackup location because...

From Where to Where We Need to Create DB-link?
Hello Experts,I have faced one issue. Can anyone please tell me how can i refresh the table using sql> \'copy command. i have read the oracle document but i did not understand from where to where...

Oracle DUAL Table Avoid Hard Parsing
We have been asked to avoid hard parsing of the some SQL statements involving DUAL Table. For example 1 of the queries to avoid hard parsing is as follows SELECT COUNT(*) FROM DUAL where...

How Can We Tune the Query(Table)?
How can we Tune the Query(Table)? its running fine yesterday but today its taking long time to fetch.Steps to tune the query please.

Oracle upgrade from 9i to 10g
Dear all, Currently we are using SAP R/3 4.7 on HP-UX with RDBMS oracle 9i. As we know, oracle 9i is out of support so now we want to upgarde it to oracle 10g. Can someone send me any docs...

How Can We Deploy Oracle Forms in Web?
hello, i have developed two tier applications using forms developer. now i want to deploy the application in web. how i can deploy it in web? please help.