Re: Oracle Import: a general question

I'd of thought it would depend what type of import you did, which is dictated by what type of export you did. If you did a FULL or USER export and USER import, then it will import procedures, triggers, sequences, views etc. as well as the tables. If you just import tables (from a FULL, USER or TABLE export) then you should not changes the other objects (other than tables and indexes). I would certainly check for invalid objects in the latter case, and recompile any you find.

Ho Yat-Fan wrote:

> Hi all,
>
> I found that if I dropped all the tables in a database (Oracle 7 or 8),
> and then do an import (with ignore=y) from a previous export dump,
> all views, procedures and synonyms would remain to be the new ones,
> not those from the export dump.
>
> Any comments/advice on this observation?
>
> Many many thanks.
>
> ps. If possible, please cc: a copy of your reply to fan.ho_at_alumni.ust.hk
>
> Rgds., fan.
> --
> Yat-Fan Ho
> Software Support Analyst
> KCRC, Hong Kong
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

--

/* julian hare:
 *
 * julianh_at_eagles.bbs.net.au
 *
 */