imp/exp table with LOB
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: imp/exp table with LOB

  1. #1
    Join Date
    Oct 2001
    Posts
    2
    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
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Thanx
    Sam



    Life is a journey, not a destination!


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