13,859 reputation
12150
bio website google.com
location Manchester, United Kingdom
age 37
visits member for 2 years, 10 months
seen 16 hours ago

Oracle DBA, Unix admin.

Available for employment! ;)


16h
reviewed Leave Closed SQL server transaction log recovery
16h
reviewed Close How can i make dump of big mysql table?
16h
reviewed Close Does a search based on a set of strings impact performance in MySQL?
16h
reviewed Close Replication MariaDB problem
16h
reviewed Close is there some way to give me the order in which inserts should be made so all FK constraint are met?
16h
reviewed Close Local SQL database settings to better mimic SQL Azure
16h
comment ORACLE Query error contains lots of caret at symbols (i.e. ^@^@^@)
It's probably a CR/LF problem, or some crappy invisible characters in your source file. Take a look at the file in a hex editor. ^@ are normally messed up backspaces I think?
17h
comment Update on table deletes the record
If what you say really is the case, check that it is truly a table and not an updateable view.
1d
comment Simplest way to log in as Oracle user different from schema user and still see all tables,… of schema?
ALTER SESSION SET CURRENT_SCHEMA will work, but you still need to do all of the grants.
1d
comment MySQL UDF - wrong ELF class: ELFCLASS32
That's the problem. Your .so needs to be compiled 64-bit
1d
comment MySQL UDF - wrong ELF class: ELFCLASS32
Not on your shared object udf_median.so - run it against the actual mysql server daemon executable.
1d
comment MySQL UDF - wrong ELF class: ELFCLASS32
Run the file command on the mysql binary to check whether its 32 or 64-bit.
2d
comment Oracle 10gR2 - fix for SSL version following Poodle attack
Think you're going to be out of luck on 10.2 - it's too old.
2d
comment Expdp with metadata_only gives way too large dump. Why?
Hmm, how many tables/indexes are there, and how big are their initial extents? Have the tables got lots of partitions?
Oct
28
reviewed Close T-SQL Parsing XML escaped in format %3E (less than)
Oct
28
reviewed Close Can you use CDC on a subscriber for transactional replicaiton
Oct
28
reviewed Close Seeing multiple CXPACKET blocks when trying to load data from a INSERT SELECT
Oct
28
reviewed Close One to many size and performance
Oct
28
reviewed Close Transform it into 3NF
Oct
28
comment Why is this SQL query illegal?
Did you even bother looking at the error message? Was it complaining about not being a group by expression? Edit your question with the error message. Help us to help you.