Re: Export/import LOB problem

From: Hans de Ruiter <hans.ruiter-de_at_siemens.nl>
Date: Fri, 22 Mar 2002 11:43:41 +0100
Message-ID: <a7f1st$rh@thor.siemens.nl>

Importing just the rows is not possible. Make sure that you use ROWS=Y at export and import. Before doing the import create the table, and import the data. Import will generate an error saying the table already exists and starts importing the data.

Regards
Hans

"Katarina Amender" <katta.klos_at_home.se> wrote in message news:df2d2fc9.0203220206.71db80a_at_posting.google.com...
> Hi everyone.
>
> I have (for me) a big problem. The extents on my table containing
> blobs has reached maximum. I tried to increase the number of extents
> but it does not solve the problem, it is still there although my OEM
> says the new value.
> I exported the table with these 48 rows, droped the table and
> recreated it with MAXEXTENTS UNLIMITED. When I try to import I cant
> get the rows! I get the structure of the table which I do not want.
> How do I manage this problem, e.g importing just the rows?
>
>
> Thanks // K
Received on Fri Mar 22 2002 - 04:43:41 CST