Reading files on the server

Hi all, I have a problem I hope you could help with. I have a job running on db server side as a cron and it creates information (log files). What methods I have if I want to read those log files with some pl/sql procedure etc (I mean from inside the db), are there any others than utl_file

Setup a replication (multi-master)

Hi all, I am trying to setup a replication and it went smoothly up-to here, any ideas what I can do... SQL EXECUTE Dbms_Repcat.Create_Master_Repobject('TEST55', 'TESTHOST5', 'TABLE', gname='MYREPGRP',copy_rows=false);BEGIN Dbms_Repcat.Create_Master_Repobject('TEST55', 'TESTHOST5', 'TABLE',

Replication

Hi all, I have an environment where we are replication from Master to Slave a number of tables. But there is one table which needs to replicate also both ways. Currently I have setup snapshots/mviews master-slave, how I can implement this one table to be replicated also other way... rgds

RE: Replication

Peter, your reply was empty, could pls. send it again, maybe you have valuable information... rgds gb Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk --

Cache a table

Hi all, when you would consider to put a table a cache... rgds gb Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk -- Please see the official ORACLE-L FAQ:

RMAN question: couldn't execute cmd: no such file or directory

Hi all, I am trying to execute scheduled job via OEM console and the job fails with the following error couldn't execute "cmd": no such file or directory What might be the reason? rgds gbWant to chat instantly with your online friends? Get the FREE Yahoo! Messenger

Patch Set 3 Version 9.2.0.4.0 for Linux x86 that makes use of a buffer overflow

Hi, is there any workaround concerning this: http://packetstormsecurity.nl/filedesc/oracle_ownage.c.html TIA gbWant to chat instantly with your online friends? Get the FREE Yahoo! Messenger

Data Transfer between two instances

Hi all, we have an application which needs data from other environment (which is actually SAP db). Currently we have implemented it the way we create flat files and put them in using pl/sql -procedures but I don't like this because the data in the flat files are "visible" and it is somehow

Weblogic, thin driver and lob segments

Hi all, we are facing some serious problems with the following case: we have an application which stores quite a lot of documents to database (average document size is 2mb). Application loads document template from database and when we are having 100-200 hundred users there will be a queue on a

Statspack Report!

Hi all, could you please clarify me what these might mean (and how to tune the db in order to avoid those). So I have done a performance report with statspack and the instance is 9.2.0.3 on Solaris8 box. On a report there are a couple of issues I don't understand: Child Get Spin Latch Name Num

Move SQL Server Tables to Oracle

Hi all, I need to move some sql server tables to oracle. Do you have some ideas how to do it. I have no idea ... rgds GWant to chat instantly with your online friends? Get the FREE Yahoo! Messenger

How to speed up index creation

Hi all, we have a couple of huge tables and we have some performance problems while creating indexes. Here are some methods we already have tried, is there something else: Here's the list of features we already know: - Using NOLOGGING mode - Using PARALLEL option = PARALLEL 4(the server has 4

Net App Filer

Hi all, is anyone using Net App Filer -products with Oracle environment. What do you think? Advantages Disadvantages Thank you for your time gWant to chat instantly with your online friends? Get the FREE Yahoo! Messenger

ProAct with Oracle

Hi all, who has used ProAct products (NetApp Filer etc), with oracle with RAC and/or Linux. How do rate those and do you have any feedback or recommendations. All information is appreciated! rgds gWant to chat instantly with your online friends? Get the FREE Yahoo! Messenger