I didn't mean to scold... you post way more information than I usually
do!
And I answer whilst eating breakfast at times too :)
Richard *is* right, the problem is, the sql statement is misformed but
the answer key says it will work. Which is yet another reason I dislike
the OCP exams.
- Jonathan Gennick <jonathan_at_gennick.com> wrote:
> Wednesday, January 7, 2004, 8:29:25 AM, Rachel Carmichael
> (wisernet100_at_yahoo.com) wrote:
> RC> I successfully use "drop tablespace including contents and
> datafiles"
> RC> all the time. And a quick check of the docs shows that "cascade
> RC> constraints" is valid but, as Richard said, belongs at the end of
> the
> RC> statement.
>
> I stand corrected, though I did admit up front to not
> having checked the manual. I was eating breakfast at the
> time, so forgive me that one lapse.
>
> I liked Richard's point about trusting what you see. He was
> spot on with that comment, at least in this context.
>
> Best regards,
>
> Jonathan Gennick --- Brighten the corner where you are
> http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com
>
> Join the Oracle-article list and receive one
> article on Oracle technologies per month by
> email. To join, visit
> http://four.pairlist.net/mailman/listinfo/oracle-article,
> or send email to Oracle-article-request_at_gennick.com and
> include the word "subscribe" in either the subject or body.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jonathan Gennick
> INET: jonathan_at_gennick.com
>
> 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: ListGuru_at_fatcity.com (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).
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Wed Jan 07 2004 - 08:34:24 CST
