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

...'Matched' ################# function funcA { CURRENTDAY=$(cat hello) echo $CURRENTDAY if find /u01/app/oracle/work/sam/backup/again/errorexists.*.$CURRENTDAY -mtime -1 -print; then exit else funcX fi } ################# function funcB { if find...

...0 ]] then find /u01/app/oracle/work/sam/backup/backup.$SAM -mtime -1 -print | xargs grep Error | while read LINE do FILE2=$(echo $LINE | sed 's/.* see //;s/ for details//') echo $FILE2 [[ -f "$FILE2" ]] && tail -5 $FILE2 || echo "($FILE2 not found)" echo $FILE2 VAR=$(echo $FILE2 | cut -c2-4)...

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

...runs through a list of files created within the last day and greps Error it then outputs that line to results.lst as follows: find /sam/test/blah* -mtime -1 -print | xargs grep Error >> results.lst My results file holds the following info: /u01/sam/blah.Sun:29/10/2007 10:17:23 Script 1b...

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