Duplicated snapshot logs in Oracle 8i

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

This Content Component encountered an error

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 first published in May 2001

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close