 | | | Oracle List | | Hi Jose
>Could anybody tell me under which circunstances different inputs to
>dbms_utility.get_hash_value can lead to the same output.
No idea. But it happens quite often... even if the hashsizPawan
The ORAPWD utility only changes the password in the orapwSID file. You also
need to run the following within sqlplus
Alter user sys identified by {newpassword}
I don 't think you caHi Listers
I am running Oracle 8.1.7 on Win2K. I often encounter problems regarding the user errors. The problem is that often users issue an update statement of say 2 Lakh plus records and th
What 's the problem with having two separate schemas A & B. You will need to
follow strict object naming conventions that would differentiate between
objects belonging to different schemas. With cHi Antonio thanx for ur reply.
i tried that and even re-started the snmp daemon.
then i loaded the oracle MIB entries
(in $ORACLE_HOME/network/doc/*v1 files) into
/etc/mib.defs as said in thHi List
I have two servers one with catalog and one with target databases.
Is there any other to get the backups-pieces/sets on the server having
catalog database? On metalink-forum I found thWho will blink first?
http //www.technewsworld.com/story/news/37432.html
"Software vendors have proceeded cautiously on the core question with
rivals IBM Oracle Sun Microsoft and others waiThe benefit of this statement is that your whole transactions see the
database state as it was in the start of the transaction.
Lets say you have invoice table and invoice items (items) table and inHas anyone applied and tested the 9.2.0.5 patchset 4 on win32?
the last bug that we needed fixed was
# "3732028 3637624 RDBMS WRONG RESULTS WITH DISTINCT COUNT AND
UNNESTED EXISTS SUBQUER Hi if you are interested
http //www.cs.ust.hk/vldb2002/VLDB2002-proceedings/papers/S29P03.pdf
Juan Carlos Reyes Pacheco
OCP
--
http //www.freelists.org/webpage/oracle-l
Thanks Jonathan. You 've given me something to think about. It had not
occurred to me that the buffer header would have to be modified in order
inspect the buffer for consistent read purposes and tHi
1) Does anyone know how to stop event #20 errors going into W2K event
viewer - application log? (assuming I 'm not actually making the
error).
Ref Metalink note - 67868.1
20 - Error ArchI believe you are bypassing the filesystem buffering now so you may
need to adjust the caching and multiblock read parameters.
-Daniel
On Tue 19 Oct 2004 14 16 02 -0500 Roger Xu <roger_xu@In my experience you can move a table and rebuild the indexes without
downtime. Things get a bit slower during the time your messing around
but they don 't stop. 20
Dick Goulet
Senior Oracle Upgrade you database to Oracle 8.0 or later and change the constraint to
enable novalidate. 20
-----Original Message-----
From Seema Singh [mailto oracledbam@(protected)] 20
By fixing the datHi All
We are using Replication to replicate data from our production databases to
data warehouse. If we setup a Dataguard for both production and data
warehouse databases In case of a failover
I have a bit of a dilemma here. We have a production table that has a long
datatype on it and for reasons
I won 't get into cannot be converted to a clob for several more months.
I have a wHello all 20
I apologize if this kind of email is not welcome anymore on the list. 20
One of my coworkers resigned today. My supervisor is looking to hire a
DBA with excellent SQL Server skilI have a table that I need to recover from an old
backup. I seem to recall reading somewhere that I can
just plug in the old datafile into my test database
and access the table that way. The table Los Angeles California area company (Huntington Beach) needs an Oracle DBA with
strong data modeling skills to join its staff.
This position is for a 7x24 operations using Oracle (8i 9i) in SUN How about this?
from metalink <Note 3437884.8 >
10g clients report an ORA-3134 when connecting to any database
version below 8.1.7.4. This error should only be reported for
database versions bIm seeing "mssqlmgr.exe " on one of our client machines. Does anyone
know if this is a virus? every time you kill the service it spawns
another proces (2k)?
--
Bryan S Wells
bunjibry@(protected)Mike
Did the networking setup of your database servers get updated (i.e.
routing paths and DNS server IDs) prior to shutting down the old
servers? I 'd check on those as a point of possible problCan anyone point me at the official Oracle web page that details when Oracle
8i will be de-supported?
John
--
http //www.freelists.org/webpage/oracle-l
Greg here is something to look at
set echo off
--
-- Example plsql script to perform ddl create user for username passed in
--
-- 20021016 Mark D Powell Save code created as newsgroup querHarvinder
How about a simple database table that associates the account with the
bucket?
I 'm not exactly sure what you mean by "bucket ". What exactly are you
storing?
Tom Mercadante
OracI think 9i OEM tuning and performance are well worth it as long as you
understand that some things are just plain wrong - you must have an
educated critical eye. They are mostly minor things butOn Mon 18 Oct 2004 09 04 15 +0100 John Dunn <jdunn@(protected) > wrote
> What affect does setting nls_date_language and nls_date_format have?
NLS_DATE_LANGUAGE defines the default language for datFriends
I need to identify in a column if the 3 first characters are about datatye
number.
Is there another easy way to do it ?
I used the follow instruction
where ascii(substr(columnHemant
I think you have raised some important issues here. Your requirements are
not unreasonable. Today I don 't believe the computer industry is much
concerned about long-term retrieval of data |
|
|
