Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Importing a .dmp into a different tablespace (RH7.1, Oracle 81610)
>> 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 - 09:03:00 CST