Re: CONFESSION TIME. -- large file on NT

From: RSH <RSH_Oracle_at_worldnet.att.net>
Date: Fri, 08 Mar 2002 22:37:17 GMT
Message-ID: <x2bi8.659$Ex5.45600@bgtnsc04-news.ops.worldnet.att.net>

This might be a good time to look at all the validate/test procedures Oracle gives you in PL/SQL and work using them into checking all your datafiles, tablespaces, indices, and so forth.

And if all come up clean, try this little tidbit (we KNEW we had a rotten tablespace and/or datafile, but none of that stuff detected it);

just write a script to take each tablespace offline and put it back online again. We found the skunk, it would not come back online, and we did a pretty easy recover and all was well. (Apart from the hysterics limited to the confines of the card-key access controlled IT department.)

RSH. Received on Fri Mar 08 2002 - 16:37:17 CST