Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export/import LOB problem
Thanks for your answers.
But how do I solve the problem when I cant import just the rows?
Is there a nother way to dump these 48 rows and get them back in a new table?
Thanks // K
"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:<a7f5vb$6kf$1_at_lust.ihug.co.nz>...
> 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...
> > 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 - 08:08:10 CST