Re: Import/export troubles

um, what's wrong with the 2 solutions already given?

In article <a77glm$r3t$1_at_reader1.imaginet.fr>, laurent.boutet1 _at_libertysurf.fr says...
> well well well...very embarrassing problem...et solutions....
> Is there really any other way to do that ???
>
> "Slawomir Cichy" <SlawasC_at_netscape.net> a écrit dans le message de news:
> 3C9736D2.4040506_at_netscape.net...
> > Other method is:
> >
> > If You have not a mind create tablespace TBLSPC_TOTO (for instance, You
> > don't have space on device). Before import You create table with the BLOB
> > in new tablespace. Make import with option IGNORE=Y
> >
> >
> > tojo wrote:
> >
> > > The table L2 will be imported into TBLSPC_TITI, as you expect, but the
> > > BLOB column is looking for it's original tablespace TBLSPC_TOTO, which
> > > doesn't exist. You can either grant unlimited tablespace on SYSTEM to
> > > user TITI temporarily, or create a tablespace TBLSPC_TOTO for the BLOBs.
> > > After the import you can ALTER TABLE L2 and move the BLOB's storage to
> > > TBLSPC_TITI (see the lob storage clause in the docs), then drop
> > > TBLSPC_TOTO. I'd consider storing the BLOBs in their own tablespace,
> > > however.
> > >
> > > -- tojo
> > >
> > > In article <a76vfp$lib$1_at_reader1.imaginet.fr>, laurent.boutet1
> > > _at_libertysurf.fr says...
> > >
> > >>Hi !
> > >>
> > >>I've got troubles using Import/Export utilities
> > >>I'm connected as SYSTEM
> > >>I decided to create an export file in order to import it elsewhere...
> > >>So I decided to export tables.
> > >>
> > >>Then I created a new tablespace and assigned it a new user with no
> > >>particulars rights...
> > >>And I import the export file...
> > >>So, the import runs...BUT, I can't import tables containing BLOB or CLOB
> > >>columns !!
> > >>Why ??? I don't understand...
> > >>I don't know if you understand my problem...let me show you a sample :
> > >>
> > >>INITIALLY :
> > >>tablespace : TBLSPC_TOTO
> > >>user : toto , default tablespace TBLSPC_TOTO
> > >>tables :
> > >> toto.L1 (with no BLOB or CLOB columns)
> > >> toto.L2(with a BLOB column for instance)
> > >>
Received on Tue Mar 19 2002 - 15:57:58 CET