Re: Import/Export

Hi Mike,
From what I gather from the pl/sql the trigger is calling a packaged procedure

 " ems.misc_io.save_to_wastebasket('COMPANY','D',rec_data) ;" Now procedures and packages are only exported during a full database export. The package is missing and the trigger doesn't compile. I don't know why you are not applying a full database export to your new instance. It should work without problem, I did it several times. If you precreate tablespaces etc this almost can't fail. If you want to proceed the way you are doing now, you should make a full database export anyway. Then with
imp full=y show=y log=<filename>
dump everything to a text file (this will not dump data, and it will dump the pl/sql source code)
edit the log file, get the pl/sql out and apply it manually. Once applied the triggers should compile automatically.

Hth,

Sybrand Bakker, Oracle DBA

Michael James Seymour wrote:

> Thanks to those who helped me out with the maxdatafile thing, i appreciate
> it.
>
> Hopefully you guys can help me out again...
>
> A bit of background:
> I'm moving a database that is currently installed and running on one
> machine to a new machine. The easiest way seemed to install new software
> and move the tablespaces, tables, roles, triggers, etc... individually. I
> have scripts to create the tablespaces and most everyting else.
>
> The problem I am having is on the import for the tables. I exported each
> table individually using the command:
>
> exp <user/password> file=<file_name> tables=<table_name>
>
> Now, when I import I'm using the command:
>
> imp <user/password> ignore=y full=y file=<file_name>
>
> I don't get an error and the table gets imported but there is a warning.
> It appears to be attempting to recreate the triggers in the import -
> here's what I'm getting:
> -------------
> IMP-00041: Warning: object created with compilation warnings
> "CREATE TRIGGER "EMS".del_company"
> "BEFORE DELETE ON ems.company"
> "REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW"
> ""
> ""
> "DECLARE"
> " rec_data wastebasket.rec_data%TYPE ;"
> "BEGIN"
> " rec_data := TO_CHAR(:OLD.fac_co_no) || '//' ||"
> " TO_CHAR(:OLD.fac_nerc_co_no) || '//' ||"
> " :OLD.fac_co_long_nme || '//' ||"
> " :OLD.fac_co_shrt_nme || '//' ||"
> " :OLD.usrid || '//' ||"
> " :OLD.termid || '//' ||"
> " TO_CHAR(:OLD.last_chg_dt,'MM/DD/YYYY HH24:MI:SS') || '//'
> ||"
> " :OLD.fac_it_pjm_ind ;"
> " ems.misc_io.save_to_wastebasket('COMPANY','D',rec_data) ;"
> "END ;"
> Import terminated successfully with warnings.
> ---------------
>
> Is this OK? Or should I run the export again and find someway to not
> include the trigger information?
>
> Thanks a bunch..
>
> Mike.

Received on Fri Dec 04 1998 - 14:53:49 CST