Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Sambo8
  • Content: Threads
  • Order by date
  1. Sambo8

    Help creating procedure

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

    Procedure compilation errors

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

    dbms_scheduler puge by status

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

    [B] Password Verfication help [/b]

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

    IMPDP multiple schemas with table options

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

    Function not found error

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

    please help newbie to scripting

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

    AIX alternative to mmin or amin

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

    help pulling a string from a file

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

    how to tell if mod_sql is in use?

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

    simple date query in ksh

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

    Remove OLD STATS

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

    ORACLE DB to MYSQL

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

    Number of Queries per day

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

    SGA and ORACLE TEXT

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

    swap -l v's swap -s

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

    alert log shows error relating to network buffer

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

    Converting rollback segs to undo

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

    10G and Undo

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

    Storing Text File Log

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

Part and Inventory Search

Back
Top