userenv error [message #59339] |
Wed, 12 November 2003 15:28 |
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 |
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.
|
|
|