export from user to another user

From: <zoux_at_exchange.nih.gov>
Date: Mon, 08 Mar 1999 16:55:25 GMT
Message-ID: <7c0vdm$au1$1@nnrp1.dejanews.com>

Hi,

Does anyone know how to export all data from one user to another user's default tablespace?

I ran the export/import utility. For example:
exp73 userid=dba/dba owner=user1
imp73 userid=dba/dba fromuser=user1 touser=user2

The problem is after running imp73, Oralce does not put imported data into user2's default table space. It just used the same tablespace user1 uses. Is it possible put imported data into user2's default table space?

Thanks.

zou

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 08 1999 - 10:55:25 CST