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: Dbms_mview.explain_mview

Re: Dbms_mview.explain_mview

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Fri, 28 Feb 2003 22:27:16 +1000
Message-ID: <VoH7a.57377$jM5.146106@newsfeeds.bigpond.com>


Hi Jorgenbaz,

Stick an 'EXECUTE' in front my friend and you won't believe the difference.

Good Luck

Richard
"jorgenbaz" <member25683_at_dbforums.com> wrote in message news:2586978.1046421839_at_dbforums.com...
>
> How do I use this procedure? Guess I cant write it in sqlplus? I get the
> following result...
>
> DBMS_MVIEW.EXPLAIN_MVIEW(join_mv);
>
> SP2-0734: unknown command starts with DBMS_MVIEW...
>
> Thanks for any help
>
> --
> Posted via http://dbforums.com
Received on Fri Feb 28 2003 - 06:27:16 CST

Original text of this message

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