Re: ORA-01159 Wrong Database ID

There may be, but I doubt it...the header contains info that is related to other files ( particularly the Sys ones) and, if they are not the same, the database will not open..Perhaps someone will have a hack that can do this...

"Appie at InfoPAct" <avlenten_at_flakkee.net> wrote:

>Hi,
>
>I'm really stuck with a big problem.
>From an early database I only have three datafiles left. (a complete
>tablespace)
>All the other files, Sys1...., Usr1....., Rbs1..., Tmp1...., the
>controlfiles and logfiles are gone.
>No backups or dumps are available. (as always, of cource)
>
>What I tried to do, to get the important data out of the datafiles is
>creating a new database,
>exactly the some as the lost one.
>While creating the controlfile I get the message ORA-01159, the datafiles
>have a
>WRONG DATABASE ID. (The gave the new database the same DATABASENAME)
>
>Is there a way to put these files into a new database, or is there somewhere
>a tool
>available to edit the header of the datafiles so my database will recognize
>them?
>
>Or perhaps someone has a better idea to get the data from the datafiles?
>
>Thanks,
>Ab
>
>
>
>
>

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Tue Dec 28 1999 - 14:59:34 CST