-
Hi,
I have Oracle 8.1.6 Server installed on Solaris 8 (64 bit) platform.
When ever I try conecting SQLPLUS it gives me the following
errors:
"select promptname from promtag where value='000'
error at line 1:
Ora-00942 table or view does not exist.
Enter value for prompt: "
This happens when I try invoking sqlplus. if I hit enter at prompt
it connects.
how do I resolve this problem ???
Thanks in advance
geo
-
Hi,
Check your Login and Glogin Files....
You must have Prompt in any of the above files.
Thanks
-
Thanks!
It worked. I commented out the set SQLPROMT line in the glogin scripts.
But are there any issues in commenting out the set SQLPROMT in the glogin script ??
Please let me know