Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: show parameter sort_area ?

Re: show parameter sort_area ?

From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 31 May 2002 04:25:14 -0700
Message-ID: <1efdad5b.0205310325.131e91bb@posting.google.com>


Christopher.Jones_at_oracle.comX wrote in message news:<u3cw985kr.fsf_at_oracle.comX>...
> rgaffuri_at_cox.net (Ryan Gaffuri) writes:
> > Chris
> >
> > The query is fine, but Im not sure why show parameter doesnt work. I
> > ran it from my SYS account and this is what happened? Im assuming I
> > need to activate some environmental thing.
> >
> > Im on Oracle 8.1.7
> >
> > SPAN_at_DEV> SHOW PARAMETER sort_area
> > unknown SHOW option "PARAMETER"
> > unknown SHOW option "sort_area"
>
> SHOW is a SQL*Plus command. The SHOW PARAMETER option was implemented
> in SQL*Plus 8.1. It looks like your version of SQL*Plus is older than
> this.
>
> Chris

No I have 8.1.7 and it works on the server. I have been messing around with falot of my background scripts. This means I wrecked the one that built the SHOW command. Anyone know where it is? So I can find? Received on Fri May 31 2002 - 06:25:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US