DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Error

  1. #1
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340

    Error

    when i am trying to run this, getting err......

    SQL> declare
    2 qtxt2 varchar2(4000) :='select owern,count(*) from bigtab group by owner';
    3 idno varchar2(30) :='id2';
    4 begin
    5 execute immediate 'truncate table rewrite_table';
    6 dbms_mview.explain_rewrite (
    7 query => qtxt2,
    8 mv => 'GOPU.MV_BIGTAB',
    9 statement_id => 'id2');
    10 end;
    11 /
    declare
    *
    ERROR at line 1:
    ORA-00904: : invalid identifier
    ORA-06512: at "SYS.DBMS_XRWMV", line 94
    ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3210
    ORA-06512: at line 6
    Last edited by gopu_g; 04-03-2008 at 08:47 AM.

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Can you run it from straight SQL? Maybe you are missing a direct grant on GOPU.MV_BIGTAB.

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    you mis-spelled owner in the query - you put owern, therefore you get invalid identifier as the error says

  4. #4
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    thanks davey..i found it

  5. #5
    Join Date
    Mar 2010
    Posts
    1
    GOPU

    Can you tell me, how did you resolve your problem, please? i have the same issue

    Thanks!!

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by AndreaG View Post
    Can you tell me, how did you resolve your problem, please? i have the same issue
    Gopu bumped into a well known "interface issue" (*) that may hit you from time to time no matter Oracle version or platform.

    If you bumped into the same issue... fix the typo!

    (*) interface in between the chair and the keyboard! ... sorry, couldn't help myself.
    Last edited by PAVB; 03-28-2010 at 04:29 PM. Reason: typo
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    Quote Originally Posted by AndreaG View Post
    GOPU

    Can you tell me, how did you resolve your problem, please? i have the same issue

    Thanks!!
    do you have problems reading?

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