Database Utilities (MOSC)

MOSC Banner

import fails with ora error 959 :tablespace 'NSPIRES_AT_DATA' does not exist

edited Aug 22, 2011 11:03AM in Database Utilities (MOSC) 15 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center