Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export/import LOB problem
Only if you also remember to set ignore=y when you run import. Otherwise,
it simply detects the fact that the table already exists and bombs out.
Regards
HJR
-- ---------------------------------------------- Resources for Oracle: http://www.hjrdba.com =============================== "Hans de Ruiter" <hans.ruiter-de_at_siemens.nl> wrote in message news:a7f1st$rh_at_thor.siemens.nl...Received on Fri Mar 22 2002 - 05:52:18 CST
> 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
>
>
>
>