No question at this time
The DBA-Village forum
as RSS feed
Site Statistics| Ever registered users | 48742 | | Total active users | 1337 | | Act. users last 24h | 1 | | Act. users last hour | 0 | | Registered user hits last week | 108 | | Registered user hits last month | 471 |
|
Go up
Exhausted Resultset
| Message |
Score |
Author |
Date |
   Hi,
User says "We have encountered one of the t...... |
|
Balaji M |
Dec 15, 2022, 08:24 |
|
This is NOT an Oracle error.
What should you ...... |
  |
Michel Cadot |
Dec 15, 2022, 15:22 |
| Hi,
If the table is missing, we should flashbac...... |
|
Balaji M |
Dec 15, 2022, 15:32 |
|
>>> <i>If the table is missing, we should flashb...... |
|
Michel Cadot |
Dec 15, 2022, 15:50 |
| I have no option. Please let me know how to find t...... |
|
Balaji M |
Dec 15, 2022, 16:03 |
|
I meant what options Oracle gives you to answer ...... |
|
Michel Cadot |
Dec 15, 2022, 17:32 |
| Subject: |
Exhausted Resultset |
| Author: |
Balaji M, India |
| Date: |
Dec 15, 2022, 08:24, 170 days ago |
| Os info: |
Red Hat Enterprise Linux Server release 7.9 (Maipo) |
| Oracle info: |
19.0.0.0.0 |
| Message: |
Hi,
User says "We have encountered one of the table demo.table1 in the database is missing and
that is causing problems in the application data flow, and we are seeing “Exhausted Resultset”
error."
Kindly let me know how to fix this issue.
Regards,
Balaji
|
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: Exhausted Resultset |
| Author: |
Michel Cadot, France |
| Date: |
Dec 15, 2022, 15:22, 170 days ago |
| Score: |
|
| Message: |
This is NOT an Oracle error.
What should you do if a table is missing?
Try to think a little bit.
Michel
|
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: Exhausted Resultset |
| Author: |
Balaji M, India |
| Date: |
Dec 15, 2022, 15:32, 170 days ago |
| Message: |
Hi,
If the table is missing, we should flashback the table. But the user wants to know
how and when it happened.
Regards,
Balaji |
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: Exhausted Resultset |
| Author: |
Michel Cadot, France |
| Date: |
Dec 15, 2022, 15:50, 170 days ago |
| Score: |
|
| Message: |
>>> If the table is missing, we should flashback the table.
And would you do to do this?
>>> But the user wants to know how and when it happened.
And what are your options for this?
Michel
|
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: Exhausted Resultset |
| Author: |
Balaji M, India |
| Date: |
Dec 15, 2022, 16:03, 170 days ago |
| Message: |
I have no option. Please let me know how to find this information.
Regards,
Balaji |
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
| Subject: |
Re: Exhausted Resultset |
| Author: |
Michel Cadot, France |
| Date: |
Dec 15, 2022, 17:32, 169 days ago |
| Score: |
|
| Message: |
I meant what options Oracle gives you to answer this question?
Note: Google can help you but only if you use it.
Michel
|
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
|