Errors during import execution

[mancub]

I executed the statement below to do an export and it terminated without errors.

exp username/password tables=(employees,countries) file=c:\export\home\okmaps1\expdat.dmp log=c:\export\home\okmaps1\imp.log

Then i tried to import these two tables into another schema.
using the following command

imp username/password tables=(employees,countries) file=c:\export\home\okmaps1\expdata.dmp log=c:\export\home\okmaps1\imp.log

The results are below. When i check the import, the tables are where they are supposed to be with data in them. My questions is why do the statements listed below during the import fail. Thanks all you guru out there

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
. importing ETHAN's objects into JESSELYN
. . importing table "EMPLOYEES" 107 rows imported
. . importing table "COUNTRIES" 25 rows imported
IMP-00017: following statement failed with ORACLE error 942:
"ALTER TABLE "EMPLOYEES" ADD CONSTRAINT "EMP_DEPT_FK" FOREIGN KEY ("DEPARTME"
"NT_ID") REFERENCES "DEPARTMENTS" ("DEPARTMENT_ID") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00017: following statement failed with ORACLE error 942:
"ALTER TABLE "EMPLOYEES" ADD CONSTRAINT "EMP_JOB_FK" FOREIGN KEY ("JOB_ID") "
"REFERENCES "JOBS" ("JOB_ID") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00017: following statement failed with ORACLE error 942:
"ALTER TABLE "COUNTRIES" ADD CONSTRAINT "COUNTR_REG_FK" FOREIGN KEY ("REGION"
"_ID") REFERENCES "REGIONS" ("REGION_ID") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
About to enable constraints...
IMP-00017: following statement failed with ORACLE error 2430:
"ALTER TABLE "EMPLOYEES" ENABLE CONSTRAINT "EMP_DEPT_FK""
IMP-00017: following statement failed with ORACLE error 2430:
"ALTER TABLE "EMPLOYEES" ENABLE CONSTRAINT "EMP_JOB_FK""
IMP-00017: following statement failed with ORACLE error 2430:
"ALTER TABLE "COUNTRIES" ENABLE CONSTRAINT "COUNTR_REG_FK""
Import terminated successfully with warnings.

 

[SantaMufasa]

Can you confirm that tables named "DEPARTMENTS", "JOBS", and "REGIONS" exist prior to the import? You are attempting to enable foreign key referential-integrity constraints that point to those tables, but Oracle cannot find them in "JESSELYN's" user/schema.

Let us know your findings.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[mancub]

That makes sense. I just wanted the two tables(employees,countries), the other three do not exist is Jesselyn's schema. What do i need to do prevent the error messages if i already know that i wont need the other three tables thus won't need to enable any constraints?

 

[SantaMufasa]

Mancub,

There are multiple methods that you could use to achieve your desired results, but the easiest way (it seems to me) is to:

1) re-do your export, changing the your parameter to read:

...tables=(employees,countries[b],DEPARTMENTS,JOBS,REGIONS[/b])...

It seems to me that these would be very small tables and would not be a burden to export or import.

2) modify the import to also reference the added tables.

Let us know your thoughts.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]