DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2001
    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?

  2. #2
    Join Date
    Oct 2000
    Saskatoon, SK, Canada

    Life is a journey, not a destination!

  3. #3
    Join Date
    Oct 2001
    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.?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.