Import Tables with blob variables into different tablespaces

From: George Leontiadis <gleon_at_dblab.ece.ntua.gr>
Date: Thu, 07 Nov 2002 14:41:49 +0200
Message-ID: <aqdn0u$5po$1@nic.grnet.gr>

I 've taken an export of User1/User1_at_db1 database using a Tb1 tablespace

I 've done an import from user1 to user2 at db2 using a tb2 tablespace

so far no problem but after closer examination the tables with blob variables did not have been imported. for these tables i get an error that the tb1 tablespace does not exist

I've read an older posting here simmilar to this but so far nothing helped

any ideas

(all the other tables,constrains,triggers,sequences are OK )

Thanks Received on Thu Nov 07 2002 - 06:41:49 CST