Re: Import to a different tablespace

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 28 Jan 2002 19:10:38 +0100
Message-ID: <ku4b5u444754r2lvc3d5ae8jiqhnel6krj@4ax.com>

On Mon, 28 Jan 2002 18:00:33 -0000, "Jon Anthony" <jon.anthony_at_caspiansoftware.com> wrote:

>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.
>

please search the newsgroup archives (and please always try to do this before posting), as this question is being asked often and answered often, last time last week by me.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Jan 28 2002 - 12:10:38 CST