Snapshot drop

From: Kishore <mcgoracle_at_yahoo.com>
Date: Thu, 24 May 2001 10:49:20 -0700
Message-ID: <F001.0030D855.20010524091537@fatcity.com>

Hello Gurus

Please help me in dropping and recreating the snapshots. what happened was.

I had connection down between we adn the destination, when the connection came alive , I tried to do following to refresh the snapshots.

1- exec dbms_job.run(153)

This did not do any good so I tried.

2- exec dbms_snapshot.refresh('snapshotname','?')

This worked on 8 out of 10. The two did not get refreshed and they are not getting refreshed since two days now. I tried to drop them and recreste them. They do not get drop.

Please help me as how to solve this problem.

Thank you very much

Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kishore
INET: mcgoracle_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu May 24 2001 - 12:49:20 CDT