 | | | Oracle List | | We are on Apps 11i/DB 9.2.0.5 on Windows 2000 Advanced
Server.
Recently i upgraded the database from 8.1.7.4 to
9.2.0.5 and i started seeing the following error
message in the alert.log -
ErrOracle Names and Oracle names server are on in the same. Their still
deprecated in 9i and obsolete in 10g. If you don 't have it running
today move onto OID. 20
Dick Goulet
Senior Oracle DBAYes. The database still "reports " them but the 10g documentation no longer
includes them. I was wondering if anyone had any insight into the logic
behind the omission (as in things don 't happen byDear List
If you have received the latest issue of Exploring Oracle you may have
seen the 'tip ' in the 'Tip Corner ' on page 5.
This 'tip ' explains how you can avoid hardcoding passwords inhas anyone done any research of any kind on the performance gains of
using one over the other? Or can anyone point me at any docs that
might do a compare and contrast of the two types of storage aGanesh
It worked with the following
execute dbms_session.close_database_link( 'testlink04 ')
though it is still weird that ALTER SESSION does not work for the same!
Thanks again!
Arul.
Here 's the SQL I use. It may not be perfect but does include DBA_TAB_PRIVS
which the example SQL seems to have missed.
select grantee 'ROLE ' privtype granted_role privname null owner
null How accurate is it for database development/modelling? Supposedly if tailored properly it works very well for software engineers
http //sunset.usc.edu/research/COCOMOII/cocomo_main.html
--
http //
An analytical solution ...
create table parent
(
id number primary key
)
/
create table child
(
fk number references parent
field1 varchar2(10) NOT NFolks
I hope it 's OK that I 'm posting a job description here but if I didn 't
think it was a great opportunity I wouldn 't have sent it to the list.
Anyhow the company I work for Opsware is Boris
Multiple Pools for shared pool.
Regards
Krishna Kumar
----- Original Message -----
From "Boris Dali " <boris_dali@(protected) >
To <oracle-l@(protected) >
Sent Friday November 05 Hi
Oralce 8173 on Sun box. RBSLMT size is 2G.
First I got this when a delete statement was run. There was no any other
transactions running during the whole thing.
ORA-1650 unable to extenokay.. I 'm a dumb @$$
I need to restart a down database that is on linux with an spfile
parameter that sets db_32k_cache_size...
how do I get rid of/reset that parameter and bring up the databaI don 't believe that anyone has actually supplied
sufficient reason for using autoallocate.
Why bother if it can run out of space even though
space is available?
Shades of DD TBS fragmentatLeRoy
consult the updated document covering this on Metalink.
They have revised their position but I haven 't checked it in a few days.
check Note 282108.1
check "21. Is the Database Client inHow about the SQL*Plus quick reference that is included in the documentation?
On Thu 4 Nov 2004 14 24 32 -0500 Kline.Michael
<michael.kline@(protected) > wrote
> One of our people is asking Hi
I am trying to quisce a replication group but it just keeps hanging. I have checked the usual no transactions to be posted all jobs normal etc. Even tried running job manually. There are noHave you tried iSQL*Plus? Its basically SQL*Plus in a web browser (so
formats the query output nicely) but you 'll still need to secure your
user 's accounts to make sure they only have the relevaHitting a Bug#2058987 on partition-based sorts.
Workaround is to set sort_area_retained_size to sort_area_size. <shudder >
We 're currently at 65MB for SAS. We can go up to 300 connections. <shuddeHi all
We 're moving our Oracle Apps 11.5.6 environment from HP Tru64 to AIX
5.2. We want to stay at our current patch level and don 't want to
upgrade to a newer patch level yet. To do that we
There was an tnsnames.ora in /etc !!!!!!!
THANK YOU ALL !!!!!!
-----Original Message-----
From Mercadante Thomas F [mailto thomas.mercadante@(protected)]
Sent Thursday November 0All
We have just been informed that we may need to support the Russian Chinese
and Haitian Creole languages in our database (as well as American English).
I started looking at the Oracle docs andList - Oracle Discoverer has a neat feature where it can estimate the
completion time for a query pretty accurately I 'm told by our developers.
However for some users we have a view that restrictOkay not sure of exactly what I 'm looking for... but I can 't find it anyway.
I need to find documentation on how to convert a blob data string to a
bfile. I don 't THINK it can be done on existihi all
got it
explain plan for
select /*+ordered use_hash(t o) no_merge(t)*/ o.subject
from
(select /*+ordered use_hash( m mad) use_hash(m al) */
al.parent_id 0 as truThe major things I use my PDA for is just for quick reference notes.
It is nice to have if your away from a system and need to know a
kernal setting you used on a certain machine. I also work withYou are right (doc id 3858845) but still not clear why/how/what went wrong
with that table ?
Chadi.
-----Original Message-----
From mhthomas [mailto qnxodba@(protected)]
Sent Thursday NoveAt the risk of starting an OS war I would **never** recommend any OS
from Redmond WA as something to depoly on.
Glen - 20
you don 't mention the platform but on unix you can slowly adjust the
system
clock (forward or back) using date -a. with this approach 1 30AM
should
only happen once if that 's thMike
check the explain plan for the update. the "where to_char(tabB_num) 3D
v_id " is generally a non-indexable predicate which may be causing a FTS
of the table for each update. "vi_id " sho |
|
|
