oracle959错误,IMP-00017,IMP-00003,ORA-959

Hello,

After a successful export of a schema, I got a warning while doing an import of the schema I had just exported.

I checked the log and saw the following errors:

IMP-00017 : following statement failed with ORACLE error 959:

"CREATE TABLE "M4DMS_ORA_DOC_CO1" ("ID_DOC" NUMBER(8, 0), "ID_DOC_VERSION" N"

"UMBER(2, 0), "DOC_CONTENT" BLOB, "ISO_LANGUAGE" VARCHAR2(3), "DOC_FORMAT_TY"

"PE" VARCHAR2(10), "ID_CHAR_SET" VARCHAR2(20)) PCTFREE 1 PCTUSED 40 INITRAN"

"S 1 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER"

"_POOL DEFAULT) TABLESPACE "M4PRO" LOGGING NOCOMPRESS LOB ("DOC_CONTENT") ST"

"ORE AS (TABLESPACE "M4PRO" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10 "

"NOCACHE LOGGING STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1 BUFFER"

"_POOL DEFAULT))"

IMP-00003: Erreur ORACLE 959 rencontrée

ORA-00959: Tablespace 'M4PRO' does not exitTo make sure the 'guilty' tablespace does indeed exist, I ran the following as sysdba:SQL> conn /@m4client as sysdba

ConnectÚ.

SQL> select tablespace_name from dba_tablespaces where tablespace_name like 'M%'

;and the result is as follows:

TABLESPACE_NAME

------------------------------

META4

M4PRO

SQL> Which means that the tablespace M4PRO does exit.

Why do I have that error and how can I fix it?

I am using oracle 10gR2 on both machine (The one I did the export from and the one I am trying to import into)

Thanks in advance.