Oracle Database 10g

Oracle database access problem over WAN

We are using ERP applications where application serve is at one location and database server at different location. both locations are connected through a 2 MBPS MPLS link ( latency 4-5 ms). problem is that sometimes i can login to the application and sometimes i get TNS packet writer failure...

Deploying Oracle Database

I do have a database BankDB created on oracle 10g. I want to move this database into another machine. In SQL, you know we use attach and dettach to move databases. How could I do this in the oracle 10g? I'm waiting for your help. Thanks a lot Software/Hardware used: Software

calling trigger in oracle db 10g

hi all! I do have a table called customers. I want to delete and update rows in this table. But I want to keep rows' history before operations into another table. I know this will be performed with help of a trigger. How I could do this? I'm waiting for your help.                  ...

Will Maximo 5.2 work with Oracle 10g?

I am researching to see if we can upgrade to Oracle 10g without upgrading Maximo 5.2 at the same time. We are currently running Oracle 9.2.0.8 which is scheduled to have the terminal patch released July of 2010.

Errors Registering Recovery Catalog in 10g Grid

I have a 2 node RAC environment that I am trying to catalog in a database that is not part of the RAC instances, but is a tablespace in the Oracle Grid control database. This is a testing environment so my configuration may not be the most secure, but the production environment will have a...

oracle sync index job log file

Hi, I am using windows 2003 server with oracle database 10g enterprise edition. I created a procedure and scheduled job to do sync text indexes. I am using parallel 2 for my sync index job. the proble is: After i enable the log file option, ctx_output.start_log('SYNC_INDEXES_JOB.TXT');...

Oracle Developer 10g Express Edition and Oracle Database 10g

can we use same edition at same time? like we are use express edtion of oracle databse 10g and also use oracle developer 10g express edition at same time?