这是公司请的dba解决这个问题的全过程,反正我是一脸懵逼。
Connecting to 10.206.1.126:22...
Connection established.To escape to local shell, press 'Ctrl+Alt+]'.
Last login: Tue Feb 6 19:19:31 2018 from 10.206.14.112
[root@localhost ~]# su - oracle
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Wed Feb 7 15:12:54 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> exec dbms_stats.gather_schema_stats('ccs_s')^H^H^H^[[3~
BEGIN dbms_stats.gather_schema_stats('ccs_; END;
*
ERROR at line 1:
ORA-06550: line 1, column 46:
PLS-00103: Encountered the symbol "" when expecting one of the following:
:= . ( % ;
SQL>
SQL>
SQL> exec dbms_stats.gather_schema_stats('ccs_sd');
PL/SQL procedure successfully completed.
SQL> SQL> exec dbms_stats.gather_schema_stats('ccs_sm');
BEGIN dbms_stats.gather_schema_stats('ccs_sm'); END;
*
ERROR at line 1:
ORA-20000: Schema "CCS_SM" does not exist or insufficient privileges
ORA-06512: at "SYS.DBMS_STATS", line 38298
ORA-06512: at "SYS.DBMS_STATS", line 38257
ORA-06512: at "SYS.DBMS_STATS", line 8593
ORA-06512: at "SYS.DBMS_STATS", line 38140
ORA-06512: at "SYS.DBMS_STATS", line 38285
ORA-06512: at line 1
SQL> exec dbms_stats.gather_schema_stats('ccs_mm');
exec dbms_stats.gather_schema_stats('ccs_pm');
PL/SQL procedure successfully completed.
SQL> SQL> SQL>
exec dbms_stats.gather_schema_stats('ccs_fm');
exec dbms_stats.gather_schema_stats('ccs_ct');
PL/SQL procedure successfully completed.
SQL> SQL> SQL> SQL>
exec dbms_stats.gather_schema_stats('ccs_mdm');
PL/SQL procedure successfully completed.
SQL> SQL>