15,076 reputation
12553
bio website google.com
location Manchester, United Kingdom
age 37
visits member for 3 years, 2 months
seen 6 mins ago

Oracle DBA, Unix admin.

Available for employment! ;)


May
7
comment Type with nested table in oracle
I'm not sure if this is doable. It's time for me to sleep now, but i'll revisit in the morning.
May
6
reviewed Reject How to resolve “Error log file size is increasing in mysql 5.5” issue w/o restarting mysql
May
6
reviewed Leave Open Oracle GRANT ROLE error
May
6
reviewed Reject column auto updated after 24 hours in mysql
May
6
answered Oracle GRANT ROLE error
May
6
reviewed Reviewed How to limit MongoDB database size
May
6
reviewed Reject column auto updated after 24 hours in mysql
May
6
reviewed Approve couchbase tag wiki
May
6
reviewed Approve couchbase tag wiki excerpt
May
6
reviewed Close Postgresql create database with size & resize?
May
6
reviewed No Action Needed How to restore a database from a .bak file to an existing database via GUI?
May
6
reviewed No Action Needed Maintenance plan using external tool to execute query and stored procedures giving off no results
May
6
comment How to make sqlplus prompt longer than 50 chars?
It's not possible. Why on earth do you want a prompt so long?
May
5
reviewed Close Database design for handling 1 billion rows and counting
May
5
comment How can I connect to a network MySQL server using ODBC?
If it's asking for a TNS service name, you're incorrectly trying to setup an Oracle Database connection (IE, the oracle RDBMS, not the company) rather than a MySQL database connection.
May
5
comment Difference in the workload related to data-amount and search option
You need to be clearer on your table structure. Are the forename and surname components stored as a single string? The "information" part - is that really ; delimited in a single column?
May
4
revised pivot a table with cell name as column name
deleted 36 characters in body
May
4
comment How to decrease load time by chunking large file using Percona pt-fifo-split?
A Gigabyte in 48 seconds is likely to be limited by the speed of the disk the file is being read from
May
4
comment General structure advice for beginner
Sane design, assuming you're not storing the actual HTML and the app will figure it out from the DB.
May
3
reviewed Reject how to recover .ibd and .frm files in mysql