Import/Export

From: Michael James Seymour <x09mjs_at_morgan.ucs.mun.ca>
Date: 4 Dec 1998 20:08:49 GMT
Message-ID: <749fgh$a1k$1@coranto.ucs.mun.ca>

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:08:49 CST