RE: OT - Wrap-up of 'Serious Question (believe it or not)...'

2001-06-09 Thread Rachel Carmichael
Antonio, There isn't one book that covers all those topics, and for good reason. If written properly -- lots of detailed information and scripts, and explanations of the scripts (so that you feel comfortable to modify them on your own) -- this book is thousands of pages. Unwritable, unreadable

Oracle 9i V$VERSION and changes to the system views for 9i

2001-06-09 Thread Joe Sanderson
Hello, I have not yet tried my OCI based application on 9i (currently downloading...). I'm curious about the V$VERSION string that will be returned for 9i - I'm assuming that it will return something like: "Oracle9i Enterprise Edition Release 9.0.6.0.0 - Production" Can anyone confirm for me wha

WAS: Re: OT - Wrap-up of 'Serious Question ' - now book idea - high

2001-06-09 Thread Paul Drake
[EMAIL PROTECTED] wrote: > > Hi Jim, > > I have an idea for a book. I don´t know if it has been written before , but > I think that it would be very useful to a lot of people. > > Oracle High Availability: > - Recovery scenarios (The author could put scripts to backup archive logs , > tips abou

RE: OT - Wrap-up of 'Serious Question (believe it or not)...'

2001-06-09 Thread antonio . belloni
Hi Jim, I have an idea for a book. I don´t know if it has been written before , but I think that it would be very useful to a lot of people. Oracle High Availability: - Recovery scenarios (The author could put scripts to backup archive logs , tips about archiving , recovering , how Oracle proce

Crystal Reports 7 on 8i client fix?

2001-06-09 Thread Doug C
This issue is about a year old so I wonder if anyone knew of a fix. Crystal 7 will not work with an 8i client. Some people have indicated that ODBC works ok this way, but we are using Oracle native drivers, p2sora7.dll or something. Here's a link on the subject http://support.seagatesoftware.com

RE: OT - Wrap-up of 'Serious Question (believe it or not)...'

2001-06-09 Thread Rachel Carmichael
Jim, trust me, you'll need the alcohol to persuade the bad Rachel to come out. I hadn't realized Martin Sheen was drink during Apocalyse Now. New fact for the day. Rachel >From: "Hawkins Family" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAI

RE: OT - Wrap-up of "Serious Question (believe it or not)..."

2001-06-09 Thread Rachel Carmichael
Jim, Gulp! What have I gotten myself into? Okay, none of you will believe this but I'm shy and get stage fright. Stop laughing! It's true Two roles, twice as much to memorize but I get to bring out the best and worst in me. Rachel >From: "Hawkins Family" <[EMAIL PROTECTED]> >Reply-To:

OT: DBA 101 paper

2001-06-09 Thread Rachel Carmichael
Okay, since I protested when it was up without authorization, and the site owner did take it down, an authorized copy of the paper is now on the www.nyoug.org site. There is a link to the paper on the home page. Rachel _ Get your

RE: SID on sqlplus prompt?

2001-06-09 Thread Diana_Duncan
Neat! I knew there was some way of selecting that, but couldn't remember it and also couldn't find them in the FM. Didn't someone complain about the terrible indexes on Oracle manuals? Let me add my voice to that particular clamor. Diana Duncan TITAN Technology Partners One Copley Parkway, St

RE: OT - Wrap-up of 'Serious Question (believe it or not)...'

2001-06-09 Thread Mohan, Ross
I'd forgotten all about thiswhat a delight to be reminded! -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/8/2001 7:27 PM Meet Ross and Mark (or other certifiable goofs) at the following for secret decoder ring training: http://images.burningman.com/gallery/bd

Re: Dedicated connections on MTS server

2001-06-09 Thread Charlie Mengler
I'm fighting this same problem, but in reverse. I'm trying to get all my folks using DEDICATED connections. Simply put on my server the listener uses port 1521 for MTS/shared connections. It uses port1529 for DEDICATED connections. The TNSNAMES.ORA file on each client determines which port is use

RE: Dedicated connections on MTS server

2001-06-09 Thread MacGregor, Ian A.
You enable MTS on the server and that method becomes the default connection method, but the final determination on whether shared or dedicated servers are used is controlled on the client side. If a client's tnsnames file has server=dedicated as part ofn the stanza for connecting to the data

Re: Create Directory - Statemen

2001-06-09 Thread Azhar Siddiq
Nirmal, Create directory command simply creates a database object,Client system directory path can't be given during its creation. it is used with LOB manipulation, DBMS_LOB package read and write operations are related to this directorty path given during creation. For more details, do check DB

Dedicated connections on MTS server

2001-06-09 Thread Aravind Tigadi
Hi, We have setup a MTS server on our oracle 8.0.5 database. The total number of >users is around 800 - 900. Eventough MTS configuration is working fine, we find around 200+ users getting connected to the database as DEDICATED users. According to me If the server is setup as MTS there should n

RE: SID on sqlplus prompt?

2001-06-09 Thread MacGregor, Ian A.
If the db_name will do just as well you can use sys_context('USERENV', 'DB_NAME') to obtain the database name and not have to grant access to any of the v$ tables. There's also ora_database_name which is a function that takes no arguments and returns . Both of these can "selected from d

Create Directory - Statemen

2001-06-09 Thread Nirmal Kumar Muthu Kumaran
Hi all, Can anyone please tell me what is the use of the 'CREATE DIRECTORY' sql statement. Hope that it would be used on LOB datatype manipulations. Please enlighten me. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran I

RE: OT - Wrap-up of 'Serious Question (believe it or not)...'

2001-06-09 Thread Hawkins Family
Rachel, Well...umer..ah..maybe. You know, Martin Sheen was drunk during the filming of many scenes of Apocalypse Now. I just thought I would follow Coppola's lead and get all the actors/actresses drunk for a more free-flowing performance. Wait 'til I break out the virtual schnapps

RE: OT - Wrap-up of 'Serious Question (believe it or not)...'

2001-06-09 Thread Hawkins Family
Yes, but this leads to virtual hang-over which is a very good thing... ^ Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 501 Pearl Drive St. Louis, MO 63376 (636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (pe

RE: OT - Wrap-up of "Serious Question (believe it or not)..."

2001-06-09 Thread Hawkins Family
Rachel, Well, I didn't want to suggest you be the "bad girl" type right off the bat. What we can do is have you play two parts in the movie, one the "good angel" and one the "dark angel". That way, you can really bring out the best of both worlds. set director_talk on It's all about motivation

RE: whats new in oracle8.1.7

2001-06-09 Thread Mark Leith
http://technet.oracle.com -Original Message- Sent: Friday, June 08, 2001 10:06 To: Multiple recipients of list ORACLE-L Hi from where can I get oracle8.1.7 new features?Any website except www.oracle.com Thanks -seema _ Get

RE: dumn unix script question

2001-06-09 Thread Mark Leith
Thanks Jared! Off to find my first Perl Book :) I've seen on the list the things you do with perl scripts, and have to say I'm always impressed.. Mark -Original Message- Sent: Friday, June 08, 2001 10:11 To: Multiple recipients of list ORACLE-L Let me start off by saying that I like

Re: parallel query performance

2001-06-09 Thread Jared Still
On Friday 08 June 2001 23:20, Stephane Faroult wrote: > > And why is Elbonia submitted to such restriction? Do they actively > support terrorism from militant ethnic Graecian groups in the Balkans? It's based on human rights violations. They encourage child labor and discriminate against molly-