-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|