I'm reading this as you had Orace 7 installed, and have performed a new
installation of Oracle 8 into a different oracle home. Is this correct? If
so can you remove Oracle7 or is it still required? Removing it will simplify
your life consiiderably. Which version of Oracle was used to create the
export file 7 or 8? This affects how you would go about the import.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Ziad Noueihed" <ziad123_at_hotmail.com> wrote in message
news:38e10853.0_at_news.kivex.com...
> The compatible parameter is set to compatible = 7.3.0.0.0
> BTW, I noticed that when running the import, it is using imp73.exe,
instead
> of imp80.exe (I installed Oracle 8). Why is that? How can I make it use
> imp80.exe instead.
> About the original problem, I tried the import from a DOS prompt using
> imp80.exe with a bunch of parameters. I got the following errors:
> IMP-00003 and
> ORA-00942 (table or view does not exist).
> Following Oracle documentation, I ran CATALOG.SQL, but my machine crashed.
> So at this point, I don't know what is happening.
>
> General question: I noticed in my task manager that ORACLE73.EXE instead
of
> ORACLE80. Although I upgraded, it is still using oracle73. How can I make
it
> use oracle80 instead?
>
> Thanks,
>
> Ziad
>
>
> Jerry Gitomer <jgitomer_at_erols.com> wrote in message
> news:38E043AC.7AEE5157_at_erols.com...
> > Ziad Noueihed wrote:
> > >
> > > Platform: Windows NT 4
> > >
> > > I am trying to import a .DMP file, but after I go through the wizard
and
> > > click finish, nothing happens: No errors, but no log file either (it
> creates
> > > it, but stays empty).
> > > Note that I have successfully imported the same DMP file in another
> server.
> > > I tried to match the settings on the server taht did import, tried to
> play
> > > with privileges and tablespaces, but to no avail.
> > > What could be causing this?
> > >
> > > Thank you very much for your help,
> > >
> > > Ziad
> >
> >
> > Did you check the compatibility parameter in your init.ora file?
> >
> > --
> > Jerry Gitomer
> > Once I learned how to spell DBA, I became one
>
>
Received on Wed Mar 29 2000 - 02:08:06 CST
