Re: show parameter sort_area ?

Duplicated the problem and found the solution. You must have logged in as a user other than oracle. If that's the case, first, make sure your ORACLE_HOME and LD_LIBRARY_PATH are correct (the latter should contain $ORACLE_HOME/lib). Then you have to login throufh SQL*Net. I.e. user_at_ORCL, not just user (followed by password). If you login as user not user_at_ORCL, then you get that error on "show parameter".

Tom must have logged in as oracle (owner of Oracle software files).

Yong Huang

rgaffuri_at_cox.net (Ryan Gaffuri) wrote in message news:<1efdad5b.0205291132.a62c5fc_at_posting.google.com>...
> I am reading Tom Kyte's book and I see in one of his examples he does
> the following
> show parameter sort_area and gets some information back.
>
> I get an error saying that this is an unknown command for both
> parameter and sort area. Im on 8.1.7 Im assuming I have to set
> something up to do use this?
Received on Wed Jun 12 2002 - 12:34:45 CDT