Re: Saving the config info of the whole oracle on my NT box?

Billy Collins wrote:
>
> Hi,
>
> When I try to use Oracle connect string in my ASP code, I get the
> following error:
>
> ---------------
> Microsoft OLE DB Provider for Oracle error '80004005'
>
> The Oracle(tm) client and networking components were not found. These
> components are supplied by Oracle Corporation and are part of the
> Oracle Version 7.3.3 (or greater) client software installation. You
> will be unable to use this provider until these components have been
> installed.
> ---------------
>
> I read from help.com that one person gets around this by uninstalling
> Oracle (we use 8.1.6.0.0, NT 4) and re-installing it all over again!
>
> QUESTIONS:
>
> 1. Is this necessary? Is there any other solution to it?
>
> 2. If not, and if I do un-install the whole Oracle from my NT box and
> re-install it, how can I minimize the effort required in creating the
> whole databases again?
>
> I have a couple of databases (created with a "TYPICAL" configuration
> from the CD) and they are both on the same listener (Ora81TNSListener,
> the default I think). The info I have modified until now includes
> USERS, and TABLES. ALl else is default.
>
> I presume that there is not too much effort involved because I can re-
> do all this stuff, but I'd really appreciate if someone could tell me
> how I can save (EXPORT) all the info about my Oracle databases now,
> including the databases + users + tables, and then re-import them back
> into the Oracle that I re-install?
>
> PS: Its not difficult to see that I am not what they usually refer to
> as a "DBA" but then we are a "mama and papa" store! :)
>
> Thanks a lot in advance,
> WF
>
> If you can CC me the reply as well, it'll be greatly appreciated!
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

exp userid=system/??? full=y

will dump pretty much everything...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk
(faster/mirrored at http://www.oradba.freeserve.co.uk)

Its not the voices in my head that bother me... 
  its the voices in yours.