|
This is a known issue when trying to import a table
that contains LOB segments, which are stored out of
line of the table. The out of line LOB segments will
be imported into the original tablespace. If that
tablespace is not found, then the ORA-959 error is
raised. This should be fixed by Oracle Corp. in the
future, but there is no known fix date or fix version
at this time.
To get around this issue, you have one of two
solutions. One, create tablespace 'XXX' and perform
the import. When done, move the segments to the
appropriate new tablespace and drop tablespace 'XXX'.
Two, run import with SHOW=Y and LOG=some_log_file.
This will spool out any DDL statements in the import
file. You now have the DDL statements required to
precreate your tables and LOB segments. Modify this
file to create these segments in the appropriate
tablespace. Then, run the import again with IGNORE=Y
to import the data.
For More Information
|
