PL/SQL block, executed in 0.172 sec.
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.
Thaks for your email.
It seems that the name shoudn't have "-" or digit.
I exported the one that has problem and imported in another schema which has just simple name (TEST). It is OK now.
I am still surprize because I have this schema since 3 years ago and I haven't faced with problem before. I did so many export and import and because of so many test environemts always I distinguished them by for example schema+code (T1-AW23-7).
After applying the patch 8 to Oracle 9i I realized that when I import the sceham, the statistics don't update and the Last-Analyzed column in EM is empty. I checked the import log and saw the DBMS_Stat problem.
I can not find the reason why its worked before and it doesn't now.
There isn't in restriction in the name of database by oracle.
The name can be T1-TEST. ( I am not sure about starting name with digit).
and the script for statistics is
I checked that and is working fine.
My problem that may be I didn't describ it correctly is import schema doesn't update the statistics and the Last-Analyzed column in EM is empty after importing. and I should do the statistics manually to have it.
This problem is new for me, I experinced so many import and export and before applying the patch (I am not sure there is any correlation between them) the import doesn't update the statistics of schema tables.