Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Saving the config info of the whole oracle on my NT box?
Hi,
When I try to use Oracle connect string in my ASP code, I get the following error:
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:
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 redo 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.
Received on Tue Oct 10 2000 - 22:20:47 CDT