RE: Oracle World anyone?

2003-08-16 Thread Connor McDonald
Presumably all the papers will be freely available as per previous years from the oracleworld site. Cheers Connor --- Grabowy, Chris [EMAIL PROTECTED] wrote: Connor, So will those 9i goodies be available to those of us that are not going to make it??? Everyone seems to agree that the

Object programming with Oracle 9i

2003-08-16 Thread tjambu_fatcity
hi object/relational developers Please bear with me if I am not using the right terminology. Am intending on using java to access to the underlying relational tables. Was thinking of exposing the database to java using Object views over the relational views. Trying to isolate the complexity of

RE: Oracle World anyone?

2003-08-16 Thread Freeman Robert - IL
I've seen Connor's presentation if you get the opportunity, attend. I'm sorry to say that I will not be at OOW myself, but I've been accepted at UKOUG and OOW-Paris later this year and hope to be able to go Connor are you presenting at either of those? RF -Original Message- To:

Is Pete Sharman Missing?

2003-08-16 Thread Freeman Robert - IL
Anyone hear anything out of Pete Sharman in the last two weeks? If you see or hear from him, please have him contact me. Robert Robert G. Freeman Author Oracle9i New Features Oracle9i RMAN Backup and Recovery Mastering Oracle8i blah...blah...blah... -- Please see the official ORACLE-L FAQ:

antijoin

2003-08-16 Thread Sai Selvaganesan
hi i am trying to figure out which is a more efficient method to do an antijoin between two tables. The version is 9i and optimiser is choose.stats are the lates. here is the query with not in and not exitsts: case 1: select distinct a.id from tab a where a.id not in (select b.id from b) / case

RE: antijoin

2003-08-16 Thread Jamadagni, Rajendra
select distinct id from (select id from table_a minus select id from table_b) / should also work better in most casescompared toexists or not in. Raj -Original Message-From: Sai Selvaganesan [mailto:[EMAIL PROTECTED]Sent: Saturday, August 16, 2003 5:39 PMTo: Multiple

Re: antijoin

2003-08-16 Thread Jared Still
They are not likely using the same execution paths. Try running this statement first: alter session set events '10046 trace name context forever, level 8'; and then run your queries. Be sure to first run the one that will return rows, in case you need to stop the other query. The trace file

Re: How to tell Oracle the directories of script files

2003-08-16 Thread Reuben D. Budiardja
Thanks all. The replies have been really helpful. Reuben D. Budiardja. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reuben D. Budiardja INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California--

BEA's WebLogic vs. Jdeveloper and iAS

2003-08-16 Thread MacGregor, Ian A.
We are highly interested in having all our Peoplesoft access which does not use screens created via Peoplesoft tools to pass through an applications server. One group invited the folks from BEA out, and my thought was, Hey, we are already licensed for enterprise iAS, Jdeveloper and the like.

Re: Is Pete Sharman Missing?

2003-08-16 Thread tjambu_fatcity
Spoke to Pete last week. he has been on leave and in the process of finding his way in his new office. He is back in Oz. Do you have his email address? ta tony At 10:29 AM 16/08/2003 -0800, you wrote: Anyone hear anything out of Pete Sharman in the last two weeks? If you see or hear from

Oracle 9i and connect as sys

2003-08-16 Thread Babette Turner-Underwood
I have created my first 9i database on OS/390 v2.10. On my Oracle 8i instance, I can connect to the database using: sys/[EMAIL PROTECTED] HOWEVER, In Oracle 9i, I cannot do this. I am FORCED to connect using: sys/[EMAIL PROTECTED] as sysdba I was wondering if this was a new

Re: Oracle 9i and connect as sys

2003-08-16 Thread Tim Gorman
It's a 9i thing, across all platforms. on 8/16/03 9:29 PM, Babette Turner-Underwood at [EMAIL PROTECTED] wrote: I have created my first 9i database on OS/390 v2.10. On my Oracle 8i instance, I can connect to the database using: sys/[EMAIL PROTECTED] HOWEVER, In Oracle 9i, I

Re: Oracle 9i and connect as sys

2003-08-16 Thread Peter . McLarty
Hi Babette This is a feature of 9i. using SYS you have to always use as sysdba same thing on Windows and Solaris at least and I am sure it is all other OS's Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical Consultant

RE: Oracle 9i and connect as sys

2003-08-16 Thread Rothouse, Michael
In Oracle9i, SYS requires connecting as a privileged user using the sysdba parameter. This is equivalent to connect internal in Oracle8i which is now obsolete in Oracle9i. -Original Message- Sent: Sunday, August 17, 2003 12:29 AM To: Multiple recipients of list ORACLE-L I have created