Re: Import/export troubles

[Quoted] 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)
> >>
> >>now I create an export file of all these tables (L1 and L2 so)...
> >>
> >>NOW :
> >>now I want to import the tables L1 and L2
> >>I create a new tablespace and a user
> >>tablespace : TBLSPC_TITI
> >>user : titi, default tablespace TBLSPC_TITI
> >>
> >>I do an import tables from user toto to user titi...
> >>BUT the only table created is L1 which has no BLOB or CLOB column (and I
> >>would have the table L2 if it
> >>has not CLOB or BLOB columns)....
> >>For the import of the table L2, I have an 01950 Oracle error telleing me
> >>that I don't have enough privilege on tablespace TBLSPC_TOTO...but I
don't
> >>understand this message...because my table L1 is well created in my
> >>tablespace TBLSPC_TITI...so why do I have this message for L2 ??? why
> >>doesn't it create L2 under TBLSPC_TITI ???....
> >>
> >>I hope you'll understand my problem...
> >>
> >>Thanks very much in advance,
> >>Laurent
> >>
> >>
> >>
> >>
>
Received on Tue Mar 19 2002 - 15:10:42 CET