Search results for query: *

Hi, Sorry for the confusion. What I meant was querying from remote database located in different machine. For example: sqlplus xuser/xuser@DB_ONE sqlplus>select count(*) from xuser.mytable@DB_TWO; From local instance DB_ONE, I would like to query info from remote database DB_TWO without...

Hi all, How to connect to remote database without using DBlink? I've read somewhere over the internet that it's possible to do this. I forgot the website. It did say about truss/trusted connection. Any input???? Rgds, Suhaimi

Hi all, I would like to read each record from a ORACLE database using SQL and output each of the records into different output files. How do I do this in C program??? Thanks in advance, Suhaimi

Hi all, I created a db link and query a remote table. It's successful whenever I used @dbname.world but I got error ORA-02019 whenever I ommited .world from the query. Below are the details: create database link dbname connect to userA identified by userA using 'dbname.world'; I even try...

Hi, Thanks for the reply. Anyway, it is in Unix style. The problem is it does not list recursively when using ls -lR. Rgds, Suhaimi

Hi all, How do I configure the my FTP NT server so that ls -lR will return the listing recursively? Rgds,

Hi all, I would like to redirect the output in crontab, if and only if there's a string and remove the output file if the output is nothing. How I do that? Rgds, Suhaimi

hostA> rsh hostB "echo $SHELL" /bin/csh

Hi, I've read the man page but couldn't find anything about running local script against remote server. Rgds,

Hi all, How could I force setenv while doing rsh? Whenever I do this, hostA> rsh hostB "setenv ORACLE_SID TEMP;echo $ORACLE_SID" PROD8 it'll return something else not "TEMP". Suppose: hostA> rsh hostB "setenv ORACLE_SID TEMP;echo $ORACLE_SID" TEMP Please help...

Hi all, I wonder if we could run local script against remote server through rsh. example: hostA>ls myscript.csh hostA> rsh hostB "myscript.csh" Thanks, Suhaimi

Thanks so very much Tikual. It works perfectly. Rgds, Suhaimi

Hi all, How do I capture "CPU states" of Unix TOP in to a file??? 'top > myfile' will get all the details except "CPU states". Any imput??? Rgds, Suhaimi

I've tried to use snapshots b4. It seemed not updating after snapshot refresh. Could you give me the details how I could run the snapshot correctly ? Rdgs, Suhaimi

LogMiner 9.0.1 does not show CREATE table Hi, Why logminer does not show my CREATE table statement in 8.0.4 database??? Here are the details: In 8.0.4 database server. 1. as sys, run dbmslmd.sql (copy from 8.1.7 server) 2. as userA,create table dummy as select * from mytab where rownum <=100...

Sorry....we are using 8.0.4. Opening stdby db in read only mode is available ONLY in 9i if I'm not mistaken. Rgds, Suhaimi

Hi Dima, Your suggestions are accepted BUT how do I use RMAN to simulate the EXP/IMP ?????? Rgds, Suhaimi

Hi, For your info, the clone database acts as a historical db. We don't want people (mainly report users) to tap into our prod db. We have experienced the worst performance on our prod db server whenever we let them use it. That's the reason we need this historical db badly. We have limited...

Hi all, I wish to clone a database and keep it synch with primary. I've tried to use EXP/IMP incremental. The problem is whenever there is a change in a table, it'll export the whole table instead of the changed bit. As a result, I've to import the whole table again so that it'll synch with...

Hi, Here's another example of bytes > extent: NAME BYTES INITIAL_EXTENT NEXT_EXTENT BYTES-NEXT_EXTENT idx1 100024320 100007936 100007936 16384 idx2 100024320 100007936 100007936 16384 idx3 100024320 100007936 100007936 16384 idx4 100024320 100007936 100007936 16384 idx5 100032512 100007936...