RE: utl file limitations
The big question is if the tracing I need for 11i (i karumba) will work with this solution. I am waiting for Metalink to check it out. I also plan to test it this weekend on my TEST instance this weekend if I can get it from the users. I also plan on putting in a enhancement request for utl_dir. It IMHO should be able to handle /maindirectory/* Well back to submitting more tars on patches that don't work.. I love beta testing 11i... I love patching all night and submitting tars all day All I want for Christmas is 11i to work, 11i to work, 11i to work. Kathy -Original Message- Sent: Thursday, August 15, 2002 1:09 AM To: Multiple recipients of list ORACLE-L Kathy, This is probably not documented, but you can have multiple lines of UTL_FILE_DIR _anywhere_ as _long_as_ you bunch them all up without any gaps / lines inbetween them (in which case the last set overrides the previous ones). I have the following in a 7.3.4 Db, all at the end (and I bet that you are recognizing your favorite ERP system therein - Oops my version is showing :) # # VERY VERY IMPORTANT *** # *** Keep ALL lines for UTL_FILE_DIR *** # *** together at the end of the file *** # *** Otherwise only the last set is *** # *** effective *** # VERY VERY IMPORTANT *** # utl_file_dir = /u001/app/smartdb/files/data/AR utl_file_dir = /u01/home/arftp/edi utl_file_dir = /u01/home/xxusc4xx utl_file_dir = /u009/app//R10.7/xxloftware/loftware/error utl_file_dir = /u009/app//R10.7/xxloftware/loftware/log utl_file_dir = /u009/app//R10.7/xxloftware/loftware/processed utl_file_dir = /u009/app//R10.7/xxloftware/loftware I believe you will have to either name specific directories or use a single '*' (the latter is _not_ a good idea!) John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** I don't think it is possible for me to specify utl_file=/mymaindirectory/* in the init.ora and have files go into the subdirectories they need ot underneath. You would think you would be able to since you can specify *. Any takers on this one? Kathy Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathy Duret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: utl file limitations
This is fully allowed and support - it works with just about any of the "multi-value" parms. On more recent versions of Oracle you can see the parameters in this was using v$parameter2 even better - in 9.2, the utl_file_dir is no longer required. hth connor --- John Kanagaraj <[EMAIL PROTECTED]> wrote: > Kathy, > > This is probably not documented, but you can have > multiple lines of > UTL_FILE_DIR _anywhere_ as _long_as_ you bunch them > all up without any gaps > / lines inbetween them (in which case the last set > overrides the previous > ones). I have the following in a 7.3.4 Db, all at > the end (and I bet that > you are recognizing your favorite ERP system therein > - Oops my version is > showing :) > > # > # VERY VERY IMPORTANT *** > # *** Keep ALL lines for UTL_FILE_DIR *** > # *** together at the end of the file *** > # *** Otherwise only the last set is *** > # *** effective *** > # VERY VERY IMPORTANT *** > # > utl_file_dir = /u001/app/smartdb/files/data/AR > utl_file_dir = /u01/home/arftp/edi > utl_file_dir = /u01/home/xxusc4xx > utl_file_dir = > /u009/app//R10.7/xxloftware/loftware/error > utl_file_dir = > /u009/app//R10.7/xxloftware/loftware/log > utl_file_dir = > /u009/app//R10.7/xxloftware/loftware/processed > utl_file_dir = > /u009/app//R10.7/xxloftware/loftware > > I believe you will have to either name specific > directories or use a single > '*' (the latter is _not_ a good idea!) > > John Kanagaraj > Oracle Applications DBA > DB Soft Inc > Work : (408) 970 7002 > > Listen to great, commercial-free christian music > 24x7x365 at > http://www.klove.com > > ** The opinions and facts contained in this message > are entirely mine > and do not reflect those of my employer or customers > ** > > > I don't think it is possible for me to specify > utl_file=/mymaindirectory/* > in the init.ora and have files go into the > subdirectories they need ot > underneath. You would think you would be able to > since you can specify *. > > Any takers on this one? > > Kathy > > Confidential > This e-mail and any files transmitted with it are > the property > of Belkin Components and/or its affiliates, are > confidential, > and are intended solely for the use of the > individual or > entity to whom this e-mail is addressed. If you are > not one > of the named recipients or otherwise have reason to > believe > that you have received this e-mail in error, please > notify the > sender and delete this message immediately from your > computer. > Any other use, retention, dissemination, forwarding, > printing > or copying of this e-mail is strictly prohibited. > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: John Kanagaraj > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "Remember amateurs built the ark - Professionals built the Titanic" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: utl file limitations
Kathy, This is probably not documented, but you can have multiple lines of UTL_FILE_DIR _anywhere_ as _long_as_ you bunch them all up without any gaps / lines inbetween them (in which case the last set overrides the previous ones). I have the following in a 7.3.4 Db, all at the end (and I bet that you are recognizing your favorite ERP system therein - Oops my version is showing :) # # VERY VERY IMPORTANT *** # *** Keep ALL lines for UTL_FILE_DIR *** # *** together at the end of the file *** # *** Otherwise only the last set is *** # *** effective *** # VERY VERY IMPORTANT *** # utl_file_dir = /u001/app/smartdb/files/data/AR utl_file_dir = /u01/home/arftp/edi utl_file_dir = /u01/home/xxusc4xx utl_file_dir = /u009/app//R10.7/xxloftware/loftware/error utl_file_dir = /u009/app//R10.7/xxloftware/loftware/log utl_file_dir = /u009/app//R10.7/xxloftware/loftware/processed utl_file_dir = /u009/app//R10.7/xxloftware/loftware I believe you will have to either name specific directories or use a single '*' (the latter is _not_ a good idea!) John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** I don't think it is possible for me to specify utl_file=/mymaindirectory/* in the init.ora and have files go into the subdirectories they need ot underneath. You would think you would be able to since you can specify *. Any takers on this one? Kathy Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
utl file limitations
database 8.1.7.3 Has anyone run into and knows a work around for utl file limitations. Specifically, we have many directories we need to write to over 512 bytes but the problem is if we need to run a session trace , we can only have 256 bytes and the directory that the trace file goes to is the last one specified in the utl_file. So currently we are having to change our utl_file, bounce the system, do our trace and set it back again and bounce again. Which to me is unacceptable. I understand there is a way to set up multiple utl_files, but I can't seem to find any info on it. And would I be able to trace I don't think it is possible for me to specify utl_file=/mymaindirectory/* in the init.ora and have files go into the subdirectories they need ot underneath. You would think you would be able to since you can specify *. Any takers on this one? Kathy ConfidentialThis e-mail and any files transmitted with it are the propertyof Belkin Components and/or its affiliates, are confidential,and are intended solely for the use of the individual orentity to whom this e-mail is addressed. If you are not oneof the named recipients or otherwise have reason to believethat you have received this e-mail in error, please notify thesender and delete this message immediately from your computer.Any other use, retention, dissemination, forwarding, printingor copying of this e-mail is strictly prohibited.