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

I think follow the imp/exp command is enough, otherwise you should do some troubleshooting. I did more this kind of work on RedHat (not only7.1) and NT/2000, as well as Solaris, the exp/imp runs well no matter which platform even different version (8i&9i), mostly I worked on my Win2000 machine to manage all servers from Linux to Solaris.

Unfortunately my company shutdown and I got layoff, my last position is DBA in a software development company, I have over 10 years IT experience and focus on database development and administration, currently foucs on Oracle/UDB & JAVA application from NT/2K to Linux and Solaris, please feeling free contact me if you or your friend have any opening on Oracle & DB2/UDB Admin and development. Thanks in advance!

Richard

Oracle8i Certified Professional DBA
IBM DB2 Certified Specialist - V6/7
Sun Certified Programmer for Java2 Platform Email: rxdtian_at_yahoo.com
Tel: 416-498-8801 (Toronto, Canada)

<roland_dunn_at_hotmail.com> wrote in message news:9uiw9.2773$dv6.1448_at_news-binary.blueyonder.co.uk...
> 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.
>
>
> "Indy" <inderpalj_at_hotmail.com> wrote in message
> news:cd4c3152.0210311241.444e6e01_at_posting.google.com...
> > Additional Consideration are to put IGNORE=y clause in imp
> > so
> >
> > imp devintranet/blah file=intranet.dmp fromuser=<owner>
> touser=<targetuser> ignore=y
> >
> > Secondly
> > In order to drop the user
> >
> > Connect to the SQLPLUS as DBA id like
> >
> > connect / as sysdba
> > drop user <username> cascade;
> > drop tablespace <tablespace_name> including contents;
> >
> > In Oracle 9i
> > drop tablespace <tablespace_name> including contents and datafiles;
> > will delete tablespace as well as the datafiles
> >
> > Good Luck
> > Indy
> >
> > "magpies" <-_-> wrote in message
> news:<aprhib$9k11_at_imsp212.netvigator.com>...
> > > 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 Mon Nov 04 2002 - 04:43:26 CET