Re: Export/Import of a table with BLOB columns

From: Stephen Ferracioli <ferracioli_at_101freeway.com>
Date: Fri, 13 Jun 2003 05:55:27 GMT
Message-ID: <jHdGa.1100$7J.111642769@newssvr13.news.prodigy.com>

"Tuan Dang" <tuan_t_dang_at_yahoo.com> wrote in message news:EUcGa.64277$_w.2723789_at_twister.southeast.rr.com...
> I need to migrate a table from database A to database B with the following
> setup :
>
> Table :
> CREATE TABLE T ( COL1 NUMBER, COL2 BLOB )
>
> database A :
> table T is created in the SYSTEM tablespace
> we do an EXP command to export the table to a file
>
> database B :
> We create a new tablespace TS for the owner of the table.
> We revoke all quotas on SYSTEM tablespace for the table owner
> We create Table T specifying use of TS for the BLOB column
> We run IMP IGNORE=Y
>
> The problem is that IMP insists on recreating table T and using the SYSTEM
> tablespace
> for the BLOB.
>
> Can anyone help us do it such that all the table columns do not use the
> SYSTEM tablespace on database B ?
>
> Thanks ! Tuan
>
>
>

Note 91969.1 on metalink should help. Received on Fri Jun 13 2003 - 00:55:27 CDT