No question at this time
DBA Top 10
1 M. Cadot 7000
2 B. Vroman 3000
3 P. Wisse 1300
4 P. Tsongayinwe 1100
5 J. Péran 1000
6 A. Kavsek 600
7 D. Walgude 400
7 J. Schnackenberg 400
9 J. Alcroft 200
9 B. M 200
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48717
Total active users1324
Act. users last 24h1
Act. users last hour0
Registered user hits last week17
Registered user hits last month178
Go up

Exhausted Resultset
Next thread: Season's greetings, Oracle-mathematical way
Prev thread: ALTER SYSTEM work for ordinary users

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

Follow up by mail Click here


Subject: Exhausted Resultset
Author: Balaji M, India
Date: Dec 15, 2022, 08:24, 55 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, 55 days ago
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, 55 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, 55 days ago
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, 55 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, 55 days ago
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