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

Oracle DBA, Unix admin.

Available for employment! ;)


May
12
comment How to remove all hidden parameters from Oracle Database
Upvote for you. Didn't know about the RESET clause!
May
11
comment Mistake during Oracle 11g PITR
Awesome - keep me updated!
May
11
comment Mistake during Oracle 11g PITR
I thought they looked too small to be full - any idea hiw big the data is? I only had a quick skim read - on the iPhone from the pub :)
May
11
comment Mistake during Oracle 11g PITR
Another thing, do a "LIST INCARNATION OF DATABASE yourdb" to see if there's been a resetlogs.
May
11
comment Mistake during Oracle 11g PITR
A quick glance suggests you're stuffed, as there's only incremental backups and no full backups. One suggestion - copy the datafiles to another directory, then (I quote the documentation) "Record a datafile copy as a level 0 incremental backup in the RMAN repository, which enables you to use it as part of an incremental backup strategy.". Catalog the copies, then try the restore again. Have you checked what SCN the current datafiles are at?
May
10
comment How to “swap” out production tables
Why not just do an insert followed by a delete in the same transaction? Or is the MySQL isolation level too crap to cope with something like that?
May
10
comment Seeting up a PostgreSQL database on another hard drive than my system one on OS X?
Yeah, same. Thought a symbolic link was nice and transparent & needed no config changes.
May
10
answered Seeting up a PostgreSQL database on another hard drive than my system one on OS X?
May
10
answered How to remove all hidden parameters from Oracle Database
May
10
reviewed Approve suggested edit on Select records that do not have associations outside a certain list
May
10
comment Select records that do not have associations outside a certain list
What RDBMS are you using? Have you tried writing a query?
May
10
comment What's the most appropriate NLS_SORT parameter to cover all/most European languages?
This is a good starting read for NLS stuff orafaq.com/node/999
May
10
comment Built-in XML functions
Edit your answer with the full error messages when run through sqlplus. Cut and paste the query and EVERYTHING up to where the SQL> prompt returns after the message.
May
10
comment Built-in XML functions
Does it not give an object name in the ORA-04023 message? It should do.
May
10
comment Built-in XML functions
Actually, not sure you're allowed a WITH clause inside an IN
May
10
comment Built-in XML functions
Can you at least try and execute it in SQL developer or sql plus? It'll tell you where the error is
May
10
comment Built-in XML functions
What oracle version?
May
9
comment Load different date formats in mysql
@user2118349 That's ok. If you found the answer helpful, please mark it as accepted by clicking the "tick" at the top-left.
May
9
comment DELETE failed because the following SET options have incorrect settings: 'ANSI_NULLS'
What happens if you just remove ANSI_NULLS , from the SET command?
May
9
reviewed Approve suggested edit on Load different date formats in mysql