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

Oracle DBA, Unix admin.

Available for employment! ;)


Apr
4
comment SQL INDEX - how it works?
BTrees: en.m.wikipedia.org/wiki/B-tree surprised there wasn't an algorithms course at your university that explained this
Apr
4
comment Importing dump file contents to another DB with different schema using Oracle Data Pump
It will create the schemas for you. You may need to run with remap_tablespace if the target databases physical structure is different. Are you saying you have created 10Gb+ of objects in the SYSTEM schema?
Apr
4
comment Importing dump file contents to another DB with different schema using Oracle Data Pump
The SYSTEM schema contains internal Oracle objects, and you shouldn't have created any objects in it yourself - it doesn't need importing. Does the database you're importing into already contain any data? Sounds like you just need to do the import as SYS without remap_schema
Apr
4
comment Importing dump file contents to another DB with different schema using Oracle Data Pump
Why do you want to import the SYSTEM schema? Something's not quite right in what you're wanting to do.
Apr
3
reviewed Approve suggested edit on oracle-enterprise-manager tag wiki excerpt
Apr
3
reviewed Approve suggested edit on oracle-enterprise-manager tag wiki
Apr
3
comment Oracle 10g: same query, different plans on copies of the same DB
You've probably not gathered statistics on one of the databases
Apr
1
comment Is it impossible to store 2^266 records on a database of some kind?
Ah, April Fools Day!
Apr
1
comment Efficient way to fetch/update X records in a loop
Previous comments are nonsense because they haven't actually asked you if the order everything is processed in matters. Also, rename when, it's a reserved word. You know your data - does it need processing in order?
Mar
31
reviewed Approve suggested edit on Does Change Data Capture (CDC) work in a SQL Server 2012 AlwaysOn Failover Cluster Instances setup?
Mar
31
comment How to update Status using IF Condition in Mysql trigger
Should that be NEW.Custom_Design_Update_Date IS NULL ?
Mar
31
reviewed Approve suggested edit on Index to fix this query MySQL
Mar
31
revised ORA-00942: table or view does not exist
code, not quote
Mar
31
comment ORA-00942: table or view does not exist
The best way to do this is to use a login trigger to enable session tracing for the specific user in question
Mar
31
comment SCAN verification error during 11gr2 installation
What version of windows (version and 32/64-bit) are you on?
Mar
31
comment Dropped Database Connections in SQL Server 2008R2
Ask your network guys if there are any TCP/IP idle timeouts set on the firewalls.
Mar
31
comment Naming convention for columns with same name (but different logically)?
Are you sure you don't need a separate companyshares table?
Mar
31
comment How to change the output encoding of Oracle command line tools to UTF8?
What command-line tools? What operating system? What scripting language? Should be fine if the NLS settings are correct.
Mar
29
comment Oracle Compatible Parameter to set
Not true. Give me time to lookup the view that holds the relevant info that the flag looks at.
Mar
28
comment How to set isolation to SERIALIZABLE DEFERRABLE for a whole Postgresql database?
This question appears to be off-topic because it is not possible