 | | | Oracle List | | Well the error message should give you the name of the constraint or index causing the problem
ORA-00001 unique constraint (OWNER.NAME) violated
OWNER index or constraint owner
NAME index or coNot sure exactly what you 're after but do either of these help?
SQL > select to_char(sysdate 'HH ') from dual
TO
--
02
SQL > select to_char(sysdate 'HH24 ') from dual
TO
--
14
SQL >
____________There are some bugs posted on Metalink that specifically affect data
upgraded to 10.2.0.3. I don 't recall them off the top of my head but
they have been posted on this list in the last few weeks so Only if you are selecting TIMESTAMP WITH TIME ZONE data types using the
affected timezones from the database and you care if you get the correct
time rather than 1 hour off. By default 9i doesn 't coOne hit on this seemed to indicate it may be a problem with NetBackup.
Someone know where one would dig next. NetBackup folks not positive what
it message is trying to tell them or where to look.
Hi all
I have following case un tested.
For example I have 2 set of servers namely RAC1 RAC2 and NONRAC
I installed and configured 10g in RAC1 and RAC2 instace name RAC
Can I use the datafile frGood morning all. My much-anticipated x86 - > x86_64 test migration
finished and everything *appears* to be well (i.e. I logged in and
did one select on an app table). Something that concerns me waHi Godwin
You mentioned that your backup is a hot backup and then you mention
doing a copy (cp) to restore those. How did you do the backup.
You will need the control file from your backup as it willI have a new server running Solaris (X86-64) on AMD dual core
processors the database is 10.2.0.1 for 64 bit Solaris (X86-64).
When patching to 10.2.0.2 everything patches fine but when adding the Sessions in our 8.1.7 production database suddenly started hanging.
We traced several of them and all were experiencing heavy waits on
executing the same insert into ... values ... statement.
88Hi
Are you using a 9i client to backup a 10G database as mentioned in bug 5113533
Regards
Fairlie
GovindanK <gkatteri@(protected) > wrote
Hello
I need some help on this
All oSt. Louis Missouri company needs an Oracle DBA to join their staff.
Salary range 60-80K..depends on experience.
No Relocation assistance is provided.
Requirements
Minimum 3 or more years in Oracl
Folks
Instance & CRS shutdown both seem to be Hanging for an internal Test
10gR2 RAC Setup.
What approach / action should be considered? Will O.S. RE-BOOT of Both
the Nodes in the Current Sta
Hello I got this by mail from Oracle. Thought i will share it with the oracle-l list. Here you go . HTH GovindanK
To ensure delivery directly to your inbox please add replies@(protected) to yoDennis
We almost always use option 3 for a variety of reasons depending on the
database in question
- Have to pre-create the database in advance of a cut-over of a Production
DB to the new versI have seen people write this type of query
select /*+ index (my_table my_index) */ * from my_table where my_column b1
and purposely omit the "order by " in an attempt at "optimizing " the SQL Can 't recall the exact parameter off the top of my head but there is
one that can be set to intentionally force a delay on the application of
logs to the standby. It is done to give you a chance to On 03/05/2007 09 19 50 AM ryan_gaffuri@(protected) wrote
> I am looking for a tape backup system. I don 't need anything high end.
> Does anyone have any recommendation based on what you have used? On 03/05/2007 07 37 32 AM Niall Litchfield wrote
> John. I 'd 've moved to intermedia for this
Speaking of the Intermedia does anybody know of a good 3rd party book which
explains the basics? OraclHi All
I bumped into below question and answer while I am googling about local
indexes.
I wonder if Oracle really locks all the partitions while doing
insert/delete/update operations on primary keOn 03/05/2007 02 42 17 AM VIVEK_SHARMA wrote
>
> Folks
>
>
>
> Qs What Options exist to avoid FTS on GAM in the below SQL Query?
Index it properly and compute histograms for the columns involvehttp //www.databasesecurity.com/dbsec/cursor-injection.pdf
An email came out on a different list that made reference to the above
document by David Litchfield. I started reading the document andOn 03/04/2007 02 38 34 PM A Joshi wrote
> Hi
> In case of database name change The databases are part of multi master advanced replication. On 9.2. I will be using metalink note 15390.1 hi all
I was wondering if the DW gurus out there can shed light (as in "how it is done in big bad DW shops ") on something of a pesky problem that I?m having with a big Ora Apps scenario we?rHi
I am building a RAC environment which will host 3 Application Database. I am planning to create 4 Oracle Home like one for each Database and 4th one for ASM. This way I can patch any one witOne of my clients is again looking for a senior DBA. The client is in
downtown Seattle and handles a vary large volume of e-commerce
transactions. They run a nice lab for feature testing and qualiI partially agree but I don 't really have a lot of experience with it.
My understanding though is that the purpose of pinning is not so much to
improve performance by keeping it in memory rather it To those of you attending Hotsos Symposium see you there!
--
Mark J. Bobak
Senior Oracle Architect
ProQuest/CSA
"There are 10 types of people in the world Those who understand
binary and those
Can someone point out the change? I still see .5 per core for Intel/AMD
-----Original Message-----
From oracle-l-bounce@(protected)
[mailto oracle-l-bounce@(protected)] On Behalf Of Kerber AndI 'm bit late with the reply but you might find my presentation about
effective test systems management useful. It 's pretty much your case
one to one!
Get the file there -
http //www.pythian.com/blogs/ |
|
|
