RE: Inverse 9i Question

My answers

1. Available in 9i Release 1 only as part of DBMS_REDEFINITION - available in 9.2 from SQL
2. Not available at all in 9i Release 1 so far as I can see - available in 9.2
3. Not available at all
4. Available
5. 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).
>

<<winmail.dat>> Received on Sat Jun 14 2003 - 17:29:41 CDT