Recent content by Sambo8

Hi There T, Yes it was a success - many thanks for your help! Cheers, Sam

Hi all, Many thanks for your help it needs to be a procedure as I need to schedule it as a job. Thank you Sam

Hi there, I want a procedure to do the following: update table1 set eventstate='Processed' where eventstate='Processing' and eventstarttime < sysdate-30; here is my invalid procedure - please can you tell me where I'm going wrong? create or replace procedure update_processed DECLARE estate...

Hi there, I'm having a problem with my procedure I want to execute an alter trigger for every tablename in the audittables table concatanate the AUA to the tablename. Here's my code: Create or Replace procedure samtest.disable_trigs IS tabname IN varchar2(30) Begin select...

Hi There, Does anyone know of a way to purge log_history by status? I want to use the dbms_scheduler.puge (log_history thing to purge all succesful jobs? Many thanks, Sam

Hi There, Thanks for you assistance, I hadn't found anything either and wanted to double check I hadn't overlooked , it was a request from the client to keep inline with their windows security policy. Cheers, Sam

Hi There, I'm looking for a way of stopping a user from changing their password more than once in a day. So the password has to have a minimum age of 1 day. Any ideas? Many thanks, Sam

Hi all, I want to run a datapump import using multiple schemas. Is there a way of doing multiple schemas but norows to 1 or 2 tables? e.g. SCHEMAS=SCHEMA1, SCHEMA2 TABLES=SCHEMA1.TABLE2:norows Cheers, Sam

Hi All, Please ignore my above post, I found the problem was actually the if beginning above the functions with the fi below. Apologies. Sam

Hi there, Please can you take a look at my script, my other functions work fine but funcB gives the error: [55] funcB: not found. #!/bin/ksh CURRENTDAY=$(cat hello) echo $CURRENTDAY VAR=$(date +'%a') echo $VAR if [ $VAR = $CURRENTDAY ] ; then echo 'Matched' ################# function funcA...

Hi there, The following is my script: #/usr/bin/ksh # this gets yesterdays day SAM=$(TZ=CST+24 date '+%a') echo $SAM ERROR1=$(echo "Email backup not run PLEASE CHECK") ERROR2=$(echo "Error in backup see backuperrordetails.log for details") find /u01/app/oracle/work/sam/backup/backup.$SAM...

Hi there, I want to know if a file exists that has been touched in the last 30 mins. mmin and amin do not work on the server so I was trying to touch a file and find a file if it was newer than that file as follows: find /u01/sam/test/hello.txt -newer timelastrun.txt echo "no error" but I...

Hi There, I haven't done a lot of scripting so I'm struggling - any help muchly appreciated. Brief explanation below incase there is an easier way to do this? I have a script that runs through a list of files created within the last day and greps Error it then outputs that line to results.lst...

Hi Mufasa, Many thanks the directory didn't contain modplsql only Jserv and Apache. so no modplsql for that DB. Fantastic, Thanks you Sam

Hi There, I'm guessing this is a dumb question, is there anyway you can tell if your database is utilizing mod_plsql? Cheers, Sam