From niall.litchfield@dial.pipex.com Sat, 14 Jun 2003 15:29:41 -0700 From: "Niall Litchfield" Date: Sat, 14 Jun 2003 15:29:41 -0700 Subject: RE: Inverse 9i Question Message-ID: MIME-Version: 1.0 Content-Type: text/plain My answers A) Available in 9i Release 1 only as part of DBMS_REDEFINITION - available in 9.2 from SQL B) Not available at all in 9i Release 1 so far as I can see - available in 9.2 C) Not available at all D) Available E) Wrong name - should be DBMS_XPLAN.DISPLAY. So I'd say c),e) and maybe b) depending on what 9i is defined as. Is this an OCP question? Niall > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Freeman Robert - IL > Sent: 13 June 2003 21:10 > To: Multiple recipients of list ORACLE-L > Subject: Inverse 9i Question > > > Just in the mood to do one of these.... > Which of the following is *not* a feature of Oracle 9i? > > a. The ability to Rename a Column > b. The ability to Rename a Constraint > c. The ability to rename a tablespace > d. The ability to drop a column > e. The utl_xplan function to format execution plans from the > SQL prompt. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Freeman Robert - IL > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > and in the message BODY, include a line containing: UNSUB > ORACLE-L (or the name of mailing list you want to be removed > from). You may also send the HELP command for other > information (like subscribing). > <>