Recent content by wchuacs

THanks.

Hi, I would like to find the command in Win2K dos on the FTP utility in one command line with user/password auto-login to one ftp site (win2k also) Then I will embeded into a DOS script to do a hugh 700GB files transfer job. anyone has any idea? thanks, CS

I have Oracle8i and Oracle9i base but local database only running on Oracle8i, no database runs on 9i yet. I have started the local ORCL 8i database and then login to Oracle Fail Safe Manager v332. Below are the all bottom parts of error messages I captured during verifying standalone...

SQL> !touch /tmp/tempfile SQL> !ls -l /tmp/tempfile -rw-r--r-- 1 0 Apr 29 18:59 /tmp/tempfile SQL> !settime usage: settime [-f file] [mmddhhmm[yy]] file... SQL> !settime 0428000104 /tmp/tempfile SQL> !ls -got /tmp/tempfile -rw-r--r-- 1 0 Apr 28 00:01 /tmp/tempfile thanks &...

No rows returned means the table you selected has no data. Isn't that obviously? If you have no problem connecting to database. Please tell us what userid you used to connect.

Hi, how to we insert say 500 or 1000 rows of records in a test table for some scenarios testing ? pls advice, and thank you.

Hi, Sometimes there are some sessions hanged and need to kill them off. But how to get their sql statements (to know whether is doing SELECT,UPDATE,DELETE, etc...)? I know there is a table v$sqlarea, and below is my simple query: SQL> select executions, disk_reads, buffer_gets, sql_text from...

Hi, If you have installed the Ora816 and the OEM (Oracle Enterprise Manager) also, please make sure that your tnsnames.ora in your OEM_Home/network/admin directory is the same exact tnsnames.ora in your ORADB_Home/network/admin. Also copy your sqlnet from oracle home to oem home. Hope this...

Hi, We have same databases one for Production and the other is our Development. There is a need to once a while refresh our Development schemas to have the most current data. My questions are: 1) besides export/import, what else methods can be used? 2) what options required when doing EXP, like...

Hi, Thanks for the great and easy to understand inputs.

Hi all experts, I have a script and here is a part of the script, I am still a learner and don't understand this, pls help to explain what this part of script is trying to do ? if [ $# -ge 2 ]; then if [ "$2" != "x" ]; then CONSTR=$2; export CONSTR...

Hi all, I set some cron jobs and when those jobs done, mails always sending to the user. When I login using the user, the message "You have new mail." appears... Is there any setting leads to this kind of feature turned on ? How to turn it off ? the mails stored in /var/spool/mail I...

Thanks for you all guys so helpful and being discussing about the faq I posted here. thanks & regards, CS

I just open it as normal double-click on the icon file. Dreamboat, I thought there is a way to set it like Excel.... OK, since it's working this way, why not you send me the template and see if I have any problem with your template or not. thank you. thanks & regards, CS

Hi all, How to make word doc file opened in one window frame only ? Currently if I open 3 doc files, there will be 3 Word windows in desktop.... thanks thanks & regards, CS