| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Script tp parse control file backup ??
I have a PL/SQL block I wrote that creates the trace file, without all =
the junk.
-----Original Message-----
From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM]
Sent: 01 July 2004 15:12
To: 'oracle-l_at_freelists.org'
Subject: RE: Script tp parse control file backup ??
Prem
I don't understand your request. To convert the trace version of the
controlfile to a usable script is a simple matter of removing lines, =
easily
accomplished with an editor like vi in Unix or Wordpad in Winders. If =
you
need an automated method, that will depend on your platform and tools
available. Also note that in 9i you can specify the name of the created
trace file.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com=20
I said it "looked" clear - Riddick
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Prem Khanna J
Sent: Thursday, July 01, 2004 12:12 AM
To: oracle-l_at_freelists.org
Subject: Script tp parse control file backup ??
Hi All,
SQL > alter system backup controlfile to trace;
Does anybody have a script to parse this control file backup ? that is, i need to create a neat script that contains just
STARTUP NOMOUNT
CREATE CONTROLFILE...
...
...
CHARACTER SET JA16SJIS;
Can someone share it with me ??
Thanks and Regards,
Prem.
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |