Re: Is it possible to import a package alone?

From: Michael Ray <Michael.Ray_at_trw.com>
Date: Thu, 26 Oct 2000 06:32:19 -0700
Message-Id: <10661.120276@fatcity.com>

--=_643CA8FF.D3B24D58

Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Pardon my ignorance for being a newbie, but if he wanted to go through a = lot of work, why couldn't he restore from a backup to a dummy database, = and then pull the procedure (package) definitions from the data dictionary?= Then splice it all together into a script and recreate it in the prod db.

Michael Ray
Oracle DBA
TRW, Marshall, IL
217-826-3011 x2438

>>> carmichr_at_hotmail.com 10/25/00 10:20PM >>>
Import from an export or import from a backup?

If you have an export file of a full database export taken before you=20 changed the package, you can get it back, but it's not really an = import,=20
because just the SQL statements to recreate the database are in the = export=20
file. So you could do an import with rows=3Dn show=3Dy log=3D<somefile> = and then=20
edit the log file to get the script and then run it to recreate the = package.

If it's from a backup -- not that I know of, sorry

>From: Murugesan Balakrishnan <mail_oracle_at_yahoo.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Is it possible to import a package alone?
>Date: Wed, 25 Oct 2000 16:16:01 -0800
>
>Hello Lists,
>
>I am using Oracle 8.1.5. Is it possible to import a
>package alone? How? I just want to rollback to a
>previous version of a package.

--=_643CA8FF.D3B24D58
Content-Type: text/plain
Content-Disposition: attachment; filename="TEXT.htm"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.2919.6307" name=GENERATOR></HEAD>
<BODY style="FONT: 8pt MS Sans Serif; MARGIN-LEFT: 2px; MARGIN-TOP: 2px">
<DIV><FONT size=1>Pardon my ignorance for being a newbie, but if he wanted to go

through a lot of work, why couldn't he restore from a backup to a dummy database, and then pull the procedure (package) definitions from the data dictionary? Then splice it all together into a script and recreate it in the prod db.</DIV>
<DIV> </DIV>
<DIV>Michael Ray Oracle DBA TRW, Marshall, IL 217-826-3011 x2438 >>> carmichr_at_hotmail.com 10/25/00 10:20PM >>> Import from an export or import from a backup? If you have an export file of a full database export taken before you changed the package, you can get  it back, but it's not really an import, because just the SQL statements to recreate the database are in the export file. So you could do an import with rows=n show=y log=<somefile>  and then edit the log file to get the script and then run it to recreate the package. If it's from a backup -- not that I know of, sorry >From: Murugesan Balakrishnan <mail_oracle_at_yahoo.com> >Reply-To: ORACLE-L_at_fatcity.com >To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com> >Subject: Is it possible to import a package alone? >Date: Wed, 25 Oct 2000 16:16:01 -0800 > >Hello Lists, > >I am using Oracle 8.1.5. Is it possible to import a >package alone? How? I just want to rollback to a >previous Received on Thu Oct 26 2000 - 08:32:19 CDT