这个问题一般是ogguser权限不够造成的
grant sysdba to ogguser;
grant select ,insert ,update,delete on maptable to OGGUSER;
反正就是ogguser缺少权限
CREATE SESSION, ALTER SESSION ALTER SYSTEM RESOURCE CONNECT SELECT ANY DICTIONARY FLASHBACK ANY TABLE SELECT ANY TABLE SELECT on dba_clusters EXECUTE on DBMS_FLASHBACK package GGS_GGSUSER_ROLE
GRANT CONNECT,RESOURCE,DBA TO ogguser; ALTER USER ogguser QUOTA UNLIMITED ON <Tablespace_name>; exec dbms_streams_auth.grant_admin_privilege('ogguser'); EXEC dbms_goldengate_auth.grant_admin_privilege('ogguser'); grant execute on utl_file to ogguser; grant select any transaction to ogguser; grant flashback any table to ogguser;
从上往下执行把,执行一个看好了没好,一般给个dba权限就好了
- insufficient privileges status Error 01031insufficient privileges status error scheduler_job insufficient schema_name privileges insufficient privileges unable values status_device_hardware_error status_device_hardware_error hardware 0000483 cannot status error input 01031 01031 15019 ora tt insufficient insufficient completion ora diskgroup