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

I think you can try:
1. Create (or Alter) a user with default tablespace, say 'data_ts1' 2. run 'imp' using 'fromuser, touser' option, e.g.

     imp devintranet/blah file=intranet.dmp fromuser=<owner> touser=<target user>

I think it may work.

"michela rossi" <michela_rossi66_at_hotmail.com> wrote in message news:1ed550fd.0210310703.7b01d4c4_at_posting.google.com...
> >> I have a .dmp file, say, fred.dmp - produced from a tablespace
> called fred, with user fred. I wish to create a new tablespace and
> user and import fred.dmp into that tablespace. I've read round various
> newsgroups and it does seem that there is a bit of an issue making
> Oracle import into a different tablespace from its' source.
>
> >> I am attempting to do this on RedHat 7.1 and Oracle 8.1.6.1.0.
 

> >> So, I have fred.dmp in /tmp/fred.dmp
 

> >> I create a new table space and user using the following commands:
>
> svrmgrl
> connect internal;
> create tablespace devintranet datafile
> '/ora8/m02/oradata/ora8/devintranet01.dbf' size 50m autoextend on
> default storage (pctincrease 1);
> create user devintranet identified by blah default tablespace
> devintranet temporary tablespace temp quota unlimited on devintranet;
> grant connect, resource, ctxapp, javasyspriv, query rewrite to
> devintranet;
> revoke unlimited tablespace from devintranet;
> alter user devintranet quota unlimited on devintranet;
> exit;
>
> >> Next, I try to import fred.dmp into devintranet:
>
> imp devintranet/blah file=intranet.dmp
>
> But - this doesn't work - does anyone know what I should do to force
> Oracle to do this import?
>
> Also: supposing I've reached the pt where I've finished experimenting
> with devintranet - what commands should I use to completely remove
> both the user and the tablespace, so that I can safely remove any
> resulting .dbf file that has been created?
>
> Any help would be most most welcome,
> Thanks, Michela.
Received on Thu Oct 31 2002 - 16:17:47 CET