13,665 reputation
12048
bio website google.com
location Manchester, United Kingdom
age 36
visits member for 2 years, 7 months
seen Aug 15 at 22:22

Oracle DBA, Unix admin.

Available for employment! ;)


Oct
28
comment configure: error: SQLite3 library not found
Which Linux distribution? All you need to do is use yum or apt-get (depending on the package manager that your distro uses) to install sqlite
Oct
26
revised Managing user priviliges on schema objects
tagged
Oct
25
comment How to manage primary key while updating
You'd usually use a separate history table to store the history/changes, leaving your main table with just the current entries.
Oct
25
answered object oriented database
Oct
25
comment Managing user priviliges on schema objects
You need to re-think your security model. SELECT ANY TABLE means exactly that.
Oct
25
comment Replace minus symbol across whole document
Which RDBMS are you using and what are the documents stored in? Edit your question with the table definition.
Oct
22
answered How to find index organized table
Oct
22
answered What is the purpose of setting serveroutput in oracle?
Oct
22
revised Slow join behaviour with 'or' in predicate
edited tags
Oct
22
revised Is database partitioning for performance reasons meaningful in virtualized environment?
removed smily and user signoff
Oct
21
comment Slow join behaviour with 'or' in predicate
How many rows are really in TOP_USTR?
Oct
18
revised Procedure and Automation in Mysql
edited tags
Oct
15
comment Query gets slow when bind peeking is turned on
Without any specific technical details (the query plan, are you using histograms, what indexes, cardinality... I could go on), this is unanswerable.
Oct
14
comment Average of a row or record across three columns
Less typing is always good :)
Oct
14
comment Average of a row or record across three columns
You can use NVL() in Oracle
Oct
14
comment What is the standard isolation level for a db used for money data?
Your answer is too long and incoherent. Serializable is the answer to the question. Don't rely on developers handling it in software. The ACID compliant RDBMS knows how to handle things. I guess handling money using MySQL should be outlawed :/
Oct
14
comment How do you disable anonymous login? - MySQL
Did you do a FLUSH PRIVILEGES; or restart?
Oct
8
revised I am trying to import a file but it gives me exception : ORA-20001: Invalid Operation. while calling a stored procedure, how can i solve this
added 4 characters in body
Oct
7
comment Is DBCA in Oracle for a single database or the entire system?
dba.stackexchange.com/questions/35910/… is similar
Oct
4
answered Does RMAN in Oracle only copy the archive logs? What happens to the active redo log in case of failure?