i am using oracle 8.1.6 on sun solaris.

i am trying to export and then import a table with LOB column. the default tablespaces of the source and the destination user are not the same and hence i get the "ora-959" error - tablespace does not exist - error when i run the import command.

i also tried pre-creating the same table in the destination users default tablespace by using the indexfile created by "imp" (as was suggested in some user discussions). but i still get the same error.

am i missing something here?

how can i export and then import this table without actually having to transfer the tablespace too?