Re: Import/export troubles
From: Slawomir Cichy <SlawasC_at_netscape.net>
Date: Tue, 19 Mar 2002 14:02:10 +0100
Message-ID: <3C9736D2.4040506_at_netscape.net>
>>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 - 14:02:10 CET
Date: Tue, 19 Mar 2002 14:02:10 +0100
Message-ID: <3C9736D2.4040506_at_netscape.net>
[Quoted] 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 - 14:02:10 CET