Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can I restore tablespaces(datafiles) to a new blank database?

Re: Can I restore tablespaces(datafiles) to a new blank database?

From: joel garry <joel-garry_at_home.com>
Date: 20 Jul 2006 15:11:39 -0700
Message-ID: <1153433499.298115.117920@s13g2000cwa.googlegroups.com>

Sybrand Bakker wrote:
> On Wed, 19 Jul 2006 20:00:33 GMT, TG <spam_at_spam.com> wrote:
>
> >If I was able to recover the system tablespace I could have done that,
> >but unfortunatly that was not recoverable. I'll have to see if I can get
> >the dbid from the old datafiles and change the dbid of the new one to
> >match (with fingers crossed)
>
> You can't, at least not using a supported method.

But see Note:227060.1 anyways for a couple of ideas on how to get the dbid. Don't think NID will fix the problem (see Note:224266.1), but good luck.

jg

--
@home.com is bogus.
http://www.signonsandiego.com/uniontrib/20060720/news_1b20prgn.html
Received on Thu Jul 20 2006 - 17:11:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US