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 create
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
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 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
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 hi
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. W
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-- Mail
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 s
select
distinct id
from
(select id from table_a minus select id from table_b)
/
should
also work better in most cases compared to exists or not
in.
Raj
-Original Message-From: Sai Selvaganesan
[mailto:[EMAIL PROTECTED]Sent: Saturday, August 16, 2003
5:39 PMTo: Multiple r
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
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: http
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: Mu
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
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 th
14 matches
Mail list logo