Reputation
2,212
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
9 34
Newest
 Tumbleweed
Impact
~177k people reached

4h
comment Migrating Oracle 9i database to MySql database on a different Windows Server
it would help if you told us how the vb application accesses the Oracle date...prepared SQL statement, stored procedures, ORM tool??
9h
comment Migrating Oracle 9i database to MySql database on a different Windows Server
just change the connection string in the web config to point to the new database in your project. ensure that visual studio and the new server have the dll's to connect to mysql
1d
comment What does Oracle XE perform during installation?
Yes, you don't need a listener for a client installation. It was not clear from your question where you say you installed two Oracle databases that you only wanted a client install
2d
comment Why is my PL/SQL procedure so slow?
use trace and get some profiling done on what it is doing.
2d
comment What does Oracle XE perform during installation?
Every Oracle database that connects outside a machine is listed in a listener. I don't have access to my test box so I can't tell you whether you have two listeners, one for each install, or one that lists both
Jun
29
answered What does Oracle XE perform during installation?
Jun
25
reviewed Approve What is the privilege for account unlock in Oracle
Jun
25
answered What is the privilege for account unlock in Oracle
Jun
24
revised Understanding of schema and tablespaces - recommendation for a later seperation
added 2 characters in body
Jun
24
revised Understanding of schema and tablespaces - recommendation for a later seperation
deleted 8 characters in body
Jun
24
revised Understanding of schema and tablespaces - recommendation for a later seperation
added 855 characters in body
Jun
24
answered Understanding of schema and tablespaces - recommendation for a later seperation
Jun
22
comment Will an update in my trigger trigger itself? Oracle PLSQL
Sounds like a recipe for the error: table is mutating, trigger may not see new state
Jun
22
answered List full text indexes in Oracle database
Jun
19
comment oracle AQ for scheduled jobs
You can use DBMS_LOCK, docs.oracle.com/cd/B28359_01/appdev.111/b28419/… to generate unique names for your locks but the naming will not affect the type of processing. Can you post a test case?
Jun
18
comment oracle AQ for scheduled jobs
I don't know what you mean by "Pulls multiple exclusive locks". Are you referring to code that uses Select for update or Lock table commands? I am unaware of how you would name a lock or how that would help, more details please on the problem
Jun
17
comment oracle AQ for scheduled jobs
I used oracle AQ to receive changes from multiple tables, queue them and then shoot the changes to another database. There were never any issues with the modest amount of transactions I had ( <200/day). What are you looking for: how to set up, how to queue or???
Jun
17
comment How to correct this script restore and recover database on Oracle?
what is the problem when you tried this?
Jun
15
reviewed Approve Moving from Oracle 11.2.0.1 to 11.2.0.3
Jun
15
answered Moving from Oracle 11.2.0.1 to 11.2.0.3