Jonathan's Book again (WAS) Re: Delete followed by Select Count(1) - SLOW

of the book. In the first chapter, he talks about delayed_logging_block_cleanout and what's going on. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Galen Boyer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Re: table create vs alter

migrated or chained. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Galen Boyer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: changing long col to varchar and vice versa

://www.orafaq.com -- Author: Galen Boyer 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

Re: Urgent Pls Help

the characters. Whew! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Galen Boyer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Usage of Number type for table columns

shouldn't rely on the DB's protection to get it correct. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Galen Boyer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Platform dependency on released connections (WAS) Re: user holding session even after a re-boot

On Wed, 15 Aug 2001, [EMAIL PROTECTED] wrote: Guess the bottom line is the behavior of a released connection is platform dependent. What do you guys think? I would hope this isn't the case. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Galen Boyer INET

Profile Usage Curiosity (WAS) Re: user holding session even after a re-boot

application. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Galen Boyer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: characterset problem

byte characters to a multi-byte character can confuse lengthb? What does this query return? select lengthb(casename), lengthb(caseName||'X') , lengthb('X') from case where casepin=736; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Galen Boyer INET: [EMAIL PROTECTED

Re: No TNSListner service after intall 8.1.7 on Win 2k

thought it might have to do with the '_', so I created a dummy environmental variable, TEST_VAR = hello_there, and it was echoed bach when I entered, echo %TEST_VAR% -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Galen Boyer INET: [EMAIL PROTECTED] Fat City Network

Re: FW: [Fwd: Help scheduling Hot Backup on NT...]

on one workstation. Very slick. Now combine that with ntemacs and you really are part of a cult :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Galen Boyer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Re: Which view maintain droped constraint record?

/oracle8i/doc_library/817_doc/server.817/a76961/toc.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Galen Boyer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Re: characterset problem

you after all here. Sorry about that. I have no experience with OAS. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Galen Boyer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Re: Please Help - ora error

additional space | to the tablespace or retry with a smaller value for INITIAL. ` -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Galen Boyer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: 8.1.7/HP-UX 11/Package Question #2

a hint? I believe this should suffice. http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a77069/08_packs.htm#362 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Galen Boyer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

Re: No TNSListner service after intall 8.1.7 on Win 2k

create the entry: ORA_MINE_PFILE = c:\mine\initMINE.ora So what is this registry entry used for? Registry entries have any use? :-) And why do I need to place the init.or under %ORACLE_HOME%\pfile Not sure here. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Galen

Re: Which view maintain droped constraint record?

specific statements. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Galen Boyer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: auditing ... getting offending SQL ??

On Mon, 13 Aug 2001, [EMAIL PROTECTED] wrote: Who is the vendor for EZSQL? Do you have a web site for them? www.google.com, type in ezsql and the first thing you get is http://www.ezsql.net/ -- Galen Boyer It seems to me, I remember every single thing I know. -- Please see the official

Re: Datafile Migration Tool

, but most people will probably stick with export -- ftp -- import. I guess if it were actually pretty solid, you might get it bought by Quest of one of those guys. -- Galen Boyer It seems to me, I remember every single thing I know. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Re: BEQ used for remote connections

operation that a | remote network listener does for your connection, yet locally. | | Bequeath is used for local connections where an Oracle client | application, such as SQL*Plus, communicates with an Oracle server | running on the same machine ` -- Galen Boyer It seems to me, I remember every

Re: dimension time question

quarters with just straight arithmetic. Then, each one of the columns could have this extra column for good measure. If users want to see data for a year, they will specify it. -- Galen Boyer It seems to me, I remember every single thing I know. -- Please see the official ORACLE-L FAQ: http

Re: New (sort of) Oracle parameters

On Tue, 14 Aug 2001, [EMAIL PROTECTED] wrote: 07_DICTIONARY_ACCESSIBILITY ORA_ENCRYPT_LOGIN What version of Oracle are these two available? I can't find them in the online documentation. http://hojohn.photo.net/ -- Galen Boyer It seems to me, I remember every single thing I know

Re: ORA-06502

On Tue, 14 Aug 2001, [EMAIL PROTECTED] wrote: How can I resolve this error? Error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small Make it bigger. -- Galen Boyer It seems to me, I remember every single thing I know. -- Please see the official ORACLE-L FAQ