13,706 reputation
12048
bio website google.com
location Manchester, United Kingdom
age 36
visits member for 2 years, 7 months
seen Aug 26 at 19:00

Oracle DBA, Unix admin.

Available for employment! ;)


Jun
26
reviewed No Action Needed Transfer all read request to Slave in Master-Slave MySQL
Jun
26
reviewed Close Help required to design a database
Jun
26
revised Using oracle easy connect does it really connect to the remote DB?
added 192 characters in body
Jun
25
answered Using oracle easy connect does it really connect to the remote DB?
Jun
25
reviewed No Action Needed PostgreSQL: How does the implicit index work when using “COPY” for loading bulk rows into a newly created table?
Jun
25
reviewed Close Understanding execution plans using TVPs
Jun
25
comment Oracle Partition Table Space Issue
You have to actually resize the tablespace datafile itself, which might actually not be possible if there is data at the end of the file - you can check on DBA_EXTENTS.
Jun
25
comment Why does second instance of database not open?
Hang on, you're trying to use the same files as the other database (while it is running!), and all you did was create a new controlfile to start a 2nd database trying to use the same files (you didn't copy them?)?
Jun
24
reviewed Approve suggested edit on Error ORA-12560 when trying to connect Windows SQL*Plus client to Oracle 11g Linux server
Jun
24
reviewed No Action Needed Block user access to certain tables
Jun
24
reviewed Leave Closed Changing Databases Dynamically using Variables
Jun
24
reviewed No Action Needed Map a Login to a User that was Created Without Mapping to a Login
Jun
24
reviewed Close SQL Server Authentication vs Windows Authentication
Jun
23
reviewed No Action Needed Maximum limit for COPY FROM STDIN in postgres
Jun
23
reviewed Close General tuning in PostgreSQL
Jun
23
comment Can it Possible to do Mysql Active - Active Replication between Redaht linux 6.4X and Ubuntu 12X?
The distribution of Linux doesn't matter, it's the MySQL versions on the hosts that does
Jun
22
comment How can I enable audit on selected accounts only to know where they logged on from?
The first requirement is easily done with a login trigger and a table.
Jun
21
comment A issue on DB link between Postgres and Oracle?
Could also happen if one of the RDBMSes is 64-bit and the other 32-bit
Jun
21
comment Error Creating Foreign Key in Oracle
I just noticed the PRODDB schema name in the error message. Is that the user you're logged in as, or is there a public synonym for the object? If so, explains the error
Jun
20
awarded  Reviewer