Home » Server Options » Replication » Error in refreshing MV (Oracle 10.2 on Solaris 5.9)
Error in refreshing MV [message #526820] Thu, 13 October 2011 03:59
amitgoel_zyahoocom
Messages: 1
Registered: October 2011
Location: UK
Junior Member
I am getting the following error while trying to refresh a MV from remote site.


SQL> Connected.
SQL> SQL> SET TIME ON
14:28:25 SQL> SET TIMING ON
14:28:25 SQL>
14:28:25 SQL> -- SQL DML or EXECUTE commands
14:28:25 SQL> exec bom_maint_pkg.refresh_bom_snapshots( &1 )
starting bom_maint_pkg.refresh_bom_snapshots [14:28:25]
.starting bom_maint_pkg.rebuild_unusable_indexes [14:28:25]
.ending bom_maint_pkg.rebuild_unusable_indexes [14:28:25]
.refreshing BOM_KBI_REF [14:28:25]
BEGIN bom_maint_pkg.refresh_bom_snapshots( 2 ); END;

*
ERROR at line 1:
ORA-01435: user does not exist
ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 350
ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 432
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2255
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2461
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2430
ORA-06512: at "TILOWNER1.BOM_MAINT_PKG", line 146
ORA-06512: at "TILOWNER1.BOM_MAINT_PKG", line 166
ORA-06512: at line 1



-----

following is the procedure i am using to refresh it.

procedure refresh_bom_snapshots (
p_debug_level INTEGER DEFAULT 0 )
is

procedure refresh_snapshot (p_name varchar2)
is
begin
debug_write (2,'Y','refreshing ' ||p_name );

output_row_count ( p_name , 'old number of rows in');

DBMS_SNAPSHOT.REFRESH(
LIST => 'TILOWNER1.' ||p_name
,PUSH_DEFERRED_RPC => TRUE
,REFRESH_AFTER_ERRORS => TRUE
,PURGE_OPTION => 1
,PARALLELISM => 0
,ATOMIC_REFRESH => TRUE
,NESTED => FALSE);

commit;

output_row_count ( p_name , 'new number of rows in');
end refresh_snapshot;

begin
m_current_debug_level := p_debug_level;
debug_write (1,'Y','starting bom_maint_pkg.refresh_bom_snapshots');

rebuild_unusable_indexes;

refresh_snapshot ('BOM_KBI_REF');
refresh_snapshot ('BOM_LOB_REFERENCE');


Do anybody has Idea what is causing this issue.

Amit

Previous Topic: Apply Process is not working
Next Topic: Pausing and Resuming of refreshing Materialised views
Goto Forum:
  


Current Time: Fri Mar 29 03:01:44 CDT 2024