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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by melsterTEK

  1. melsterTEK

    Outline to install ASM with oracle 10gR2

    Has anyone installed oracle ASM? I am sort of confused on what steps to take to install the instance. For example, I've installed asmLib and created/marked by disks to be added to a group. What is the next step? Install the software in its own home ==> run the dbca ==> create an asm instance ==>...
  2. melsterTEK

    Sample oracle 10g create database script

    Hey Mufasa, Thanks for your help on this. It was very helpful. Are there any other standard scripts that need to be run when using 10G? For example in oracle 9i, I also had to run these scripts: JServer.sql ordinst.sql interMedia.sql context.sql xdb_protocol.sql...
  3. melsterTEK

    Sample oracle 10g create database script

    Thanks Mufusa. Would have a sample of your init.ora param settings? This is for a lightweight db. I'm actually creating a repository for rman catalog. So, I would just need barebone settings for a small db. Thank you.
  4. melsterTEK

    Sample oracle 10g create database script

    Mufasa, Would you have a sample that configures the SYSAUX tablespace? I think this is new to 10g. Thanks.
  5. melsterTEK

    Sample oracle 10g create database script

    Hi Mufasa, This would be for unix. I'm trying to create a db on Linux platform. Thanks.
  6. melsterTEK

    Sample oracle 10g create database script

    Hello. Can anyone share a standard create database script for oracle 10g? I tried using my old oracle 9i scripts and I am finding there are some gotchas with creating a db in 10gR2. Thanks.
  7. melsterTEK

    Using date format as a regular expression

    Thank you MillerH for your tips.
  8. melsterTEK

    Using date format as a regular expression

    I think I worked it out... (@date)=localtime; $date[5]+=1900;$date[4]++; $today=sprintf("%0.4d-%0.2d-%0.2d",$date[5],$date[4]++, $date[3]-1); # fetch rows while (($errorlog, $continuationrow )= $sth->fetchrow_array( )) { if ($errorlog =~ /$today/) { if...
  9. melsterTEK

    Using date format as a regular expression

    Can you show me how to write that? I'm still unclear on how to plug this in. Thanks. Looking at the sample from perl doc: # Format number with up to 8 leading zeroes $result = sprintf("%08d", $number); # Round number to 3 digits after decimal point $rounded = sprintf("%.3f", $number)...
  10. melsterTEK

    Using date format as a regular expression

    Hi I need help in writing this perl code for matching a string with today's date. I have the following code that gives me date: #!/usr/bin/perl ($sec,$min,$hour,$mday,$mon,$year,$wday, $yday,$isdst)=localtime(time); printf "%4d-%02d-%02d\n", $year+1900,$mon+1,$mday; Result => 2007-02-20 I...
  11. melsterTEK

    Using sendmail for attachments

    I think it would work. Let me know if you are able to test it.
  12. melsterTEK

    Using sendmail for attachments

    Hi, I found this a lot easier to work for me. http://www.perl.com/pub/a/2003/09/03/perlcookbook.html?page=2 Here's my code: # # using sendmail and mailing an attachment # $msg = MIME::Lite->new(From => 'youremailhere', To => 'youremailhere'...
  13. melsterTEK

    Using sendmail for attachments

    Does anyone now how to use sendmail for sending an attached file? Is sendmail good for this purpose?
  14. melsterTEK

    Help creating CSV file based on varying value conditions

    Hi Kevin, For curiosity, how would you do this using split?
  15. melsterTEK

    Help creating CSV file based on varying value conditions

    You're right. I might just change the delimiter back to double quotes or use a "|" or tab for that matter. Neat exercise. You taught me a lot today! Thanks again. ;-> -btw how do I used that "code" box? I can't seem to find a link to post code.
See more

Part and Inventory Search

Back
Top