Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: import/export
Try this:
revoke unlimited tablespace from user_tbl2; -- Just to be sure alter user user_tbl2 quota unlimited on tbl2; alter user user_tbl2 quota 0 on tbl1;
Now do the import ....
This thing happened because the create table statements in the export dmp
contained:
create table ...... tablespace tbl1;
Thus it tried to create the same table in tbl1 tablespace .. for user_tbl2 during the import.
Anurag
"stef" <stef_pellegrino_at_hotmail.com> wrote in message news:ajjvba$pk$1_at_wanadoo.fr...
> Hello guys....
>
> Just a little question about import/export :
>
>
> On Oracle 8.x, I have a tablespaces "tbl1" (waw)
>
> This "tbl1" is about 2 go size (half is free).
> right...
> Now I do an "exp user_tbl1/user_tbl1 compress=n file=dump_tbl1"
> user_tbl1 is owner of tbl1 of course :)
> everything's fine...
>
> I create into the same database a new tablespace - tbl2- (same size as tbl1)
> I create also the "user_tbl2" owner of "tbl2" tablespace.
>
> now, i do :
> "imp user_tbl2/user_tbl2 file=dump_tbl1 fromuser=user_tbl1
> touser=user_tbl2"
>
> It computes a while... and suddenly I get the "so-called" message ORA-1658
> Don't panic, I've seen this before, tablespace is too small
>
> But surprise, the message is for the tablespace tbl1 !!!!???
> why, ??? I don't understand,
>
> Now I panic :)
>
> Ok, if I add some free space to tbl1, now everything will work fine !?
> the tbl2 datas are correctly imported and the tbl1 stills ok !!!!!
>
> why Oracle run this message for tbl1 and not for tbl2 !???
>
> could u give me more informations ?
>
> thanx guys
>
>
Received on Fri Aug 16 2002 - 19:09:06 CDT