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

Thread: DBMS_Stats error message

Threaded View

  1. #11
    Join Date
    Oct 2006
    Posts
    175
    Good afternoon all,

    CREATE USER "gt-12" IDENTIFIED BY oracle;

    EXEC dbms_stats.gather_schema_stats(ownname=>'"gt-12"');
    PL/SQL block, executed in 0.172 sec.

    EXEC dbms_stats.gather_schema_stats(ownname=>'gt-12');
    ORA-20001: GT-12 is an invalid identifier
    ORA-06512: at "SYS.DBMS_STATS", line 1524
    ORA-06512: at "SYS.DBMS_STATS", line 1540
    ORA-06512: at "SYS.DBMS_STATS", line 1569
    ORA-06512: at "SYS.DBMS_STATS", line 13748
    ORA-06512: at "SYS.DBMS_STATS", line 13719
    ORA-06512: at line 2

    Make sure your schemaname doesn't start with a number. Please post the error msg if you find anything else.

    gtcol
    Last edited by gtcol; 09-17-2008 at 06:32 AM.

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