Duplicated snapshot logs in Oracle 8i

Learn how to drop the duplicate snapshot logs created when you recreate your snapshots in a replication environment.

Sometimes when you recreate (drop + create) your snapshots at a snapshot site within a replication environment,...

the snapshot logs can be duplicated. If this happens, you must drop one of the snapshot logs--namely, the old one.

Glancing at the SYS.SLOG$ table will show you how many snapshot logs you have. You can then issue this SQL command to drop the older snapshot logs:

DBMS_SNAPSHOT.DROP('ow','master','date')

where:

ow = snapshot log owner
master = master table name
date = using this format DD-MON-YY HH24:MI:SS

For More Information


This was last published in May 2001

Dig Deeper on Oracle database design and architecture

PRO+

Content

Find more PRO+ content and other member only offers, here.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close