lob import coping issues

I got a oracle system which the writer of the app which uses Oracle put some LOB's
in the system tablespace of the old system.

I am trying to move to a new system (8.1.5 sol). The export of the old system
seemed to work. I created a user u1 with a default tablespace sb1. The user u1
does not have dba privs like the user on the old system. All the tables are created in
sb1 except the tables which have LOBs. I get a error message 1950 no privs on
system. The create of the LOB define system as the tablespace to use.

Any way around this?

And how do I copy one LOB to another if it winds up that the best way is to do a
database link?

thanks
Pete Received on Sat Apr 15 2000 - 00:00:00 CDT