|
-
ok..thanks....TimHall
now I have this problem:
when I write: imp system/manager@mydb frouser=sam touser=TOM file=c:\art.dmp log=c:\art.log
I get this errors:
CREATE SEQUENCE "AFM_ACTIVITY_LOG_S" MINVALUE 1 MAXVALUE 999999999999999999"
"999999999 INCREMENT BY 1 START WITH 1 CACHE 20 ORDER NOCYCLE"
IMP-00015: following statement failed because the object already exists:
. . importing table "AM" 0 rows imported
. . importing table "AMP" 0 rows imported
. . importing table "ACTIVITY" 0 rows imported
. . importing table "ABC" 0 rows imported
. . importing table "ADV 0 rows imported
. . importing table "ATS" 96 rows imported
CREATE FORCE VIEW "AFM_ARSTUD"."GPC" ("GP_ID","FL_ID","
""BL_ID","SITE_ID","FLCOMGP","BLCOMGP","STCOMGP","FLCOMSRV","BLCOMSRV","STCO"
"MSRV") AS "
"SELECT gp.gp_id AS gp_id, fl.fl_id AS fl_id, bl.bl_id AS bl_id, site.site_i"
"d AS site_id, ( gp.area * fl.area_fl_comn_gp / DECODE(fl.area_gp_dp,0,99999"
"99999,fl.area_gp_dp)) AS flcomgp, ( gp.area * bl.area_bl_comn_gp / DECODE(b"
"l.area_gp_dp,0,9999999999,bl.area_gp_dp)) AS blcomgp, NVL( ( gp.area * site"
".area_st_comn_gp / DECODE(site.area_gp_dp,0,9999999999,site.area_gp_dp)),0)"
" AS stcomgp, ( gp.area * fl.area_fl_comn_serv / DECODE(fl.area_gp_dp,0,9999"
"999999,fl.area_gp_dp)) AS flcomsrv, ( gp.area * bl.area_bl_comn_serv / DECO"
"DE(bl.area_gp_dp,0,9999999999,bl.area_gp_dp)) AS blcomsrv, NVL( ( gp.area *"
" site.area_st_comn_serv / DECODE(site.area_gp_dp,0,9999999999,site.area_gp_"
"dp)),0) AS stcomsrv FROM gp, fl, bl, site WHERE gp.dp_id IS NOT NULL AND gp"
".fl_id = fl.fl_id AND gp.bl_id = bl.bl_id AND fl.bl_id = bl.bl_id AND site."
"site_id (+) = bl.site_id"
IMP-00015: following statement failed because the object already exists:
CREATE TRIGGER "AD"."WOAUTONUMBER" BEFORE INSERT ON "AFM"."WO" REFE"
"RENCING OLD AS OLD NEW AS NEW_RECORD FOR EACH ROW "
.................................................................................................... ...IMP-00015: following statement failed because the object already exists:
These error are important? and how can I avoide it?
Must I drop user TOM?
I don't want drop it.
Raf
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|