Home » RDBMS Server » Server Administration » ora 01861 (oracle 10g)
ora 01861 [message #410272] Thu, 25 June 2009 23:12 Go to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
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]

Report message to a moderator

Re: ora 01861 [message #410283 is a reply to message #410272] Fri, 26 June 2009 00:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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 #410295 is a reply to message #410272] Fri, 26 June 2009 00:55 Go to previous messageGo to next message
nitinkumarbe
Messages: 8
Registered: June 2009
Junior Member

Hi

Try using DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure. You can get TIME_REMAINING from it.

Hope it helps
Re: ora 01861 [message #410298 is a reply to message #410295] Fri, 26 June 2009 01:01 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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?

Quote:
Hope it helps

No, it doesn't.

Regards
Michel
Previous Topic: External Table is loading data
Next Topic: connected to Idle Instance
Goto Forum:
  


Current Time: Sat Dec 10 22:06:11 CST 2016

Total time taken to generate the page: 0.21102 seconds