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

Oracle DBA, Unix admin.

Available for employment! ;)


May
19
comment Oracle 11g install on Debian Wheezy does not start
Seems strange that the ORACLE_SID is AL32UTF8 - that is the character set... Is there an /etc/oratab file on your system? If so, edit your question with its contents.
May
19
wiki
May
19
reviewed Reject suggested edit on Import - database not found error
May
19
reviewed Close change data directory postgres with database cluster
May
19
reviewed Close How to Change location of postgres cluster and database within the same machine?
May
16
comment How do DELETE / TRUNCATE affect table / tablespace?
RE truncates - Though if you have FLASHBACK DATABASE setup you can recover the DB to a previous SCN and get the data, but it requires a database bounce. See gavinsoorma.com/2009/08/using-flashback-to-rollback-a-truncate as an example
May
16
comment PL/SQL extremely slow FETCH performance
What else are you doing in the loop? If you're doing an update, delete or insert it will be relevant, so edit your question with exact details.
May
16
comment skip columns while using LOAD command mysql
LOAD DATA INFILE 'file.txt' INTO TABLE t1 (column1, column2, @discard3, column4);
May
15
answered skip columns while using LOAD command mysql
May
15
reviewed Approve suggested edit on What's the difference between functions and stored procedures?
May
14
awarded  Caucus
May
13
comment How to merge data from 2 databases
Before it got edited.... Sigh.
May
13
comment How to merge data from 2 databases
Assuming SQL Server?
May
13
comment How to merge data from 2 databases
Which RDBMS, for starters?
May
13
reviewed Approve suggested edit on Simple model database transaction log full 'CHECKPOINT'
May
13
reviewed Approve suggested edit on MySQL poor order by performance on partitioned table
May
13
reviewed Close A separate table or ENUM?
May
13
reviewed Approve suggested edit on Dealing with empty strings while loading a table from a CSV
May
12
comment Why is MySQL order by performance poor within a single partition of a partitioned table?
Unless you post query plans for all of the scenarios, we can't really help you. Edit your question
May
12
revised Disk space full but logical space available in database
Poor accepted answer. Cleaned up the typos