Recent content by suhaimi

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...