| ora 01861 [message #410272] |
Thu, 25 June 2009 23:12  |
dkekim
Messages: 1
Registered: June 2009 |
Junior Member |
|
|
Hi,
When i tried to query from v$session_longops, i'm getting the ora 01861 error. but when i added a where clause sth like where time_remaining > 0, no error encountered but 0 results were returned.
Is there any other way such that i can view the v$session_longops.time_remaining data?
Thanks
|
|
|
| Re: ora 01861 [message #410274 is a reply to message #410272] |
Thu, 25 June 2009 23:16  |
 |
BlackSwan
Messages: 3227
Registered: January 2009 |
Senior Member |
|
|
01861, 00000, "literal does not match format string"
// *Cause: Literals in the input must be the same length as literals in
// the format string (with the exception of leading whitespace). If the
// "FX" modifier has been toggled on, the literal must match exactly,
// with no extra whitespace.
// *Action: Correct the format string to match the literal.
Oracle did not like what you did, but since you decided we did not need to actually see what generated the error, you have a mystery & we we have no real clues.
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.
[Updated on: Thu, 25 June 2009 23:17]
|
|
|
| Re: ora 01861 [message #410283 is a reply to message #410272] |
Fri, 26 June 2009 00:12 |
Michel Cadot
Messages: 29000
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
| Quote: | Is there any other way such that i can view the v$session_longops.time_remaining data?
|
What is the problem with this way?
Do you want rows with time_remaining < 0?
Regards
Michel
|
|
|
|
| Re: ora 01861 [message #410298 is a reply to message #410295] |
Fri, 26 June 2009 01:01 |
Michel Cadot
Messages: 29000
Registered: March 2007
Location: Nanterre, France, http://... |
Senior Member |
|
|
| Quote: | Try using DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS
You can get TIME_REMAINING from it.
|
Something inconsistent there, doesn't it?
DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS (
rindex IN OUT BINARY_INTEGER,
slno IN OUT BINARY_INTEGER,
op_name IN VARCHAR2 DEFAULT NULL,
target IN BINARY_INTEGER DEFAULT 0,
context IN BINARY_INTEGER DEFAULT 0,
sofar IN NUMBER DEFAULT 0,
totalwork IN NUMBER DEFAULT 0,
target_desc IN VARCHAR2 DEFAULT 'unknown target',
units IN VARCHAR2 DEFAULT NULL)
Where is time_remaining there?
No, it doesn't.
Regards
Michel
|
|
|
] 
Members
Search
Help
Register
Login
Home
