-
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
riz
-
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
riz
-
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
riz
-
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
riz
-
you are out of luck. I used 8.0.4 and 8.0.5 neither work until 8.0.6.
-
-
Jim, I've tried this on 8.0.6 and still no joy
riz
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
|