Home » RDBMS Server » Server Administration » userenv error
userenv error [message #59339] Wed, 12 November 2003 15:28 Go to next message
B O'Shea
Messages: 2
Registered: November 2003
Junior Member
We had to drop a table and recreate it due to extents. That all worked fine, the table is back, but now everyone who tries to access the application gets " ora-02003" error, invalid userenv paramater. Can someone please shed some light? we are using oracle 8i
Thanks
Re: userenv error [message #59340 is a reply to message #59339] Wed, 12 November 2003 17:29 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Maybe its Oracle way of punishing you for rebuilding a table "due to extents" !

kidding aside, it looks like something else changed (ie invalid USerenv ) in your app along with this rebuild.

try to query the table using sqlplus and see what happens.
Previous Topic: tns & nls error
Next Topic: Enterprise Manager Configuration Assistant - No Listener!
Goto Forum:
  


Current Time: Fri Sep 20 15:35:43 CDT 2024