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
|
|
|