IMPORTING LOB TABLES INTO DIFFERENT TABLESPACE

Hi,
I'm having problems Importing tables that have lob columns to a newly created user whose default tablespace is different from the user for which the export was done. any suggestions????i'm using oracle 805 on winnt.

thanks in advance

Hi,

I take it you've tried the from user/to user import parameters?

Moff

Yes, i'm using fromuser touser keywords. I noticed from the log that all tables without lob type columns have been imported succesfully.

thanks

try using the max buffer size allowable on the oracle database. That might click...

Thanks for the suggestions people but i'm still not having much luck. I noticed that the only tables without lob types are being imported and for the lob type tables the error i'm getting is i have no privilageson tablespace where the export was created from.

thanks

which version U R use? I have the same problem. I did some research before unfortunately I lost all my notes. Here is what I remember:

It is a unknown bug for 8.0.6 prior (8.0.6 fixed this bug) - import load LOB into default tablespace rather than predefined LOB tablespace.

if you can find the entry/notes # on Metalink please let me know. I need to keep in my note file. thanks

Jim

Jim, i'm using Oracle 8.0.5

you are out of luck. I used 8.0.4 and 8.0.5 neither work until 8.0.6.

thanks Jim

Jim, I've tried this on 8.0.6 and still no joy

All I can recall is I used 8.0.6 do export from 8.0.4 DB then import to 8.0.6 DB.

have you checked out the tablespace sizing. hope you created the new user with similar settings to the one from which export took place