RE: Should we stop analyzing?

2004-01-08 Thread Wolfgang Breitling
not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -- Author: Pete Sharman INET: [EMAIL PROTECTED] Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author

Re: Trigger Question

2004-01-08 Thread Wolfgang Breitling
(or that table for that matter) in either the trigger or any called package or procedure. You'll get a mutating table error. Thanks, N. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

RE: Trigger Question

2004-01-08 Thread Wolfgang Breitling
, 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). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see

Re: Hotsos Symposium Dinner

2004-01-09 Thread Wolfgang Breitling
. Gary (817)424-3443 Office (817)296-8000 Cell Hotsos Symposium 2004 - March 7-10. http://www.hotsos.com/appearances/sym2004.php Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

RE: Should we stop analyzing?

2004-01-12 Thread Wolfgang Breitling
) to them. At 02:19 PM 1/12/2004, you wrote: P.S. whilst the above is fictitious they do care about %utilisation of bandwidth but not response time from remote sites, God that irritates me. Author: Niall Litchfield INET: [EMAIL PROTECTED] Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting

Re: Partitioning question (duplicate?)

2004-01-14 Thread Wolfgang Breitling
to accomplish this without changing the data structures. Daniel Fink -- Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network

Re: Connection Problem

2004-01-16 Thread Wolfgang Breitling
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). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex

Re: advice

2004-01-19 Thread Wolfgang Breitling
At 07:59 AM 1/15/2004, you wrote: What else can I suggest to help them collect data that will be informative? My business card ;-) Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

RE: tnsnames.ora not working ?

2004-01-20 Thread Wolfgang Breitling
] (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). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting

Re: [Q] create tablespace with different block size error???

2004-01-24 Thread Wolfgang Breitling
, like, for instance, block size. If he rearranges the statement, he'll get the right error. -- Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET

Re: query plan is bad when it is run inside a pl/sql stored

2004-01-27 Thread Wolfgang Breitling
to be removed from). You may also send the HELP command for other information (like subscribing). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET

Re: ORA-01722 invalid number

2004-01-30 Thread Wolfgang Breitling
or expressions. Only numeric fields may be added to or subtracted from dates. Action: Check the character strings in the function or expression. Check that they contain only numbers, a sign, a decimal point, and the character E or e and retry the operation. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA

<    1   2   3