Home » Server Options » Replication » Snapshot status invalid
Snapshot status invalid [message #40041] Thu, 05 September 2002 04:11 Go to next message
RameshDB
Messages: 3
Registered: September 2002
Junior Member
Hello,
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.

Regards,
Ramesh
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: 10707
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: Thu Mar 28 05:04:44 CDT 2024