OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ora 01861 (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: ora 01861 [message #410274 is a reply to message #410272]

Thu, 25 June 2009 23:16

BlackSwan
Messages: 26766
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

Michel Cadot
Messages: 68665
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

Report message to a moderator

Re: ora 01861 [message #410295 is a reply to message #410272]

Fri, 26 June 2009 00:55

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

Report message to a moderator

Re: ora 01861 [message #410298 is a reply to message #410295]

Fri, 26 June 2009 01:01

Michel Cadot
Messages: 68665
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

Report message to a moderator

Previous Topic:	External Table is loading data
Next Topic:	connected to Idle Instance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 23:00:34 CDT 2024