14,026 reputation
12150
bio website google.com
location Manchester, United Kingdom
age 37
visits member for 2 years, 11 months
seen Dec 10 at 18:00

Oracle DBA, Unix admin.

Available for employment! ;)


Dec
14
comment 64bit SQL Server with total virtual address space of 4GB. How could this be?
I think I win a prize.
Dec
14
comment 64bit SQL Server with total virtual address space of 4GB. How could this be?
"Intel X86" - you installed the 32-bit version?
Dec
14
comment How to ignore optional prerequisites when installing Oracle database in silent mode?
They're pre-requisites for a reason. You need root access as part of the installation anyway (there are 2 root scripts that need executing)...
Dec
14
answered What is Oracle Database Vault and how does it work?
Dec
14
comment Should I be worried about duplicate entries in the Oracle all_dependencies table?
Things can be dependant on each other. You need some CONNECT BY in your query.
Dec
13
comment How many blocks is my database
where segment_name = 'YOURTABLENAME'
Dec
13
comment How many blocks is my database
Use USER_EXTENTS or ALL_EXTENTS instead
Dec
13
answered How many blocks is my database
Dec
13
comment OEM 11g alerts and notifications arrive together
@jcho360 "are you saying that this won't work because they need to be separate" -- Well, how do you think it can send alerts if it's down?
Dec
13
comment can I quickly create tables for each partition?
Do you need to keep the data in the original partitioned table?
Dec
12
comment How do I identify the column(s) responsible for “String or binary data would be truncated.”
If I knew that, I'd have answered it. Hence my suggestion of changing your script and doing it in perl.
Dec
12
comment How do I identify the column(s) responsible for “String or binary data would be truncated.”
Alter your perl script to query sys.columns (max_length) for the table, then compare the lengths of the strings you're trying to insert when the insert fails. 5 minute coding job
Dec
12
answered Postgresql behavior at end of sequence
Dec
12
comment Stored Procedure Performance using Temporary Tables
Or, carry on regardless if it already existed and continue to fill it with stuff in another thread, which them might also use it? I've no idea what isolation level MySQL uses, but dirty reads spring to mind
Dec
12
comment Stored Procedure Performance using Temporary Tables
My MySQL knowledge is crap, but wouldn't "CREATE TEMPORARY TABLE IF NOT EXISTS BATCH_ITEMS_UOW" block if it already existed? @RolandoMySQLDBA Help?
Dec
12
comment MySQL Link to PHPMyAdmin/MS Access
"I have a mysql database stored on a server via phpmyadmin". No, you have a MySQL database stored on a server that you administer using phpmyadmin. It's very easy to do a remote ODBC connection, but that kind of question doesn't belong on this site. I will flag it for migration
Dec
12
comment My SQLs are taking too long to execute for first time everyday in Oracle 11g
@user1614862 the data will have been aged out of the cache. LRU
Dec
12
answered Get records which doesn't have duplicate records
Dec
11
comment Get records which doesn't have duplicate records
Your question isn't clear. Do you want to avoid all of the policies highlighted in bold, or all of the ones with the same policy number as well as those highlighted in bold?
Dec
11
comment Oracle 11gR2 IMP Won't Import Table in Dump File From 10g
Oh, sorry. I assumed imp/exp died a death years ago and didn't read your question correctly :) My apologies.