Import to a different tablespace

From: Jon Anthony <jon.anthony_at_caspiansoftware.com>
Date: Mon, 28 Jan 2002 18:00:33 -0000
Message-ID: <1012240659.22772.0.nnrp-07.9e98708d@news.demon.co.uk>

Hi,

I have two users who have two different default tablespaces. I export some tables from user1 and import using imp newuser/pasword_at_db FROMUSER=olduser TOUSER=newuser.

Both tables end up in the old user's tablespace. I want the imported tables to be in the new tablespace.

I can not use copy or "create table as" because there is LONG data so I am forced to use Export/Import.

Any advice - to be appreciated. Received on Mon Jan 28 2002 - 12:00:33 CST