[raf]

Hi,
I've a export file (XX.dmp).
I tried to import this dump for new records of tables there are in my db, but I get this errors:

imp system/manager@mydb file=xx.dmp tables=A ignore=y fromuser=tom touser=tom log=xx.log

Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. importing AFM's objects into AFM
IMP-00017: following statement failed with ORACLE error 922:
"CREATE TABLE "SITE" ("ACRES" FLOAT(126), "AREA_EM_DP" FLOAT(126) "NOP" VARCHAR2(4)) PC"
"TFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 4980736 FREELIS"
"TS 1 FREELIST GROUPS 1) TABLESPACE "AFM_P1" LOGGING NOCOMPRESS"
IMP-00003: ORACLE error 922 encountered
ORA-00922: missing or invalid option
IMP-00008: unrecognized statement in the export file:
ýÿo
IMP-00008: unrecognized statement in the export file:
R
IMP-00008: unrecognized statement in the export file:

I think that export file is was corrupted.
How Can I import correctly??

Thanks
Raf

[raf]

My db server is 9.0.1, while export made on oracle server 9.2.0.1
On server 9.2.0.1 not is setting the NLS_LANG
Could be this the problem???

Thanks
Raf

[AlanP]

I think it might be the nocompress/compress option available in 9.2 which might be giving you grief. You might want to remove this text from the dmp file using some utility. Alternatively you might try doing the export from the 9.0.1 machine but it might not work.

The last option is to create a schema script from 9.2 schema, removing the compress/no compress text. Run the schema script on the 9.0.1 machine and then import with ignore=Y option so it will ignore any create table errors.

Alan

[ravipurbia]

Hi there,
I think it is problem with NOT NULL columns constraints, u can disable those constraints and try again. if it still not work then u can use the SHOW=y option to verify your DMP file. The SHOW option will show u what are the object is there in the DMP file and how it is going to import. Just check out it.
Wish u all the best.
Ravi

[osy45]

AFAIK Oracle exp/imp utilities are not downward compatible

try exporting SID 9.0.2 using exp from 9.0.1 utilities' version