12,900 reputation
11741
bio website google.com
location Manchester, United Kingdom
age 36
visits member for 2 years, 3 months
seen 6 hours ago

Oracle DBA, Unix admin.

Available for employment! ;)


Mar
31
reviewed Approve suggested edit on Does Change Data Capture (CDC) work in a SQL Server 2012 AlwaysOn Failover Cluster Instances setup?
Mar
31
comment How to update Status using IF Condition in Mysql trigger
Should that be NEW.Custom_Design_Update_Date IS NULL ?
Mar
31
reviewed Approve suggested edit on Index to fix this query MySQL
Mar
31
revised ORA-00942: table or view does not exist
code, not quote
Mar
31
comment ORA-00942: table or view does not exist
The best way to do this is to use a login trigger to enable session tracing for the specific user in question
Mar
31
comment SCAN verification error during 11gr2 installation
What version of windows (version and 32/64-bit) are you on?
Mar
31
comment Dropped Database Connections in SQL Server 2008R2
Ask your network guys if there are any TCP/IP idle timeouts set on the firewalls.
Mar
31
comment Naming convention for columns with same name (but different logically)?
Are you sure you don't need a separate companyshares table?
Mar
31
comment How to change the output encoding of Oracle command line tools to UTF8?
What command-line tools? What operating system? What scripting language? Should be fine if the NLS settings are correct.
Mar
29
comment Oracle Compatible Parameter to set
Not true. Give me time to lookup the view that holds the relevant info that the flag looks at.
Mar
28
comment How to set isolation to SERIALIZABLE DEFERRABLE for a whole Postgresql database?
This question appears to be off-topic because it is not possible
Mar
28
comment How to set isolation to SERIALIZABLE DEFERRABLE for a whole Postgresql database?
You can only do it at session level because DB level makes no sense. postgresql.org/docs/9.2/static/sql-set-transaction.html
Mar
28
comment How to reuse an update trigger for multiple tables in postgresql?
Write a small bit of perl (or whatever you fancy) that writes the code for you.
Mar
28
comment Is there any way to get the estimate cost of executing a query in MySQL?
The MySQL optimiser is hilarious. I hope somebody else can give you the information you need :)
Mar
27
revised row_number over partition at Version < Firebird 3
added 23 characters in body
Mar
27
reviewed Reject suggested edit on How to the get current date without the time part
Mar
27
reviewed Reject suggested edit on What makes an Oracle Applications DBA different from an Oracle DBA?
Mar
27
answered CASE_SENSITIVE on ORACLE DB
Mar
24
revised Move SQL Server XML column to a new table - slow performance
edited title
Mar
24
comment DB2 9.7, create or replace tablespace possible?
Doesn't really make any sense to implement such a feature for tablespaces, as they're storage, not code.