Re: Laymen question on Oracle import

The old package would be restored. As far as I have seen they are dumped with create or replace.
Ignore=Y mainly applies to objects which don't have the option of being replaced, like tablespaces, tables etc. If you want to keep the modifications dump it to a text file by select text from user_source where name = '<name> order by line. set heading off pagesize in sqlplus before you do this, or have a tool like Toad this do for you.

Hth,
Sybrand Bakker, Oracle DBA

Yat-Fan wrote in message <7kio6o$hl8_at_ustsu10.ust.hk>...
>Hi all,
>
>I would like to ask if I created an Oracle package, export full database,
>modify the package, drop all the tables and then import full database, am I
>right that the old package would be restored?? Or it depends on whether we
>set "ignore = y" when we import??
>
>Thanks.
>
>Rgds., fan.
>ps. If possible, please also cc: a copy of your reply to me at
>fan.ho_at_alumni.ust.hk
>
>
Received on Sun Jun 20 1999 - 08:34:09 CDT