this is not possible in the way you are trying to do it.
a datafile can only belong to one database and therefore cannot be restored
an recovered in another database.
but: you can use export/import with the transport tablespace method if all
conditions are met:

tablespace must be selfcontained, plattform must be the same unless you are
using 10g, ...
please check documentation for details.
HTH
Wolfgang

> -----Ursprüngliche Nachricht-----
> Von: jayeshrshah
> [mailto:oracledba-ezmlmshield-x11163311.[Email address protected]
> Gesendet: Freitag, 30. Dezember 2005 11:15
> An: LazyDBA Discussion
> Betreff: Tablespace Recover
>
> Dear,
>
> I want to restore only one datafile restore one instance to other.
>
> Like i have 2 Instance
> DB 1
> 1. System.dbf
> 2 . User.dbf
> 3 HR.dbf
> 4. finance.dbf
> DB 2
> 1. system.dbf
> 2.user.dbf
>
> Now i want to restore hr.dbf into DB2 database
> Is it possible. bcose i tried and give error
>
> ORA-1203,ora,-01110,ora-01122
>
> ORA-01203 wrong incarnation of this file - wrong creation SCN
> How it is possible.
>
>
>
>
> With warm regards,
>
> Jayesh shah
> 26868272
>
>
>
> "Premnath " <oracledba-ezmlmshield-x15303328.[Email address
> protected]
> 12/30/05 02:51 PM
>
> To
> "LazyDBA Discussion" <[Email address protected]
> cc
>
> Subject
> Re: Tablespace Recover
>
>
>
>
>
>
> set oracle_sid = default database
>
> sqlplus
>
> /as sysdba
>
> startup mount
>
> alter datafile 'HR.DBF offline; -- please check the syntnx
>
> alter database open;
>
> recover datafile 'HR.DBF ;
>
> alter datafine 'HR.DBF online;
>
> Then take a backup of the database. Other Guru's please
> correct me if i am
> wrong
>
> ----- Original Message -----
> From: "jayeshrshah"
> <oracledba-ezmlmshield-x10419480.[Email address protected]
> To: "LazyDBA Discussion" <[Email address protected]
> Sent: Friday, December 30, 2005 2:10 PM
> Subject: Tablespace Recover
>
>
> > Dear All DBAs
> >
> > I need your help .
> > I have 2 instance.
> > One Is default & Other is created by us.
> >
> > In Other instance, i have 2 table space , HR & Other is
> Procurement. I
> > want to restore only HR Tablespace its datafile is 'HR.DBF
> ' in Default
> > instance. How is it possible.?
> >
> > Urgent require help.
> >
> >
> >
> >
> > With warm regards,
> >
> > Jayesh shah
> > 26868272
> >
> >
> > --------
> > website: http://www.LazyDBA.com
> > Please don't reply to RTFM questions
> > Oracle documentation is here: http://tahiti.oracle.com
> > To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> > To subscribe: see http://www.lazydba.com
> > By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
> >
> >
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:
> http://www.lazydba.com/legal.html
>
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>


Oracle LazyDBA home page