import/export

From: stef <stef_pellegrino_at_hotmail.com>
Date: Sat, 17 Aug 2002 00:46:02 +0200
Message-ID: <ajjvba$pk$1@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 - 17:46:02 CDT