import fails with ora error 959 :tablespace 'NSPIRES_AT_DATA' does not exist
I am migrating data from 10.2.0.4 to 11.2.0.2. I am using data pump for most of the schema but there are three that hold xml data that I need to do with regular exp/imp.
The export process does not present problems but the import fails with the error: IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'NSPIRES_AT_DATA' does not exist
These are the parameters I am using:
FROMUSER=NSPIRES_AT
TOUSER=NSPIRES_AT
FILE=expall_NSPIRESAT.dmp
LOG=impall_NSPIRESAT.log
RECORDLENGTH=65535
FEEDBACK=1000
CONSTRAINTS=N
INDEXES=N
GRANTS=N
IGNORE=Y
DESTROY=Y
I have done this process several times using the same parameters and had never had this problem. I must be missing something - Help would be most welcomed
0