Search results for query: *

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

Hi All, I'm doing an oracle install and solaris and trying do define if there is enough available swap however swap -l tells me that there is 14g available out of 15g where swap -s seems to say that there is less than 3g available by doing a divide by 2 for blocks is that correct? what is the...

Hi There, I'm getting the following error in my alert log: 2007/07/25 Wed 00:01:24 ORA-16166: LGWR timed out on Network Server 0 due to buffer full condition. 2007/07/25 Wed 00:01:24 ORA-16166: LGWR network server failed to send remote message 2007/07/25 Wed 00:01:24 ORA-16166: LGWR network...

Hi All, I have an issue with an ORACLE 9i Database that has been configured by an external application to use rollback segments. I want to know what the process is to convert this to use UNDO? Many thanks, Sam

Hi there, THis may be a dumb? but I've hardly touched 10g is there anyway of finding out what time of day the undo tablespace is getting the most transactions? Cheers Sam

Hi there, I am not a unix scripter, however I have been given the task of amending the following so that it stores a daily log result: mailx -s "`hostname`:$ORACLE_SID Commit Count for `date`" g.blah@blah.com,j.blah@blah.com </tmp/commitCount.log currently this emails to two addresses and...