Viewing 15 posts - 2,491 through 2,505 (of 3,061 total)
There are three ways to get started, they are: formal training, self training and on-the-job training.
1) Formal training, you know what I mean.
2) Go to http://www.oracle.com, download Oracle sofware, install...
June 25, 2009 at 10:59 am
do you need to compare every single column or a subset of them like pk would do the trick?
June 22, 2009 at 3:17 pm
sql_dump may be what you are looking for, take a look here http://www.wisdombay.com/downs/sqldump.php
it works pretty much the same way Oracle's "export rows=n" would do.
June 22, 2009 at 1:28 pm
:blink: Let me ask just one question... how are you planing to proceed when one of the customers ask you to restore the database lets say... as it was yesterday...
June 21, 2009 at 4:16 pm
If an exception happens during storedproc XYZ execution it will abend with an unhandled exception.
I would suggest to research exception propagation
June 18, 2009 at 7:08 am
Locks are at the foundation of RDBMS.
Blocking locks are bad.
Check wait events.
This note may be of help http://www.simple-talk.com/sql/performance/sql-server-wait-events-taking-the-guesswork-out-of-performance-profiling/
June 15, 2009 at 11:44 am
nalmir.hugo (6/14/2009)Is common to have data from these two tables (products+competitors) merged in a single product table?
:w00t: Nope.
The list of your-company's-products is one entity.
The list of your-competitor's-products is another entity....
June 15, 2009 at 7:15 am
Nicely done John -good to know we still have good data modelers out there; I've nothing else to add.
June 14, 2009 at 4:03 pm
Oracle RAW datatype?
:w00t: If I remember correctly RAW got deprecated after Oracle 7.3.4 just before the Permian Extinction -on Ora8i systems forward it should have been replaced by...
June 11, 2009 at 2:54 pm
M P (6/11/2009)
http://www.sswug.org
Sorry... that one doesn't follow Tim & dmbaker's standards 😀
June 11, 2009 at 2:42 pm
three production copies?... all in the same server?
Do all of them hold the same data?
How do users choose to which database connect?
Are you kidding? 😀
June 5, 2009 at 2:58 pm
Grant Fritchey (6/4/2009)A little more flexibility than bit, but then it has a little more flexibility than bit.
not sure if this is a circular reference or quantum-logic 😀
June 5, 2009 at 2:49 pm
Let me check my understanding of the described scenario.
There is an OLTP database happily living in a cluster which for the purpose of this exercise I would call system-a.
So, the...
June 5, 2009 at 2:43 pm
dmw (6/4/2009)
metalink.oracle.com seems to be available only if you have an ORACLE support contract.
You are correct, Metalink is available only to licensed users.
June 4, 2009 at 2:21 pm
Viewing 15 posts - 2,491 through 2,505 (of 3,061 total)