Re: Copy Database from NT to W2K

"Giuseppe" <giuseppe.didodo_at_bluewin.ch> wrote in message news:df5fda08.0212230209.5407db3b_at_posting.google.com...
> Hi, I have a question and maybe someone can help. We installed Oracle
> 7.3.3 on Windows NT, patched it to 7.3.4, then upgraded and migrated
> it till 8.1.7.4, still under NT. We saved the files, cleaned the
> machine and installed Windows W2K, because an upgrade fo Windows NT to
> W2K always crashed.
>
> After the installation of W2K, we installed Oracle 8.1.7.4. We deleted
> this datafiles and moved the datafiles under it, which we created on
> NT. We can mount the db, but at the open it crashes with ora-01092. I
> tried everything like 'recover... backup controlfiles' or 'recover
> until...', still the same.
>
> I think that basically the files from NT to W2K are not compatible,
> even if they're NTFS, I think something in NTFS changed between NT and
> W2K, but if we would migrate the OS, we wouldn't have a problem.
>
> Can somebody agree to this ?

This is simply NOT true

 or give me a hint ?

Please look in the alert log for further error messages. If you moved files you should have recreated the controlfile, which you most likely didn't. Your BIG BANG scenario was hence doomed to fail.

 We really don't know
> what to do. We didn't want to do export/import to save time, DB is
> 95G.

Most likely tables and indexes and indexes are not exported. I also have the feeling you are describing from memory. You should post the *exact* steps. Currently, there a no clues to work on.

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address