Home » Server Options » Replication » Snapshot status invalid
Snapshot status invalid [message #40041] Thu, 05 September 2002 04:11 Go to next message
Messages: 3
Registered: September 2002
Junior Member
I have created a snapshot using a synonym. (Synonym was created using database link). The snapshot becomes invalid when the password for the remote database is changed. So I recreated the database link and then recreated the snapshot. But it still shows as invalid on quering the user_objects table.
I also recreated the synonym and then tried creating snapshot but still it shows as invalid.

Help me to solve this problem

Thanks in advance.

Re: Snapshot status invalid [message #40044 is a reply to message #40041] Thu, 05 September 2002 05:45 Go to previous message
Mahesh Rajendran
Messages: 10697
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
query the user_objects.
select object_type from user_objects

is the output 'UNDEFINED'??
Previous Topic: viewing constraint on tables cascade
Next Topic: Backup/Recovery Solution
Goto Forum:

Current Time: Mon May 16 07:50:26 CDT 2022