dropping mv Log
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: dropping mv Log

  1. #1
    Join Date
    Sep 2001
    Posts
    200

    dropping mv Log

    drop Materialized view log msis_dim.msm_age_grp;

    drop Materialized view log msis_dim.msm_age_grp
    *
    ERROR at line 1:
    ORA-00969: missing ON keyword

    Hi
    I attempted to create am MV. It failed but before then my script had already created the MV log. Now I want to drop the MV log but it won't work. What is missing here?
    NB the MV has not been created yet.
    Thanks
    Life is what is happening today while you were planning tomorrow.

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Well, the error message is pretty self-explanatory, isn't it?
    Code:
    drop Materialized view log ON msis_dim.msm_age_grp;
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Sep 2001
    Posts
    200
    Thanks
    That was silly on my part...
    Life is what is happening today while you were planning tomorrow.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width