Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Excel Sheet - Patch level History
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C02952.9BA35B60
Content-Type: text/plain
I have a basic doubt .. whether can I import only procedures and functions excluding the tables and others from the exprot file.
Can anybody help?
Venkat K
> ----------
> From: Paul Drake[SMTP:paled_at_home.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Wednesday, September 27, 2000 12:55 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Excel Sheet - Patch level History
>
> Hi Glen,
>
> How about tracking:
>
> path/name of export prior to patch being applied
> tape label with pre-patch full cold backup (there is no downgrade, just
> re-installs or recover)
> @catalog.sql;
> @catproc.sql;
> @catexp.sql;
> create or replace java system; (if you're into that)
> shutdown
> computed statistics
>
> Paul
>
> P.S. watch out for the EXP-00008 ORA-00904 during export post - 8.1.6.1.2
> patch for
> NT.
>
>
> glen.bernas_at_marchFIRST.com wrote:
>
> > To: ORACLE-L_at_fatcity.com
> > cc:
> >
> > Can any suggest or recommend information I need to enter to keep a log
> of patch
> > levels and bugs. I came up with the following sub-titles
> >
> > Server
> > Patch Number
> > Description of patch
> > TAR
> > Module
> > Date Applied
> > Who (who applied path)
> > Description of bug/error
> >
> > ~~~~~~~~~~~~~~~~~~~~~~
> > Glen R. Bernas
> > Oracle DBA
> > Boston, MA
> > www.marchFIRST.com
> > glen.bernas_at_marchFIRST.com
> > Cell: 603 315-9380
> > Work: 603 890-1703 x 257
> > 800 426-7767
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: glen.bernas_at_marchFIRST.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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Paul Drake
> INET: paled_at_home.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).
>
------_=_NextPart_001_01C02952.9BA35B60
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =charset=3Dus-ascii">
<TITLE>RE: Excel Sheet - Patch level History</TITLE> </HEAD> <BODY>
<P><FONT COLOR=3D"#800080" SIZE=3D2 FACE=3D"Arial">I have a basic doubt = .. whether can I import only procedures and functions excluding = the tables and others from the exprot file. </FONT></P>
<P><FONT COLOR=3D"#800080" SIZE=3D2 FACE=3D"Arial">Can anybody =
help?</FONT>
</P>
<BR>
<P><B><I><FONT COLOR=3D"#800080" FACE=3D"Times New Roman">Venkat = K</FONT></I></B>
</P> <BR> <UL> <P><FONT SIZE=3D1 FACE=3D"MS Sans Serif">----------</FONT> <BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">From:</FONT></B> = <FONT SIZE=3D1 FACE=3D"MS Sans Serif">Paul =Drake[SMTP:paled_at_home.com]</FONT>
<P><FONT SIZE=3D2 FACE=3D"Arial">Hi Glen,</FONT> </P>
<P><FONT SIZE=3D2 FACE=3D"Arial">How about tracking:</FONT> </P>
<P><FONT SIZE=3D2 FACE=3D"Arial">path/name of export prior to patch =
being applied</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">tape label with pre-patch full cold =
backup (there is no downgrade, just</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">re-installs or recover)</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">@catalog.sql;</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">@catproc.sql;</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">@catexp.sql;</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">create or replace java system; (if =you're into that)</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">shutdown</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">computed statistics</FONT> </P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Paul</FONT> </P>
<P><FONT SIZE=3D2 FACE=3D"Arial">P.S. watch out for the EXP-00008 = ORA-00904 during export post - 8.1.6.1.2 patch for</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">NT.</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">glen.bernas_at_marchFIRST.com =
wrote:</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">> To: = ORACLE-L_at_fatcity.com</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">> cc:</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> Can any suggest or recommend =information I need to enter to keep a log of patch</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> levels and bugs. I came up = with the following sub-titles</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> ~~~~~~~~~~~~~~~~~~~~~~</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> Glen R. Bernas</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> Oracle DBA</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> Boston, MA</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> www.marchFIRST.com</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> glen.bernas_at_marchFIRST.com</FONT>=
<BR><FONT SIZE=3D2 FACE=3D"Arial">> Cell: 603 315-9380</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">> Work: 603 890-1703 x =
257</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">> 800 =
426-7767</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">></FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> --</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> Please see the official ORACLE-L =FAQ:</FONT><U> <FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial"><A = HREF=3D"http://www.orafaq.com" =
<BR><FONT SIZE=3D2 FACE=3D"Arial">> --</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> Author:</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">> INET: =glen.bernas_at_marchFIRST.com</FONT>
--------------------------------------------------------------------</FO=NT>
<P><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Please see the official ORACLE-L =
FAQ:</FONT><U> <FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial"><A =
HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A></FONT></U>
<BR><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">Author: Paul Drake</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial"> INET: paled_at_home.com</FONT> </P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Fat City Network =
Services -- (858) 538-5051 FAX: (858) =
538-5051</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">San Diego, =
California -- Public Internet =
access / Mailing Lists</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">---------------------------------------------------------=-----------</FONT>
![]() |
![]() |