13,594 reputation
12048
bio website google.com
location Manchester, United Kingdom
age 36
visits member for 2 years, 6 months
seen yesterday

Oracle DBA, Unix admin.

Available for employment! ;)


Jun
21
comment Error Creating Foreign Key in Oracle
I just noticed the PRODDB schema name in the error message. Is that the user you're logged in as, or is there a public synonym for the object? If so, explains the error
Jun
20
awarded  Reviewer
Jun
20
reviewed Close SQL Server 2012 Local SSD TempDB Slow
Jun
20
reviewed Close Creating and designing Air Trafic Control System
Jun
20
reviewed Close Can I get some comments on my database design?
Jun
19
reviewed No Action Needed Access the database by different users simultaneously
Jun
19
comment How to dump data from Oracle to MySql
The question doesn't mention SQL Server!
Jun
19
comment Low performance oci_execute
It's called caching
Jun
19
reviewed Close Making a Database Online
Jun
19
reviewed Close Stored procedure taking much longer than query
Jun
19
reviewed Reject suggested edit on How to dump data from Oracle to MySql
Jun
19
reviewed Close PostgreSQL --initdb fails on pg_authid - FATAL
Jun
19
reviewed Close Should a surrogate key reflect one of my columns?
Jun
19
reviewed No Action Needed SQLite and Write Ahead Logging: why so large files
Jun
18
reviewed No Action Needed selecting rows that have n foreign key conditions satisfied
Jun
18
awarded  Nice Answer
Jun
18
comment Debugging long Oracle queries and identifying offending data for 'Expression type does not match a required type' error
You could select via a cursor, iterate over the rows, catch the exception in a block & print the rowid of the offending row
Jun
18
reviewed No Action Needed Lock rows for long running transactions
Jun
18
reviewed Looks OK How to find the same salaries and department names?
Jun
18
reviewed Reject suggested edit on How to run SQL Job only on primary replica in AlwaysOn Availability Groups?