Search results for query: *

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

Hi There, I'm very new to ksh I have a script that goes into a folder that begins with a date and creates a file as follows: #!/usr/bin/ksh cd /work/sam/$(date +%Y%m%d) touch hello.txt this works to create a file called hello.txt in the path /work/sam/20080508/ now I want that to be minus 3...

Hi There, I think there is a script to remove old stats from the STATS tablespace, e.g older than 1 month. But cannot find it anywhere. Does anyone know of such a script. Many thanks, Sam

Hi There, I'm after a bit of assistance. Has anyone migrated an oracle DB to mysql? the task in hand is to migrate over a terabyte of partitioned data so that it can be stored and accessed (probably rarely) for upto a year. Is mysql a feasible option for this? Can the migration toolkit...

Hi All, Is there a way of finding out the number of sql queries run against a 9i database in a day? Many thanks, Sam

Hi All, Is there any documentation showing whether installing Oracle Text requires more SGA? Many thanks, Sam