[gomcar]

hi all. !!
I have a dmp without errors and I send it to other person and He have errors during the import proccess like missed packages
can be the cause a different character set? or diferent version of export utility?

This is my character set
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set

and this is the character set of the other db.
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set.

can this be the problem??

Thanks...

[Littlefoot]

And database versions, along with used export and import versions were ...?

[gomcar]

sorry,
my db is Oracle 9.2.0.7.0
and the other is Oracle 9.2.0.1.0

[pablolee]

Any chance you could post the errors too (might be relevant)

[flyboy]

along with used export and import versions

Let me suppose, those versions are the same as the database versions.
Then, in general, you cannot import dmp file created with HIGHER version of EXP than the IMP version (it may work sometimes, but I would not depend on this).
Not sure about importing with higher version of IMP than the DB version, but I would not try it.
I would rather export with lower version of EXP (in your case 9.2.0.1. at least).

[gomcar]

I suppose the same...
i export with a less version of export or import with higer version.

-Error(24,44): PLS-00201: identifier 'SUBSTRING' must be declared (en ap_rev_w_arbol_dependencias)

-Error(78,84): PL/SQL: ORA-00904: "DATEDIFF": invalid identifier (en ap_rev_w_cant_obj_detalle)

-Error(356,7): PLS-00201: identifier 'EXEC_SQL' must be declared (en AP_REV_W_COMPARACION)

-Error(1211,27): PL/SQL: ORA-00904: "UCASE": invalid identifier (en ap_rev_w_cons_lista_ed)

SUBSTRING,DATEDIFF,EXEC_SQL and UCASE are functions of a schema included in the export.