| 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: Is it possible to import a package alone?
not ignorant at all.... but yes, that's a LOT of work and when you pull the
definitions from the data dictionary tables you have to go through and edit
them (Oracle stores linebreaks where it feels like it, even in the middle of
a line)...
it would work though. I wouldn't want to DO it, bt it would work :)
>From: "Michael Ray" <Michael.Ray_at_trw.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Is it possible to import a package alone?
>Date: Thu, 26 Oct 2000 06:35:37 -0800
>
>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
>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 version of a package.
><< TEXT.htm >>
Share information about yourself, create your own public profile at Received on Thu Oct 26 2000 - 11:48:35 CDT
 |
 |