Exporting Triggers

From: <cxy2002um_at_gmail.com>
Date: 9 Feb 2005 09:32:05 -0800
Message-ID: <1107970325.746738.321950@z14g2000cwz.googlegroups.com>

Howdy...

I have created a dump file from my one of my databases were all the triggers are valid and working.

My question is when I do a full export of this database. I have two triggers that supplying incorrect DDL.

R_P.tr_distinct_blocks
This trigger is supposed to be on the DISTINCT_BLOCKS table however if you look at the export below it is on the DISTINCT_BLOCKS_NEW table.

R_P.tr_distinct_runs and the same with the DISTINCT_RUNS table vs DISTINCT_RUNS_NEW tables

Anyone have any idea why the export is creating these triggers on the incorrec table name?

Thanks......

Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production

IMP-00002: failed to open EXPDAT.DMP for read Export file created by EXPORT:V09.02.00 via conventional path import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

[..... Stuff Deleted .....]
"CREATE SEQUENCE "DISTINCT_BLOCKS_SEQ" MINVALUE 1 MAXVALUE

99999999999999999"

"9999999999 INCREMENT BY 1 START WITH 105040 NOCACHE NOORDER NOCYCLE"
"CREATE SEQUENCE "DISTINCT_RUNS_SEQ" MINVALUE 1 MAXVALUE

9999999999999999999"

"99999999 INCREMENT BY 1 START WITH 136765 NOCACHE NOORDER NOCYCLE"
[..... Stuff Deleted .....]

"CREATE TABLE "DISTINCT_BLOCKS" ("ID" NUMBER(11, 0) NOT NULL ENABLE,
"BLOCK_"
"NUMBER" NUMBER(11, 0), "BLOCK_KEY" VARCHAR2(51), "TRIPS" NUMBER(11,
0), "MI"
"N_TIME" DATE, "SCHEDULE_NAME" VARCHAR2(50), "MAX_TIME" DATE,
"GARAGE_NAME" "
"VARCHAR2(50)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIA"
"L 65536 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "R_P" LOGGING "
"NOCOMPRESS"

. . skipping table "DISTINCT_BLOCKS"

"CREATE UNIQUE INDEX "PK_DISTINCT_BLOCKS" ON "DISTINCT_BLOCKS" ("ID" )
 PCTF"
"REE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1
FREELIST G"
"ROUPS 1) TABLESPACE "RIDECHECK_INDX" LOGGING"
"ALTER TABLE "DISTINCT_BLOCKS" ADD CONSTRAINT "PK_ID" PRIMARY KEY
("ID") US"
"ING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536
FREELIST"
"S 1 FREELIST GROUPS 1) TABLESPACE "RIDECHECK_INDX" LOGGING ENABLE "
"CREATE TABLE "DISTINCT_RUNS" ("ID" NUMBER(11, 0) NOT NULL ENABLE,
"RUN_NUMB"
"ER" NUMBER(11, 0), "RUN_KEY" VARCHAR2(50), "TRIPS" NUMBER(11, 0),
"MIN_TIME"
"" DATE, "SCHEDULE_NAME" VARCHAR2(50), "MAX_TIME" DATE, "GARAGE_NAME"
VARCHA"
"R2(50)) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 6553"
"6 FREELISTS 1 FREELIST GROUPS 1) TABLESPACE "R_P" LOGGING NOCOMP"
"RESS"

. . skipping table "DISTINCT_RUNS"

[...... Stuff Deleted ....]
"CREATE TRIGGER "R_P".tr_distinct_blocks"
" BEFORE"
" INSERT"
" ON distinct_blocks_new"
"REFERENCING NEW AS NEW OLD AS OLD"
" FOR EACH ROW"
"DECLARE"
" v_new_id number;"
"BEGIN "
" SELECT R_P.distinct_blocks_seq.nextval"
" INTO v_new_id"
" FROM dual;"
" :new.id:=v_new_id;"
" END;"
"ALTER TRIGGER "TR_DISTINCT_BLOCKS" ENABLE"
"CREATE TRIGGER "R_P".tr_distinct_runs"
" BEFORE"
" INSERT"
" ON distinct_runs_new"
"REFERENCING NEW AS NEW OLD AS OLD"
" FOR EACH ROW"
"DECLARE"
" v_new_id number;"
"BEGIN "
" SELECT R_P.distinct_runs_seq.nextval"
" INTO v_new_id"
" FROM dual;"
" :new.id:=v_new_id;"
" END;"
"ALTER TRIGGER "TR_DISTINCT_RUNS" ENABLE"
[..... Stuff Deleted ....]
Import terminated successfully with warnings. Received on Wed Feb 09 2005 - 11:32:05 CST