Thanks for the reply Tim,
I will try to look at the index and bad blocks at the datafile or
restart the database again. The type column for QTY_SOLD_SO is number.
Regards,
Wendry.
-Original Message-
Sent: Saturday, January 17, 2004 9:15 PM
To: 'Wendry'
I would suspect some problems
Dear All,
I need help on the following query, the following has been simplified to
show you the exact problem. Due to this error, the sql query is giving
unstable result which affects on production reporting in my company. I
wonder what's the real problem?
SQL SELECT COUNT(1) FROM
2 (SELECT
Hi!
Use SET TRANSACTION READ ONLY before your run the queries and run them again
(without any commits or rollbacks in the middle). That way you can be sure
that any hidden changes to data won't be reflected.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
9.2.0.4.
Thanks for your troubleshooting help.
Stephen
---
Greetings fellow-DBA-folk:
When I run several queries, I am getting very strange results.
Selecting * from apple returns the expected data records, but count(*)
does not.
Selecting anything other than * from apple says no records
query consist of a SQL statement? Does it have an execution
plan?
Very strange, indeed.
Tanel.
Dear List,
I have a very strange query:
The table, data, indexes, constraints are set up exactly same
The query was running ok in the test database but paused the production
system.
It is also
the problem is!
Does your query consist of a SQL statement? Does it have an execution plan?
Very strange, indeed.
Tanel.
Dear List,
I have a very strange query:
The table, data, indexes, constraints are set up exactly same
The query was running ok in the test database but paused
Dear List,
I have a very strange query:
The table, data, indexes, constraints are set up exactly same
The query was running ok in the test database but paused the production
system.
It is also running ok in production if the primary key disabled.
Any ideas? Any input will be greatly
Even stranger is, that you expect us to solve your problem without knowing
what exactly the problem is!
Does your query consist of a SQL statement? Does it have an execution plan?
Very strange, indeed.
Tanel.
Dear List,
I have a very strange query:
The table, data, indexes, constraints
ORACLE-L [EMAIL PROTECTED]
com cc:
Sent by: Subject: A STRANGE QUERY
On 01/12/2004 03:54:27 PM, system manager wrote:
Dear List,
I have a very strange query:
The table, data, indexes, constraints are set up exactly same
The query was running ok in the test database but paused the production
system.
It is also running ok in production if the primary key
problem without knowing
what exactly the problem is!
Does your query consist of a SQL statement? Does it have an execution plan?
Very strange, indeed.
Tanel.
Dear List,
I have a very strange query:
The table, data, indexes, constraints are set up exactly same
The query was running ok
is not, and
a sense of humor was provided to console him for what he is. --Unknown
-Original Message-
Sent: Wednesday, January 07, 2004 2:49 PM
To: Multiple recipients of list ORACLE-L
Greetings fellow-DBA-folk:
When I run several queries, I am getting very strange results.
Selecting * from
To: Multiple recipients of list ORACLE-L
Greetings fellow-DBA-folk:
When I run several queries, I am getting very strange results.
Selecting * from apple returns the expected data records, but count(*)
does not.
Selecting anything other than * from apple says no records.
The subquery for pear
Question: insufficient information for a meaningful answer.
On 01/07/2004 02:49:26 PM, Stephen Andert wrote:
Greetings fellow-DBA-folk:
When I run several queries, I am getting very strange results.
Selecting * from apple returns the expected data records, but count(*)
does not.
Selecting
]To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
health.com cc:
Sent by:Subject: Strange behavior
ORACLE-L
Subject: RE: Strange behavior
Stephen,
Do any of your sub-selects (the queries inside the IN() clause) return
NULL? If so, that will definitely cause zero rows to be returned by the
outer query.
-Mark
Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
Imagination
I've seen similar behavior in Oracle7 with a logically corrupted index.
Could you do an explain plan on each and see what the access paths are for
each?
Daniel Fink
Stephen Andert wrote:
Greetings fellow-DBA-folk:
When I run several queries, I am getting very strange results.
Selecting
alter session set sql_behavior = 'normal'
/
seriously ... me thinks that you have a NULL value returned by your subquery.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are
Stephen,
Smaller copy, possibly a different execution plan?
Daniel
Stephen Andert wrote:
Mike,
Thanks for the tip, but I have already prefixed the owner for both
tables so that shouldn't be a problem. That did give me an idea for som
additional testing. When I made a smaller copy of the
:
Sent by:Subject: Strange
behavior
[EMAIL PROTECTED
alter session set sql_behavior = 'normal'
*
ERROR at line 1:
ORA-02248: invalid option for ALTER SESSION
Proof that there is nothing 'normal' about me grin
I ran my subquery separately looking for null's and it doesn't look
like I have any. Here is what I did. Let me know if
Of
Bobak, Mark
Sent: Wednesday, January 07, 2004 2:09 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Strange behavior
Stephen,
Do any of your sub-selects (the queries inside the IN() clause) return
NULL? If so, that will definitely cause zero rows to be returned by
the
outer query
The NULL's angle is the first reaction many of us have when we see the words
sub-query and strange results or no rows. I think I *finally* remember
after all these years, but you bet I still did the quick test case before
replying just in case I mis-remembered things ;-)
Regards,
Larry G. Elkins
ORACLE-L
Greetings fellow-DBA-folk:
When I run several queries, I am getting very strange results.
Selecting * from apple returns the expected data records, but count(*)
does not.
Selecting anything other than * from apple says no records.
The subquery for pear works fine on it's own.
Selecting
More weirdity based on the situation from the last email...
SQL insert into junk values ('Y');
1 row created.
SQL select a.*, b.*
2 from
3 ( select * from junk minus select * from junk2 ) a,
4 ( select * from junk2 minus select * from junk ) b;
T T
- -
Y X
SQL insert into junk2
Title: RE: Strange behavior continued...
bambi -
not that I can provide any insight on your strange behavior, I mean the SQL:-)
But this provided some thought on some chaos going on here on a nice Friday afternoon in Atlanta. thanks for the help:-)
-Original Message-
From: Bellow
Title: RE: Strange behavior continued...
Any
time, Greg!
:)
Bambi.
-Original Message-From: Loughmiller, Greg
[mailto:[EMAIL PROTECTED]Sent: Friday, December 12,
2003 2:39 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Strange behavior
continued...
bambi
List...
SunOS 5.8, Oracle 8.1.6 (and 8.1.7 too).
I use this proc to generate statistics:
create or replace procedure get_statistics as
cursor get_users_list is
select username
from dba_users
where username != 'SYS'
and username != 'SYSTEM';
begin
for i in
List...
SunOS 5.8, Oracle 8.1.6 (and 8.1.7 too).
I use the proc at the bottom to generate statistics.
It seems to work, but if I check statistics with:
select owner, table_name, num_rows, blocks,
av_row_len,
to_char(last_analyzed, 'MM/DD/ HH24:MI:SS')
from dba_tables;
the tables have the
after running the block, do you actually spool the output and run that??
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having
Um...the PL/SQL script at the bottom of your e-mail doesn't
DO anything other than output a line. Do you use this
in a subsequent command file?
Cheers,
Mike
-Original Message-
Sent: Thursday, December 11, 2003 8:09 AM
To: Multiple recipients of list ORACLE-L
List...
SunOS 5.8,
The proc generates the 'exec dbms_stats ' statements for all the users. Are yousaving theoutput and running it manually or not.IT would have the same statements that you run one by one. Jose Luis Delgado [EMAIL PROTECTED] wrote:
List...SunOS 5.8, Oracle 8.1.6 (and 8.1.7 too).I use the proc at the
: Strange behavior with dbms_stats...
The proc generates the 'exec dbms_stats ' statements for all the users. Are you
saving the output and running it manually or not. IT would have the same statements
that you run one by one.
Jose Luis Delgado [EMAIL PROTECTED] wrote:List...
SunOS 5.8
Oooppp...
Sorry... I sent the testing proc... this is the
original...
procedure get_statistics as
cursor get_users_list is
select username
from dba_users
where username != 'SYS' and username != 'SYSTEM';
begin
for i in get_users_list
loop
dbms_stats.gather_schema_stats(ownname=
--Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Bellow, BambiSent: 2003-12-02 6:14 PMTo: Multiple
recipients of list ORACLE-LSubject: RE: Anyone run into this
strange ORA-00904 error ??
I have run into this problem in the past in two different
Sometimes the upper case and lower case get mixed up
in the data dictionary. I know that Oracle claims
case insensitivity but it happens. Take a look at
sys.col$ and sys.obj$.
--- Krishna Kakatur [EMAIL PROTECTED] wrote:
Did you check grants on the table?
This happens sometimes, with some
I have also seen a case where new line or other weird ASCII charater
find they way into the name that could cause this behavior.
-Original Message-
Sent: Wednesday, December 03, 2003 10:14 AM
To: Multiple recipients of list ORACLE-L
Sometimes the upper case and lower case get mixed up
Title: Anyone run into this strange ORA-00904 error ??
We started having a weird problem that looks like some kind of data dictionary corruption.
My first choice is to run catalog / catproc. This did nothing to resolve the problem.
Why am I able to describe an object, but get ORA-00904
Title: Message
Would
an export/drop/import work for you?
Abraham
-Original Message-From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Sent: Tuesday,
December 02, 2003 10:34 AMTo: Multiple recipients of list
ORACLE-LSubject: Anyone run into this strange ORA-00904 error
??
We
Title: Anyone run into this strange ORA-00904 error ??
What happens if you select 1 or 'X' from the
table?
Tanel.
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, December 02, 2003 6:34
PM
Subject: Anyone
Babette,
Can you list the describe of the whole table?
Daniel FInk
[EMAIL PROTECTED] wrote:
We started having a weird problem that
looks like some kind of data dictionary corruption.
My first choice is to run catalog /
catproc. This did nothing to resolve the problem.
Why am I able to describe
Did you check grants on the table?
This happens sometimes, with some oracle versions,
in the following situation:
step1: user1 creates tab1 and
grants all to user2. (without grant option)
step2: user2 creates view1 based on tab1
and grants all to user3.
Now, when user3 tries to
It this a view ?
--
Denny Koovakattu
Quoting Tanel Poder [EMAIL PROTECTED]:
Anyone run into this strange ORA-00904 error ??What happens if you select 1
or 'X' from the table?
Tanel.
- Original Message -
From: [EMAIL PROTECTED]
To: Multiple recipients of list
Babette,
Version? Are you doing this through sqlplus and if so, is the client
installation a different version than the db?
Rachel
--- [EMAIL PROTECTED] wrote:
We started having a weird problem that looks like some kind of data
dictionary corruption.
My first choice is to run catalog /
into this strange ORA-00904 error ??
Did you check grants on the table?
This happens sometimes, with some oracle versions,
in the following situation:
step1: user1 creates tab1 and
grants all to user2. (without grant option)
step2: user2 creates view1 based on tab1
and grants all
into this strange ORA-00904 error
??
We started having a weird problem that looks like
some kind of data dictionary corruption.
My first choice is to run catalog / catproc. This
did nothing to resolve the problem.
Why am I able to describe an object, but get
ORA-00904 when I try
[Sorry, also posted with the wrong subject title - RE: (un)intelligent agent]
Hi all,
Does anyone have an idea why the query is picking a random local bitmap index whose
single column is not used in the query to do a conversion on?
Regards,
Adrian
---
SELECT 1
FROM
Sorry, its late on Friday and need beer...
The bitmap index is partitioned in INV5.
-Original Message-
Sent: 07 November 2003 15:30
To: Multiple recipients of list ORACLE-L
on.
[Sorry, also posted with the wrong subject title - RE: (un)intelligent agent]
Hi all,
Does anyone have an
:)
-Original Message-
Sent: 08 October 2003 09:54
To: Multiple recipients of list ORACLE-L
did you just want to see it in an alert.log? or are you working with a
dump?
joe
Vergara, Michael (TEM) wrote:
Ok...strange request time. I want to test a script that I found
on the DBA
, 2003 6:54 PM
To: Multiple recipients of list ORACLE-L
did you just want to see it in an alert.log? or are you working with a
dump?
joe
Vergara, Michael (TEM) wrote:
Ok...strange request time. I want to test a script that I found
on the DBA Village web site. It's supposed to capture some
-L
Subject: Strange Request
Ok...strange request time. I want to test a script that I found
on the DBA Village web site. It's supposed to capture some
information whenever there's a DB error.
Does anybody know how to trigger a 'benign' ORA-600 so I can test
this functionality
Subject: Strange Request
Ok...strange request time. I want to test a script that I found on
the DBA Village web site. It's supposed to capture some information
whenever there's a DB error.
Does anybody know how to trigger a 'benign' ORA-600 so I can test this
functionality?
Thanks
errors;
HTH
--
David Lord
-Original Message-
From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]
Sent: 08 October 2003 02:14
To: Multiple recipients of list ORACLE-L
Subject: Strange Request
Ok...strange request time. I want to test a script that I found
on the DBA Village web
recipients of list ORACLE-L
did you just want to see it in an alert.log? or are you working with a
dump?
joe
Vergara, Michael (TEM) wrote:
Ok...strange request time. I want to test a script that I found
on the DBA Village web site. It's supposed to capture some
information whenever there's a DB
to reproduce them. One of the most
drastic measures would be to kill one of the background processes!! Of course this
will also kill your database.
---
Vergara, Michael (TEM) wrote:
Ok...strange request time. I want to test a script that I found
on the DBA Village web site
Ok...strange request time. I want to test a script that I found
on the DBA Village web site. It's supposed to capture some
information whenever there's a DB error.
Does anybody know how to trigger a 'benign' ORA-600 so I can test
this functionality?
Thanks,
Mike
-Original Message-
Sent: Tuesday, October 07, 2003 9:14 PM
To: Multiple recipients of list ORACLE-L
Ok...strange request time. I want to test a script that I found
on the DBA Village web site. It's supposed to capture some
information whenever there's a DB error.
Does anybody know how
did you just want to see it in an alert.log? or are you working with a
dump?
joe
Vergara, Michael (TEM) wrote:
Ok...strange request time. I want to test a script that I found
on the DBA Village web site. It's supposed to capture some
information whenever there's a DB error.
Does anybody
Vergara, Michael (TEM) wrote:
Ok...strange request time. I want to test a script that I found
on the DBA Village web site. It's supposed to capture some
information whenever there's a DB error.
Does anybody know how to trigger a 'benign' ORA-600 so I can test
this functionality?
Thanks,
Mike
10gR4 will modify payroll and send me the check.
Jared
On Monday 21 July 2003 19:39, Mladen Gogala wrote:
10gR3 will read programmer's mind and automatically correct all design
errors. RDBMS 11T will look like Arnie Schwartzenegger (T is for
Terminator). I'll be back.
On 2003.07.21 22:04,
Hopefully, not a pink one?
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, July 22, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L
10gR4 will modify payroll and send me the check.
Jared
On Monday 21 July 2003 19:39,
/Strange Executions
Hopefully, not a pink one?
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, July 22, 2003 11:55 AM
To: Multiple recipients of list ORACLE-L
10gR4 will modify payroll and send me the check.
Jared
On Monday 21 July
Jared,
With your luck the check you refer to will be like the ckeck in a
restaurant. Don't forget the tip.
Ron
[EMAIL PROTECTED] 07/22/03 03:34PM
Hopefully, not a pink one?
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, July
Ok you guys...
Here's the latest on the 'real' subject of this thread.
You know what an explain plan looks like, right? On our
production DB, it looked like
SELECT STATEMENT CHOOSE
SORT GROUP BY
TABLE ACCESS BY INDEX ROWID
INDEX RANGE SCAN
Ok...so far so what, right? Well, on our
Metalink has a note that the INLIST ITERATOR may cause problems on certain platforms.
That's about as much detail as it offers.
I don't know the internal workings of II, but I suspect there is some sort of merging
occuring after each (or all) iterations. Perhaps someone on the list can explain
Hi Everyone!
HELP!
I upgraded my SAP *PRODUCTION* instance to 9.2.0.3 over the weekend.
Everything up until now has been OK. However, I now have some
SAP Transactions (read: data entry forms) that are abending
unexpectedly.
What's strange is that when we run the transaction on our Stage
server
ORACLE-L [EMAIL PROTECTED]
cc:
Subject:HP-UX 11i/9.2.0.3/Strange Executions
Hi Everyone!
HELP!
I upgraded my SAP *PRODUCTION* instance to 9.2.0.3 over the weekend.
Everything up until now has been OK. However, I now have some
SAP Transactions (read: data entry forms
Title: RE: HP-UX 11i/9.2.0.3/Strange Executions
Most likely some thing to do with OS library. contact OWS.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly
) [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/21/2003 02:04 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:HP-UX 11i/9.2.0.3/Strange Executions
Hi Everyone!
HELP!
I upgraded my SAP *PRODUCTION
Jared:
I am in contact with SAP support, but they're scratching
their collective heads, too. I was hoping that maybe a
SAP-savvy lister would be able to say We had that...here's
the fix.
What's strange is that the report runs to completion on our
Stage server.
Thanks,
Mike
-Original
Title: RE: HP-UX 11i/9.2.0.3/Strange Executions
Raj:
Is OWS 'Oracle Worldwide Support'? Our Oracle
support
comes directly from SAP, and they're on the case, but
are as flummoxed as I am. Right now they're trying
to
convince me that the problem is in the NLS
parameters.
However, these values
PROTECTED]
07/21/2003 02:04 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:HP-UX 11i/9.2.0.3/Strange Executions
Hi Everyone!
HELP!
I upgraded my SAP *PRODUCTION* instance to 9.2.0.3 over the weekend
Ron:
According to the ABAP programmers, the code 'variant' is
identical. The generated SQL 'looks' the same, but the
execution plans are radically different.
Thanks,
Mike
-Original Message-
Sent: Monday, July 21, 2003 2:44 PM
To: Multiple recipients of list ORACLE-L
Is or are ALL of
. However, I now have some
SAP Transactions (read: data entry forms) that are abending
unexpectedly.
What's strange is that when we run the transaction on our Stage
server the explain plan is different, and the query succeeds. In
PRD, the query is a single-step, and in stage it gets broken out
SAP Transactions (read: data entry forms) that are abending
unexpectedly.
What's strange is that when we run the transaction on our Stage
server the explain plan is different, and the query succeeds. In
PRD, the query is a single-step, and in stage it gets broken out
into sub-queries
Okay, so its Monday...
What I meant to say is that are the queries with different execution plans the ones
encountering 7445s. If there is a common thread in the execution plans (i.e. hash join
instead of nested loops), then the hj may be triggering the 7445s.
Actually, 10g will have a new
/9.2.0.3/Strange Executions
Michael,
When you say 'different execution plans', what are the
differences? Is the choice in execution plans causing the
ORA-07445? If so, why are the execution plans different
(there has to be a reason)? Statistics, parameters, etc. will
alter
to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: HP-UX 11i/9.2.0.3/Strange Executions
He needs to contact oracle support, because the dump came from the
oracle server process. If he's lucky, the one-off patch is already
10gR2 will automatically correct the errors.
I'm waiting for the version that will know that I *meant* to type
select when I actually type seelct
--- Daniel Fink [EMAIL PROTECTED] wrote:
Okay, so its Monday...
What I meant to say is that are the queries with different execution
plans the
10gR3 will read programmer's mind and automatically correct all design
errors. RDBMS 11T will look like Arnie Schwartzenegger (T is for
Terminator). I'll be back.
On 2003.07.21 22:04, Rachel Carmichael wrote:
10gR2 will automatically correct the errors.
I'm waiting for the version that will
Hi, yong:
This is the database of my friend, and it is in beijing.
I have found some suspected question and asked them to modify the
application to see if this works. They used row level security. I traced the
session with most library cache lock/pin wait event and found two
Hi, friends:
Generally speaking, we hit library cache lock/pin when we do DDL on
object or compile package. I have a env with rac 9.2.0.3 on windows,
sometimes system is hang , only bounce the oracle instance work.
when there is performance problems, the statspack report look like:
I
You can try this script and see if it works for your situation. We had an
elusive problem like this that we were able to gain more information about
using this query:
-- FILE: libcache_lock.sql
--
-- AUTHOR: Andy Rivenes
--
-- DATE: 01/22/2003
--
-- DESCRIPTION:
-- Query to
;
: error at line 1:
: ora-01031: insufficient privileges
:
: WHERE AS :
:
: connect testuser1/testuser1;
:
: grant select on testuser1.table1 to testuser2;
:
: grant succeeded.
:
:
: why is it so ?
: why sys is not able to GRANT ?
: seems to be strange !
:
: the env. is 8.1.6.0./win2k.
:
: Jp
Thanx a lot bulbultyagt.
Jp.
17-06-2003 09:59:20, [EMAIL PROTECTED] wrote:
Granting Object Privileges on Behalf of the Object Owner : The system
privilege named GRANT ANY OBJECT PRIVILEGE allows you to grant object
privileges as if you were the owner. However this a new feature in
Oracle 9i
:
Subject:Re: SYS not able to GRANT -- Strange !
its always been that way, its not strange, sys has NEVER been able to
grant privs on other owner's objects.
i think that has changed in 9i but its late and my brain is fuzzy.
joe
Prem Khanna J wrote:
Guys,
CONNECT SYS AS SYSDBA
WHERE AS :
connect testuser1/testuser1;
grant select on testuser1.table1 to testuser2;
grant succeeded.
why is it so ?
why sys is not able to GRANT ?
seems to be strange !
the env. is 8.1.6.0./win2k.
Jp.
--
Please see the official ORACLE-L FAQ: http
WHERE AS :
connect testuser1/testuser1;
grant select on testuser1.table1 to testuser2;
grant succeeded.
why is it so ?
why sys is not able to GRANT ?
seems to be strange !
the env. is 8.1.6.0./win2k.
Jp.
--
Please see the official ORACLE-L FAQ: http
the schema owner password
Rachel
--- Joe Testa [EMAIL PROTECTED] wrote:
its always been that way, its not strange, sys has NEVER been able to
grant privs on other owner's objects.
i think that has changed in 9i but its late and my brain is fuzzy.
joe
Prem Khanna J wrote:
Guys,
CONNECT
succeeded.
why is it so ?
why sys is not able to GRANT ?
seems to be strange !
the env. is 8.1.6.0./win2k.
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http
at line 1:
ora-01031: insufficient privileges
WHERE AS :
connect testuser1/testuser1;
grant select on testuser1.table1 to testuser2;
grant succeeded.
why is it so ?
why sys is not able to GRANT ?
seems to be strange !
the env. is 8.1.6.0./win2k.
Jp.
--
Please see
, and I don't have to tell anyone the schema owner password
Rachel
--- Joe Testa [EMAIL PROTECTED] wrote:
its always been that way, its not strange, sys has NEVER been able to
grant privs on other owner's objects.
i think that has changed in 9i but its late and my brain is fuzzy.
joe
Sorry, I meant without having to do anything special... according to
the docs it's a DBA account, so it might work with any account granted
DBA. I haven't looked through the docs to see if there is a grant all
privilege equivalent to create any etc... It might just be part of
the kernel code
I'm
Yep, 9i allows sys to grant privs on objects in other schemas.
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 6/12/2003 11:34 PM
its always been that way, its not strange, sys has NEVER been able to
grant privs on other owner's objects.
i think that has changed
Hi,
I got a very strange problem (9.2 on Linux Red Had,
9iAS).
I have a package which works fine, I added a new
procedure in that package, if the procedure's name
starts with order_, (the pkg has some procedure starts
with order) the pkg compiles, and app runs fine. if I
rename it something
How does the app calls this procedure?
-Original Message-
Sent: Thursday, June 12, 2003 5:26 PM
To: Multiple recipients of list ORACLE-L
Hi,
I got a very strange problem (9.2 on Linux Red Had,
9iAS).
I have a package which works fine, I added a new
procedure in that package
to be strange !
the env. is 8.1.6.0./win2k.
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting
its always been that way, its not strange, sys has NEVER been able to
grant privs on other owner's objects.
i think that has changed in 9i but its late and my brain is fuzzy.
joe
Prem Khanna J wrote:
Guys,
CONNECT SYS AS SYSDBA;
create user testuser1 identified by testuser1
Hi List,
I have one Oracle Application database (Version 8.1.7.4 on Sun Sparc Solaris 2.6, instace name CRPHR). I have a table HR_LOCATIONS_ALL in HR schema and there is synonym HR_LOCATIONS_ALL in APPS schema forthis table.
I am trying to create a snapshot inother database ( Version 9.2 on
Hi all,
I am experiencing the following problem ,wondering whether it's problem in
my code or it's bug.
There is an item in the block which has LOV associated with it.
whenever I change it's value , string TRUE is displayed instead of the
value that I have entered.
(nowhere in the code I assign
1 - 100 of 291 matches
Mail list logo