SQL> CONN /AS SYSDBA
已连接。
SQL> CREATE OR REPLACE VIEW SCOTT.VIEW_1 AS SELECT * FROM sh.CUSTOMERS;
CREATE OR REPLACE VIEW SCOTT.VIEW_1 AS SELECT * FROM sh.CUSTOMERS
                                                        *
第 1 行出现错误:

ORA-01031: 权限不足

处理办法：

  GRANT CREATE ANY TABLE TO scott;
  GRANT SELECT ANY TABLE TO scott;
  GRANT COMMENT ANY TABLE TO scott;
  GRANT LOCK ANY TABLE TO scott;
  GRANT SELECT ANY DICTIONARY TO scott;
  
  
  GRANT CREATE ANY TABLE TO sh;
  GRANT SELECT ANY TABLE TO sh;
  GRANT COMMENT ANY TABLE TO sh;
  GRANT LOCK ANY TABLE TO sh;
  GRANT SELECT ANY DICTIONARY TO sh;