-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|