Re: Correct OCI Version

2002-01-12 Thread Jared Still
Can't you just right click on the dll and choose 'properties' to get the info? Jared On Saturday 12 January 2002 03:35, [EMAIL PROTECTED] wrote: > hi to all! > > it's ages now that i'm looking for a > good method for determining the exact > oci version installed and/or used and > i'm still look

RE: RMAN

2002-01-12 Thread Kevin Fries
I believe not. Part of the reason is that the control files are used to store some of the information for RMAN. The formats of 7.* and 8.* are not compatible in that there's 17 added sections in the O8 controlfile. You've probably noticed the increased size between 7.* and 8.*. Velpuri covers quit

Re: RMAN

2002-01-12 Thread orantdba
Unfortunately NO. John [EMAIL PROTECTED] wrote: >Can RMAN be used to backup a V7.3.4.5 instance? >In addition to the obsolete version, which I'm forced to continue >to support, I'm supporting both 8i & 9i instances. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

parallel_server parallel_min_servers

2002-01-12 Thread shuli
Dear listers, Could someone shed some light on the following question? I can not figure out by myself because I am really a new bee on this:) In my application, I need to query a IOT that is not partitioned.I was getting bad performance. It is running on Sun E3000 with oracle 8.1.5 a

RMAN

2002-01-12 Thread Charlie Mengler
Can RMAN be used to backup a V7.3.4.5 instance? In addition to the obsolete version, which I'm forced to continue to support, I'm supporting both 8i & 9i instances. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Netwo

Re: Centralized Alert Log Monitoring

2002-01-12 Thread cjgait
While the script approach is excellent, and you have gotten several good answers on how to use it, might I suggest looking into event triggers? If you are running 8i or above (not 8.1.5, it's buggy on this), you can create a database level trigger ON ERROR. If you have Java turned on for your

Re: Data warehousing Resources

2002-01-12 Thread Oliver Artelt
Hi, try http://www.stewartmc.com/oracle http://www.dwinfocenter.org/ oli On Sat, 2002-01-12 at 06:27, [EMAIL PROTECTED] wrote: > Dear All, > > Would greatly appreciate any advice on books/resources on designing and > implementing data warehouse (on Oracle 7-8i) from a less technical and more

Re: Installation Problems

2002-01-12 Thread Joe Testa
good luck with it, and be ready to reinstall windows if it all goes to heck. joe JoJo Al-Zawawi wrote: > Thanks a lot, Joe. Since I backed up my registry before I installed Oracle, > I can probably just import the backed-up registry and save myself some time. > We'll see how it goes! > > Che

Re: How to prevent Oracle 9i for Windows from starting?

2002-01-12 Thread Marin Dimitrov
- Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, January 12, 2002 17:05 > > How can I prevent Oracle 9i (for Windows) to start automatically at Windows > startup? > in the registry set HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOMExx/ORA_sid_

RE: Installation Problems

2002-01-12 Thread JoJo Al-Zawawi
Thanks a lot, Joe. Since I backed up my registry before I installed Oracle, I can probably just import the backed-up registry and save myself some time. We'll see how it goes! Cheers, JoJo -Original Message- Sent: Saturday, January 12, 2002 5:45 AM To: Multiple recipients of list ORACL

Re: How to prevent Oracle 9i for Windows from starting?

2002-01-12 Thread Joe Testa
check out services, thats about my extent on knowledge on oracle/windoze. joe Csillag Zsolt wrote: > > Hi, > > > How can I prevent Oracle 9i (for Windows) to start automatically at > Windows startup? > > I want Oracle to start _only_ when I want to ( as the Oracle under Linux). > > > Th

RE: Installation Problems

2002-01-12 Thread JoJo Al-Zawawi
Hi Paul, The CD installation program is not working (it just won't run) -- that's 90% of my problem. I'm going to have to do a manual de-install. I am completely unfamiliar with Oracle (I'm about to take a class and start learning it), so I haven't any idea where it places files, i.e., whether

RE: How to prevent Oracle 9i for Windows from starting?

2002-01-12 Thread Larry Elkins
Go into Administrative Tools | Services and check the startup type for the 9i service -- it is probably set to automatic. Change to manual and you're done. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On

How to prevent Oracle 9i for Windows from starting?

2002-01-12 Thread Csillag Zsolt
Hi, How can I prevent Oracle 9i (for Windows) to start automatically at Windows startup? I want Oracle to start _only_ when I want to ( as the Oracle under Linux). Thank you in advance Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cs

Re: The OCP bar is being raised

2002-01-12 Thread Rachel Carmichael
John, the thing that scares me about OCP is not that the technical interviews won't catch people who don't know anything. If I can't tech someone and find out that they just know what they studied for OCP, I shouldn't be doing tech interviews. What I find disturbing is when the HR department mak

Re: Installation Problems

2002-01-12 Thread Joe Testa
here you go, save it, i'm sure you'll need it in the future, i dont do oracle database on windoze but support the clients. ---cut here--- Introduction Removing or deinstalling Oracle software from an 95/98/NT operating system requires several steps to completely creating

Re: init.ora (un documented) parameters

2002-01-12 Thread Marin Dimitrov
- Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, January 12, 2002 14:10 > > Hope that there are totally 504 init.ora parameters in ORacle8i. Out of that > only 203 parameters > only documents, remaining are undocumented. This i read on

init.ora (un documented) parameters

2002-01-12 Thread Nirmal Kumar Muthu Kumaran
Hei all, Hope that there are totally 504 init.ora parameters in ORacle8i. Out of that only 203 parameters only documents, remaining are undocumented. This i read on a white paper. Where should i get information about these parameters? Just i want to know. Here is my Q. the init.ora paramet

Correct OCI Version

2002-01-12 Thread dieter . oberkofler
hi to all! it's ages now that i'm looking for a good method for determining the exact oci version installed and/or used and i'm still looking. is there someone out there who has found "the" solution on how to correctly determine the used oci version and want to share this information with us ?

Problem with 9i import

2002-01-12 Thread New2orcl
Hi, I have recently installed 9i on my computer and wanted to import my exdat.dmp file from my Oracel 8i. I got nowhere with the enterprise manager console so after trying with no success through Oracle support I decided to try doing the import from a command prompt. Well, I must have done some

Data warehousing Resources

2002-01-12 Thread Pete Wang
Dear All, Would greatly appreciate any advice on books/resources on designing and implementing data warehouse (on Oracle 7-8i) from a less technical and more functional perspective. Cheers, Pete _ Get your FREE download of MSN E

Re: wat kind of data can be keep in blob,clob,nclob

2002-01-12 Thread Stephane Faroult
grace wrote: > > hi gurus, > > wat kind of data can be keep in a blob, clob or nclob? eg. picture image > must be kept using clob only... pls give examples and some sample > programs(forms or report) that actually use them. > > Best regards, > Grace Lim > Suy Sing Comm'l Corp. > 632-2474134 >