Sorry, this is not true.
Initially (pre 8i) this was possible in *svrmgrl* only and *not* in
sql*plus.
In 8i it should work in sql*plus, provided you have the dba role or the
select_catalog_role.
Hth
--
Sybrand Bakker
Senior Oracle DBA
to reply remove '-verwijderdit' from my e-mail address
"Alex Ivascu" <alex_at_ivascu.com> wrote in message
news:1BaJ8.11615$jt6.3433786_at_typhoon3.we.ipsvc.net...
> It sounds like you're trying to execute/select this from within svrmgrl.
> You can/have to use this command from sql*plus - only. In svrmgrl you can
> run a query such as this: select value from v$parameter where
> name='sort_area';
>
> Hope this helps.
>
> Alex Ivascu
>
>
> "Ryan Gaffuri" <rgaffuri_at_cox.net> 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 May 29 2002 - 15:34:22 CDT
