Re: anyone have a decent purge script for 11g diag directories

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Sat, 15 Nov 2008 09:35:18 +0100
Message-ID: <491E89C6.9070407@gmail.com>


DA Morgan schrieb:
> Mladen Gogala wrote:

>> DA Morgan wrote:
>>
>>> What I'd like to see is an easy way to do backup controlfile to
>>> trace and not have the file named like every other trace file (I
>>> mean the text version not just the binary). That would be a
>>> decent enhancement.
>>
>> You mean something like this?
>> SQL> SQL> alter database backup controlfile to trace as '/tmp/dan.sql';
>>
>> Database altered.

>
> That makes a binary copy not a text copy. Please note that I
> addressed that above.

That produces either ORA-00933 (on 9.0.1 and below) or textfile (from 9.2 onwards).

Best regards

Maxim Received on Sat Nov 15 2008 - 02:35:18 CST

Original text of this message