Re: Importing a .dmp into a different tablespace (RH7.1, Oracle 81610)

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 01 Nov 2002 06:44:10 +0100
Message-ID: <v154su4682gtf274s6v202vi6t076fa34f_at_4ax.com>

On Thu, 31 Oct 2002 22:57:45 -0000, <roland_dunn_at_hotmail.com> wrote:

>I'm sure I've tried the "imp devintranet/blah file=intranet.dmp
>fromuser=<owner> touser=<targetuser> ignore=y" myself and found it not to
>work .... just keeps trying to import it into the original tablespace - in
>this case "fred".
>
>Roland.

You need to make sure
- the target user doesn't have unlimited tablespace privilege - has quota on the new tablespace only (alter user quota 0 on <old tablespace> quota unlimited on <new tablespace>) - has that tablespace as it's default tablespace.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Nov 01 2002 - 06:44:10 CET

This message: [ Message body ]
Previous message: RCM: "How can I copy all values from Table to array?"
Maybe in reply to: Fred Pierce: "Re: Importing a .dmp into a different tablespace (RH7.1, Oracle 81610)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message