imp/exp table with LOB

[jibits]

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?

[sambavan]

http://oradoc.photo.net/ora816/serve...ch01.htm#25626


sam

[jibits]

hello sambavan,

i have already had a look at that piece of documentation and i could not get a solution from it. how can i export and then import a table with a LOB if the tablespaces are different in the source and destination.?