Hi,
This will only work like these
Select bitand(4,4)/1 from dual; or plus 0
or
select to_(bitand(4,4)) from dual;
Sinardy
-Original Message-
[EMAIL PROTECTED]
Sent: 16 March 2002 01:08
To: Multiple recipients of list ORACLE-L
Doh! disregard. Brain #$%^ in effect...
I've rewritten the query as :
select usr.name oowner, ob.name oname
from
(
select obj
from x$bh
where to_number(bitand(flag, power(2,19))) > 0
group by obj
) bh,
obj$ ob,
user$ usr
where
ob.dataobj# = bh.obj
and ob.owner# = usr.user#
order by usr.name, ob.name
/
This q
On Sunday 17 March 2002 07:53, Freeman, Robert wrote:
> 1. You do not open the database to users until AFTER you do a backup (hot
> or cold, dosen't mater) at point t2.
Well, yeah, that was the point. It doesn't have to be a cold backup, but
since you can't do any work, it may as well be a co
SET ORACLE_L DIGEST
A variety of ways on 8.0.4 followed by a couple of more ways in 8i, and
8.1.6 and higher:
SQL> select a.summer, sum(b.summer)
2 from summer a, summer b
3 group by a.summer
4 /
SUMMER SUM(B.SUMMER)
-- -
318
618
Hello all
We have a table on banks and branches:
BANKS:
BANK_NO number(2)
BRANCH_NO number(3)
We also have clients table for one bank that does not have the BANK_NO in
it.
We would like to check from the client table to the BANKS table
using constraint like:
ALTER TABLE CLIENTS
ADD CONSTRAINT
Robert:
I was about to tell that. You hit the reply before me (that too on Sunday!!)
BTW THis method is available from 7.x onwards. TO be precious from 7.3.3
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
Robert
Sent: Sunday, March 17, 2002 7:53 AM
To: Multiple r
Lucky for you.
Please share the answer with the people who read the question
!!!
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Wed, March 13, 2002 12:29 PM
> To: Multiple recipien
One more thing:
If you do it on a timely basis (daily, weekly) then people who need data
that can be satisfied by
it does not need to use the production database.
Also developers like to test against a live like database. This way they are
more likely
to catch errors when working against transac
Yep
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.
-Original Message-
Sent: Wednesday, March 13, 2002 5:05 PM
To: Multiple recip
Hello Suresh
There are two types on upgrade:
1) Using the universal installer: In this case you can create a response
file for the installer.
read Oracle Universal Installer Concepts Guide - chapter 3: Silent
Install Using Response Files
2) Copying files from the patch to oracle libraries: cr
Jonathan,
Hash and Merge anti-join methods were there in 7.3.2. The HASH_AJ and
MERGE_AJ hints, as well as the always_anti_join parameter, are in the 7.3.2
docs. Regarding semi-joins, and the HASH_SJ and MERGE_SJ hints, I don't
think they came around until 8.1.5. Not real sure. I know I never use
I have to say to all that this has been a really fun thread thanks to
you all!!
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.
-
Given this situation (which I face from time to time), you have a couple of
options.
1. You do not open the database to users until AFTER you do a backup (hot or
cold, dosen't mater) at point t2.
2. There is a method of recovering a database (8i +) after RESETLOGS has
been
issued with archived r
We are working with EE on nt. There is no need to link and all the options
are available.
If we work with a new option then we check if we have to pay for it and
arrange a new contract.
So, why not do a full link?.
If oracle wants to use something for internal use why should you care?
Yechiel Ad
Layyr,
I can't remember the details of what examples
I have tried so far, but it's certainly been entertaining
trying to map all the things that the optimizer will do.
Like Stefane, I really try to avoid fixing local problems
with init.ora parameters (especially hidden ones) because
of global s
16 matches
Mail list logo