Question : Trying to start oracle service, shows me the follow error: I have the follow SPFILEXE.ORA: Im using ORACLE […]
How to create Oracle RAC database using dbca silent mode with different db_name and db_unique_name
Question : I have a requirement to use dbca (version 126.96.36.199) silent mode to create a RAC database on a […]
Oracle Triggers – Before Update and Before Insert – Separate or Combined?
Question : I’m running Oracle DB 9i. I have a table with various constraints to ensure data integrity. In addition […]
Oracle: how to set only some roles as not default for a user (no GUI)
Question : Scenario: I have instanceA I have instanceB I have USER1 in instanceA I have USER1 in instanceB USER1 […]
How to approach copying a schema for testing?
Question : I’m an Oracle newb. The systems in question are strictly for developers to test against. We fire them […]
Oracle : How to grant to a ROLE the ability to affect a ROLE to a USER?
Question : I have a role : ADMIN_ROLE I’m connected as ADMIN_ROLE and created a TEST_USER and TEST_ROLE I would […]
Convert string to number from xml at server side
Question : I am having issues converting numbers stores as character (with . as decimal, sometimes are null) to number […]
Oracle error “too many values”, must be solved with nested SELECTs
Question : I have hit upon a “too many values” error in Oracle, when working with some intricate nested SELECTs. […]
Is Oracle DB immune to the InnoDB deadlocks found in MySQL?
Question : It seems odd to me that MySQL would not handle this internally: “Deadlock found when trying to get […]
Move Oracle database to new server
Question : I have a Oracle 11g R1 Standard Edition database on production server working on Windows 2008 R2 SE. […]