Search results for query: *

Hi- I m having a problem with sending e-mails using mailx command. On executing the command for users in external domain, I get: The following recipient(s) could not be reached: '<user>@<external_domain>.com on 11/08/2007 11:11 AM 550 5.7.1 Unable to relay for <user>@<external_domain>.com...

Perfect again! Good learning. Thanks a ton.

Can please suggest the command if ' should be modified to \' (instead of /' as mentioned earlier)? I tried str=$(echo ${str}|sed "s:':\':g"): but it is of no help.

Perfect! Thanks a ton!

The code returns bad substitution. PS: Not too sure on how to change the forum. If you can, please do it for me.

Hi, Am using Ksh and have the string in a variable. The string contains ' and would like to append / before same. So ' should be replaced as /'. Please advise. Thanks, Sachin

Bingo !!!.... Did the trick. Thanks a ton.

I have similar requirement: I have 3 columns in a pipe seperated file. Second column in this file should be limited to 20 characters. I am using AWK script to read this file and like to cut/fold/anything else within awk.... Please help.

Does someone has experience with Materialized Views? I am new to this and have created such views for some queries (response time > 60 sec). Issue is: MV works well right after it is created and we get very good response time (< 10 sec). But if query is performed after sometime (say ~3 hrs...

Sure. This is very BIG table and have ~50 GB in tablespace.

Hi, I have large table will following storage parameters: INITIAL 2000M MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT Would like to change (NEXT and MAXEXTENTS) to: INITIAL 2000M NEXT...

Is it possible to avoid newfile_2? Ofcourse I can mv newfile_2 file_2 but it would be much cleaner if can avoid newfile_2 and update file_2.

Bingo. It works great !!! Thanks PH, Sachin

Pipe "|"... Guess, I should have mentioned it in first place.

I tried this in the command prompt. It generated newfile_2 BUT exactly same as file_2. As I said, I like to update first column of file_2 with second column of file_1.

Hi, Please see if someone can help me on this: I have two files: - file_1 (col_11, col_12) and - file_2 (col_21, col_22, col_23 ...) Of these, file_1 is master file and is used to update data in file_2. How to update? Read first column of file_2 (col_21) and compare it with second column...

BINGO !!! ...WHERE (col2 = v_programVariable1 or col2 is null) and col3 = v_programVariable2 or col3 is null) Was enough to do the trick. Thanks Man. You are great !!! Cheers, Sachin

Please read original query as: CURSOR curMyTable IS SELECT col1 FROM MyTable WHERE col2 = v_programVariable1 AND col3 = v_programVariable2; I verified. Two cursors resolve the problem: CURSOR curMyTable1 IS SELECT col1 FROM MyTable WHERE col2 = v_programVariable1; CURSOR curMyTable2 IS SELECT...

Hi, I have a cursor on table: CURSOR curMyTable IS SELECT col1 FROM MyTable WHERE col2 = v_programVariable1 AND col3 = v_programVariable1; As per business condition, either one of v_programVariable1 and v_programVariable2 has to be NULL. Wonder If my curosr is OK? What I see is, cursor fails...

Thanks Guys. It works great! Cheers, Sachin