Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01435: user does not exist - When Refreshing a Materialized View

Amit_220877Oct 12 2011 — edited Oct 12 2011
I am getting the below error while trying to refresh a MV from remote database table.

*
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


Anybody has idea how to fix it. thanx in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 9 2011
Added on Oct 12 2011
#general-database-discussions
5 comments
1,692 views