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: <Christopher.Jones_at_oracle.comX>
Date: 31 May 2002 11:32:52 +1000
Message-ID: <u3cw985kr.fsf@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

-- 
Christopher Jones, Oracle Corporation, Australia.
Received on Thu May 30 2002 - 20:32:52 CDT

Original text of this message

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