How to Import (LOB) Large Objects To Another Tbale space and Another User
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to Import (LOB) Large Objects To Another Tbale space and Another User

  1. #1
    Join Date
    Jul 2002
    Posts
    205
    I exported the user U1 whos objects are in tablespace T1.
    Now I import the same to user U2 whose tablespace name is T2.

    All objects are getting imported. But I have one table with field LOB. It is showing error User U2 is not having quota on Tablespace T1.

    Infact I donot want to give quota to user U2 on Tablepsace T1.

    Any solution.

  2. #2

    Wink Import LOB into different tablespace

    I think you have to create the table (with no rows) on the proper tablespace and then import the data with IGNORE=Y

    1. Get the creation script, user INDEXFILE option and set ROWS=N when import.
    2. Run the script to create table
    3. Import with IGNORE=Y option

    Queyon
    Queyon Zeng

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