What is snapshot is too old? Give and example for better understand.
- 1 Answers
- 1702 Views
- TCS, I also Faced
- E-Mail Answers
Answer / Shiv Shkti Singh
"A snapshot that is too old refers to a database object (like a table or view) created at a specific point in time, which no longer reflects the current state of the data. In other words, it has become outdated since the creation time.nnFor example, let's say we have a 'sales' table and create a snapshot on January 1st: nCREATE SNAPSHOT sales_snap OF sales AS OF TRUNC(SYSDATE) - INTERVAL '30 days'; If we run this command on February 1st, the snapshot would be too old (outdated by 30 days) and would not accurately represent the current data in the 'sales' table."
| Is This Answer Correct ? | 0 Yes | 0 No |
Whether any commands are used for months calculation? If so, what are they?
I have a table like this Table Name:Products Productid Price 1 10 1 10 2 20 3 30 3 30 But i want to output like this. productid price 2 20. please replay me.
3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
Can we write dml statement in function in oracle?
How many different types of indexes we have in oracle?
24 Answers IBM, TCS,
Explain about integrity constraint?
Briefly explain what is literal? Give an example where it can be used?
Can a parameter be passed to a cursor?
How do you handle duplicate records in a database?
How to rename a tablespace in oracle?
What is oracle thin client?
is there a tool to trace queries, like profiler for sql server?
Oracle General 
