13,821 reputation
12150
bio website google.com
location Manchester, United Kingdom
age 36
visits member for 2 years, 9 months
seen 3 hours ago

Oracle DBA, Unix admin.

Available for employment! ;)


Dec
9
comment How can the LEFT JOIN return more results than the unjoined query?
en.wikipedia.org/wiki/Join_(SQL)#Left_outer_join
Dec
9
comment Oracle APEX Button creating ORA-00920
Could be a grants problem for the APEX user. Also, sounds like your table needed a database_name column
Dec
8
answered Why does the same query run faster the second time I run it?
Dec
7
comment Warning before issuing delete/update command in mysql/oracle , then executes
"I would argue that this fixes the wrong problem, which is that you have privileges granted to people that they are not qualified to hold." -- That alone should be the answer to the question. On the Oracle size of things - you're paying license fees in the tens of thousands at least, so why skimp on staff?
Dec
6
comment Preventing sysquerymetrics from being created ASE 15.7
May I ask why??
Dec
6
comment Oracle 11g database structural change doesn't autobackup controlfile/spfile
Yes, but you have to run rman to create the backup in the first place. It's not "automatic" in the sense you thought it was.
Dec
6
comment Is there are way to use Fine Grain Auditing to record Varray bind values?
The documentation says "for an array, the values recorded are only the last set of bind values"
Dec
6
comment Warning before issuing delete/update command in mysql/oracle , then executes
In Oracle you can ROLLBACK. Anyway, sounds like a silly requirement. If you're unsure whether you want to run the update/delete, don't press enter in the first place!
Dec
6
comment Oracle 11g database structural change doesn't autobackup controlfile/spfile
@kupa You're misinformed. @ Ivan already told you the answer....
Dec
5
comment mysqldump file size changes drastically with repeated runs
I'm happy to be wrong ;) I'm not clued up on the internals of innodb storage, but ASCII flat files aren't an efficient way of storing things. When you add the old INSERT INTO blah VALUES parts to a dump generated by mysqldump, things grow significantly and explain the size difference
Dec
5
comment mysqldump file size changes drastically with repeated runs
Are you sure the script isn't appending to the existing file? I bet it is and you'll be a bit embarrassed ;)
Dec
5
comment MySQL query log
Time to summon @RolandoMySQLDBA again
Dec
5
comment Database design implementing support for different languages
You'll want to read up on HAVING in your SQL book
Dec
5
revised table does not exist
added 148 characters in body
Dec
5
comment MySQLdump on specific db date
Are you running on Linux? If so, you want to use cron. The people on serverfault will be able to help you with that
Dec
5
comment What is the best way to model an invoicing system with different forms of invoice items?
Don't forget, you're going to need REFUNDS, ADJUSTMENTS etc. Plus you've completely ignored tax - if you're US based, that's an utter nightmare.
Dec
5
answered table does not exist
Dec
5
comment Why does Oracle still not support Multi-Row insert?
Yeah, see that recent Materiaised View question, it's a fine example!
Dec
5
answered Why does Oracle still not support Multi-Row insert?
Dec
5
comment Query with large number of or'ed predicates on the same column?
Yeah, it's common.