| 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?
sorry I misspoke -- just the SQL statements to recreate the packages are in
the export file, not any sort of data you can import to recreate them --
obviously a full database export contains rows if you haven't exported with
rows=n
>From: "Rachel Carmichael" <carmichr_at_hotmail.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: Wed, 25 Oct 2000 19:20:47 -0800
>
>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.
>>
>>Any help would be highly appreciated.
>>
>>Thanks,
>>Muru
>>
>>
>>
>>__________________________________________________
>>Do You Yahoo!?
>>Yahoo! Messenger - Talk while you surf! It's FREE.
>>http://im.yahoo.com/
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>--
>>Author: Murugesan Balakrishnan
>> INET: mail_oracle_at_yahoo.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).
>
>_________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>Share information about yourself, create your own public profile at
>http://profiles.msn.com.
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
> INET: carmichr_at_hotmail.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).
Share information about yourself, create your own public profile at Received on Thu Oct 26 2000 - 08:49:51 CDT
 |
 |