ORA-12031: cannot use primary key columns from materialized view log on "string"."string" Cause: The materialized view log either did not have primary key columns logged, or the timestamp associated with the primary key columns was more recent than the last refresh time. Action: A complete refresh is required before the next fast refresh. Add primary key columns to the materialized view log, if required.如果tnsping服务名正确, 重建用户并赋予connect, resource权限ORA-28009: connection to sys should be as sysdba or sysoper Cause: connect sys/<password> is no longer a valid syntax Action: Try connect sys/<password> as sysdba or connect sys/<password> as sysoper
Cause: The materialized view log either did not have primary key columns logged, or the timestamp associated with the primary key columns was more recent than the last refresh time.
Action: A complete refresh is required before the next fast refresh. Add primary key columns to the materialized view log, if required.如果tnsping服务名正确, 重建用户并赋予connect, resource权限ORA-28009: connection to sys should be as sysdba or sysoper
Cause: connect sys/<password> is no longer a valid syntax
Action: Try connect sys/<password> as sysdba or connect sys/<password> as sysoper
在服务器上就可以进入而在别的机子就不行