Re: Compare Index on Number Varchar2
I had a similar question a while back. Specifically my question was, is it faster to join on a numeric-based index or a varchar(2) based index. After much research, and a discussion with an Oracle PT friend of mine, the answer was/is: It depends. There is no right answer; your results will vary based on your specific situation and your data. suggestion: create both test cases, set on the autotracing and timing, and compare results. boss One of the column in a new table can be ename - varchar2(20) or hase_code_e= name - number(11) =96 Hash Code generated by JAVA. =0AWe are going to creat= e non-unique index on this column as one frequent query will have where cla= use on this column only. Choice is either varchar2(20) or number(11).=0A1.= Is Non-unique index on Number is faster then varchar2? Why?=0A2. If Number = column has negative values, then will it affect performance of Non-unique i= ndex on it? =0A3. How much space Number Varchar2 consume? i.e storage spa= ce difference between number(10) and varchar2(10)=0A=0ATillu=0A=0A --Next_1070355278---0-202.54.124.178-31576-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: sahil patel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Boss INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Development vs. Production DBA
I don't know about a paper, but I've always made a distinction between these types of DBAs as well. Development DBA responsibilities: - initial DB design - data modelling, data dictionary creation - naming standards, datatype standards - sql development - working w/ front end developers, tuning queries - data load, legacy to current Production DBA responsibilties: - day to day administrative support: adding users, creating schemas, moving objects around - backup/recovery - disaster recovery - monitoring - Troubleshooting, working with Oracle Tech Support - Database PT concerns: buffer pools, tablespace objects, etc. I would NOT force developers to funnel through the DBA to create objects in development. What a roadblock that could be. Instead, have the dba be available as a resource to the developers to handle query tuning concerns, answer SQL questions and the like. my 2 cents. Boss Group, If this was discussed before, I missed it. There is a discussion going on trying to define the duties of a development vs. production DBA and where in-depth DBA involvement should occur. Is there any papers that anyone can share w/me on this subject. IMHO a DBA should be involved early on in the project to translate the functional requirements into a physical model using the features of the target version. I also think that it should be the DBA's job to create the packages, procedures and triggers in the development and testing phases. To me,this would facilitate the transition from testing to production. Our development DBA's are involved in the production side so are aware of our standards. Comments, opinions please. TIA Al Rusnak DBA - WEB Team/CISIS, Computer Operations * 804-734-8371 * [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rusnak, George A. (SEC-Lee) CTR INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Boss INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
sort_area_retained_size sizing?
Hello all. I'm analyzing an Oracle 8.1.7 server (running over Solaris 5.8) and noticed they've increased the sort_area_size. SQL show parameter sort_area NAME TYPEVALUE --- -- sort_area_retained_size integer 65536 sort_area_size integer 4194304 SQL However, they have NOT increased the corresponding _retained_size. I've gone looking for guidelines/info to assist in tuning this particular parameter, but am getting conflicting information. - In a post by guru Howard J. Rogers to c.d.o.s. regarding a thread where someone specifically asks how to configure these two parameter, He states that he typically configures these two parameters to be the same (but offers no real reason why). - The concept guide in the Oracle Doc set though seems to indicate that each user performing a sort grabs sort_area_retained_size worth of memory, and thus recommends NOT sizing it the same as sort_area_size on systems with a large number of concurrent users. Any thoughts? Todd -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Boss INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: datamodelling question: updating foreign keys
I don't know if this is a better model at all. In fact, all this accomplishes is leaving behind tons of useless records. I'd only recommend this model if (for any reason) the trail of the truck history for this cargo. This way of marking records also leaves you open for the obvious future problem of inconsistent handling of records. Where some programmers don't know about this deleted flag and just go ahead and update the records directly as you normally would. Lets go back to the original question. Why does doing a simple foreign key update coause contention? If you have an index on your FK column in the child table, the update on the child table can use the index to find the PK record quickly, and the update goes on as planned. Where's the contention? Todd Yes. There is a better way to model that. Oh, you wanted a suggestion. How about including a LOADS table that has (at least) 3 colums truck_id cargo_id active_flag That way when cargo is moved to a different truck you add a new record to the LOADS table and update the old one (setting the active_flag to false) Kevin -Original Message- Sent: Thursday, November 06, 2003 9:45 AM To: Multiple recipients of list ORACLE-L I remember seeing this question asked on another forum some time back. I dont like the solution the guy had and Im wondering how some of you might solve problem. Im giving a low level generic example. Lets say you have a parent-child relationship. The parent table is 'TRUCKS' and the child table is 'CARGO'. The foreign key to CARGO tells which truck the cargo is loaded on. When the cargo is moved to another truck, the foreign key is updated. I dont like this approach. it causes contention. what is a better way to design this? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Toepke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Boss INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: How do you genrate primary keys?
? * Stored sequences. I worked on one app that used a separate sequence for each automatically generated primary key. I worked on another app, a smaller one, that used the same sequence for more than one table. The only issue that I recall is that sometimes numbers would be skipped. But end users really didn't care, or even notice. * The SYS_GUID approach. I've never used SYS_GUID as a primary key generator. I wonder, was that Oracle's motivation for creating the function? Has anyone used it for primary keys in a production app? What's the real reason Oracle created this function? * Similar to SYS_GUID, I once worked on an obituary-tracking application that built up a primary key from, as best I can recall now: date of death, part of surname, part of first name, and a sequence number used only to resolve collisions, of which there were few. The approached worked well, actually, because whatever fields we munged together to generate a primary key gave us a unique key the vast majority of the time. The SYS_GUID approach is interesting, but if you need an ID number that users will see, and that users might type in themselves (e.g. social security number), is SYS_GUID really all that viable? Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Boss INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: converting sybase stored procedure into oracle sp
Perhaps Oracle Migration Workbench (OMWB) is something you could look at. As I understand, it converts Sybase stored procs to oracle functions by default (since Sybase stored procs can return a result set, but Oracle Stored procs cannot). Todd Hi List, Does oracle provide any utility to convert sybase stored procedure into oracle stored procedure. In OTN I found some document which docs about conv72 which was distributed with oracle 7.2v. I dodn't see nything similar in oracle 8i or 9i. Does anyone have any idea or experience on this? Any 3rd part tool or something? Thanks Sami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saminathan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Boss INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: OT: Need help with SQL*Server
Sure; bcp is pretty straightforward. It can handle all sorts of formats on the data file (much more flexible than exp/imp or sql*loader in my experience) I maintain a sybase dba page here: www.bossconsulting.com/sybase_dba Click on my personal faq link then scroll down to the bcp specific pages. there's a few topics in there that you may find interesting. the basic commands are pretty easy: % bcp database..table in/out datafile.csv -Uuser -Ppassword -Sservername -c (-c tells you ascii mode). You can also specify a control file, if the data isn't in the most pristine format. You can also create a test target table for your data on sybase , do a test bcp OUT to get a copy of the control file. Or insert a test record, bcp THAT out and see how bcp expects the data to be formatted. I suggest taking this offline if you want further help. hope this helps, boss OK folks I'm out on the dark side, once again. Does anyone remember how MicroSlop's BCP utility in SQL*server works? I've got a user who bought a third party SQL*server application, I won't go there, and he needs to move some data from a desktop to a laptop SQL*server database. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Boss INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: proc to pl/sql
BR BR BR PBFONT SIZE=3D2 FACE=3DArialThe contents of this e-mail are = intended for the named addressee only. It contains information that may = be confidential. Unless you are the named addressee or an authorized = designee, you may not copy or use it, or disclose it to anyone else. If = you received it in error please notify us immediately and then destroy = it./FONT/B /P BR --_=_NextPart_001_01C39F0A.3F044680-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Boss INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Re[2]: What happened to Howard Rogers ?
Sounds like a management decision, not a corporate one. As in, a shortsighted, inflexible, incapable of seeing the forest for the trees, slave to the bureaucracy type manager. Not that you ever see managers like that... ;-) boss Monday, October 27, 2003, 12:09:25 PM, you wrote: DW But as a DW consequence of the discussions with his management chain, he ended up DW agreeing to resign. Odd. It must be really important then, when you have a brilliant and innovative employee capable of inventing something unique, to have him go work for some other company, possible even a competitor. I never would have come up with that strategy, and no doubt that's why I'm not executive material. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Boss INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: VPN to database?
I can tell you right now, i'm VPN'd to a client overseas and have NOT been able to get OCI to work over the protocol. I can telnet/ssh to the machine where the Oracle server runs (its Solaris) and work via a sql*plus window, but nothing runs locally (i.e., Toad or windows version of sql*plus connected to the remote server). If there's some secret to making OCI work over VPN, we were not able to find it. boss We are an Application Service Provider--we maintain a set of servers in a colocation facility and our customers use our application via the Web. Security is a paramount concern, of course, and only our Web server has a public IP address, with the application and database servers completely private. We supply a number of standard reports, but most of our customers want some custom reports as well. We would like to give them access to our database, possibly over a VPN, but only if security can be maintained. I'd like to know if anyone has faced such a situation, and what kind of configuration (network/firewall/VPN/Oracle Net) might make such access possible. TIA, = Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Boss INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: VPN to database?
No, but (and forgive me for asking) why does that matter? Is sqlnet tunneling important for security reasons, or important for connectivity? I'm able to telnet to the box straight away. I figured that, once VPN was connected, I'd be able to run whatever applications I wanted locally. After not being able to get any Oracle client to connect, i wondered if VPN had the capability to transmit anything but the lowest level of tcp/ip protocols. boss Are you tunneling sqlnet through ssh? http://www.akadia.com/services/ssh_install_and_use.html On Fri, 2003-10-24 at 08:44, Todd Boss wrote: I can tell you right now, i'm VPN'd to a client overseas and have NOT been able to get OCI to work over the protocol. I can telnet/ssh to the machine where the Oracle server runs (its Solaris) and work via a sql*plus window, but nothing runs locally (i.e., Toad or windows version of sql*plus connected to the remote server). If there's some secret to making OCI work over VPN, we were not able to find it. boss We are an Application Service Provider--we maintain a set of servers in a colocation facility and our customers use our application via the Web. Security is a paramount concern, of course, and only our Web server has a public IP address, with the application and database servers completely private. We supply a number of standard reports, but most of our customers want some custom reports as well. We would like to give them access to our database, possibly over a VPN, but only if security can be maintained. I'd like to know if anyone has faced such a situation, and what kind of configuration (network/firewall/VPN/Oracle Net) might make such access possible. TIA, = Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Boss INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Boss INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: VPN to database?
I don't know. After hearing the explanation, it very well may be. Our network guy is out (honeymoon). And my experience w/ VPN is slim. For some reason I never considered it to be just another protocol but rather to be a magical way that I could just appear to be on the local net to all these machines. I'll suggest the ssh tunnelling option. Todd Boss (sorry, I sometimes get colloquial and just sign my last name) Boss Is this a firewall issue? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, October 24, 2003 10:45 AM To: Multiple recipients of list ORACLE-L I can tell you right now, i'm VPN'd to a client overseas and have NOT been able to get OCI to work over the protocol. I can telnet/ssh to the machine where the Oracle server runs (its Solaris) and work via a sql*plus window, but nothing runs locally (i.e., Toad or windows version of sql*plus connected to the remote server). If there's some secret to making OCI work over VPN, we were not able to find it. boss We are an Application Service Provider--we maintain a set of servers in a colocation facility and our customers use our application via the Web. Security is a paramount concern, of course, and only our Web server has a public IP address, with the application and database servers completely private. We supply a number of standard reports, but most of our customers want some custom reports as well. We would like to give them access to our database, possibly over a VPN, but only if security can be maintained. I'd like to know if anyone has faced such a situation, and what kind of configuration (network/firewall/VPN/Oracle Net) might make such access possible. TIA, = Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Boss INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Boss INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Oracle pricing ain't going down
Really? I'm curious, because after reading up on Index-Organized Tables, they sound actually pretty similar. Clustered Index: an ordering ruleset for the data on the disk. IOT: a method to store oracle rows in a b*Tree format instead of the default rowid-controlled heap. So, generically, both are ways you can control the physical order of the data on your disk. Is there more to it than this simplistic explanation? Followup question: why not have EVERY table be an IOT in oracle? (notwithstanding the known limitations of IOTs; no longs, no clustering) Boss IOT and clustered indexes are not comparable to each other. -Original Message- Sent: Friday, October 24, 2003 2:44 PM To: Multiple recipients of list ORACLE-L My workplace is going in the same direction as David Mitchell's. Our OLTP systems are Oracle, basically everything else is being (or being considered) migrated to MSSQL2000. I am not that familiar with SQL Server, but I believe SQL2000 has sequences. I think MS calls it identity. I think MS also has IOT, which they call clustered indexes. MS might even have function based indexes with SQL2000, but not very sure. Anyone care to comment? Abey. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 11:19 PM -Original Message- From: Ryan [mailto:[EMAIL PROTECTED] Sent: Friday, 24 October 2003 12:44 To: Multiple recipients of list ORACLE-L Subject: Re: Oracle pricing ain't going down what is MSEE lacking in? sound of can of worms opening Here's a start. MSSQLServer EE has ... No bitmap indexes, no partitioned indexes, no function-based indexes, no domain indexes, no reverse key indexes, no object tables, no before triggers (can be kludged, not pretty), no multiple actions per trigger event, no 3rd-party language support a la Oracle's JVM and pro*... modules, no built-in OLAP (it's a weird bolt-on), no control over extent size, no control over block size, no star query optimisation, no sequences, no synonyms, no packages, no structured exception handling in stored proc language (TSQL), no MINUS union operator, no multiplexing or mirroring of log files, no cyclical log management, no escalation-free locking, no index organised tables. (Working with both every day, do you get the feeling I've been asked this before? :-)) Half of those things are available in Oracle SE One :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Abey Joseph INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rothouse, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Boss INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru
Re: Oracle pricing ain't going down
Identity has come a LONG way in Sybase since its initial introduction back in Sybase v10.0 (1994). In fact, the latest versions of Sybase have identities tuned almost to where they emulate a monotonically increasing sequence in every capacity (if you set the parameters correctly). I've never seen duplicate values with it though. The most common complaint is with gaps in the assigned values (since Sybase caches large chunks of numbers to pre-use, and loses them upon abnormal shutdowns). However, there's remedies even for that situation. (see http://www.sypron.nl/idgaps.html for a great writeup). Surf to http://www.isug.com/Sybase_FAQ/ASE/section6.2.html#6.2.9 for more information. That's the direct link to the Identity section of the Sybase FAQ ... its a little dated but most of the info is still valid. I actually wrote this answer for the Sybase FAQ back in 1997 (so yes i know what i'm talking about, i think. :-) ) Todd Boss (a true Sybase dba now hanging out in an oracle world). IDENTITY does not have exactly SEQUENCE functionality. It is a property, you can assign to a column. And it has buggy implementation, I've seen duplicate values (not sure about the latest version). So be careful with this feature. As for clustered indexes - you are correct. Actually SQL Server (Sybase) had them before Oracle implemented IOTs. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Abey Joseph Sent: Friday, October 24, 2003 1:44 PM To: Multiple recipients of list ORACLE-L My workplace is going in the same direction as David Mitchell's. Our OLTP systems are Oracle, basically everything else is being (or being considered) migrated to MSSQL2000. I am not that familiar with SQL Server, but I believe SQL2000 has sequences. I think MS calls it identity. I think MS also has IOT, which they call clustered indexes. MS might even have function based indexes with SQL2000, but not very sure. Anyone care to comment? Abey. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 11:19 PM -Original Message- From: Ryan [mailto:[EMAIL PROTECTED] Sent: Friday, 24 October 2003 12:44 To: Multiple recipients of list ORACLE-L Subject: Re: Oracle pricing ain't going down what is MSEE lacking in? sound of can of worms opening Here's a start. MSSQLServer EE has ... No bitmap indexes, no partitioned indexes, no function-based indexes, no domain indexes, no reverse key indexes, no object tables, no before triggers (can be kludged, not pretty), no multiple actions per trigger event, no 3rd-party language support a la Oracle's JVM and pro*... modules, no built-in OLAP (it's a weird bolt-on), no control over extent size, no control over block size, no star query optimisation, no sequences, no synonyms, no packages, no structured exception handling in stored proc language (TSQL), no MINUS union operator, no multiplexing or mirroring of log files, no cyclical log management, no escalation-free locking, no index organised tables. (Working with both every day, do you get the feeling I've been asked this before? :-)) Half of those things are available in Oracle SE One :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Abey Joseph INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: How to add ' (comma) at the begining and end of each line? Either
The magic of Sed. vi file :1,$ s/^/'/g :1,$ s/$/',/g :wq Thats it. boss Hi List I have 1000 lines in my data file. I want to add '(comma) at the begining and end of each line. For example, abf jd djkhk jd3 Shold be convrted to 'abf', 'jd', 'djkhk', 'jd3', Any help will be really appreciated. Thanks Sami __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Boss INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Removing duplicate rows from a table !
We just discussed this about a month ago. 3 basic solutions: 1. delete from table where rowid not in (select max(rowid) from table group by col_1,col_2,etc); sql only solution, not really feasible in huge environments 2. Alter table mytab enable constraint PK exceptions into exceptions; Better way; much faster for large tables, lets you audit the duplicate rows by examining exceptions table. 3. Write a cursor; sql coding solution ... probably doesn't give you anything mroe than what option 2 provides. boss Hi, I am trying to remove the duplicate rows from a table with the column data.. I cannot use PK as it's just a sequence number... I could find all the duplicate rows by grouping the column. but how can i delete only the duplicate ones and retain the original data.. Any help is gr8 ! ! ! Warm Regards Shreekanth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rama, Shreekantha (K.) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Boss INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: software which monitoring diferences between instances ?
The only other tool that works on Oracle would be part of the CAST workbench suite of tools. there's a product for MS Sql server called AdeptSQL, and a toolset of perl scripts for Sybase called dbschema.pl that do similar jobs. Todd Ota: Take a look at Embarcadero's Change Manager. You can download a copy to use as a trial for a couple of weeks. www.embarcadero.com I was very impressed with the product. Good luck! Barb --- Otakar Mouèka [EMAIL PROTECTED] wrote: Hi Have Oracle some software for monitoring difrences between schemes in several servers ? Thanks Ota -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Otakar =?iso-8859-2?q?Mou=E8ka?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Boss INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Data Modelling Tools for a DBAs Job
I'd say having some sort of data modelling tool at your disposal is pretty much essential to understanding the table layouts and relationships for anything but the most trivial model. If you do any sort of data modeling or database design, or if you interface with developers, having a nice ERD is key. Major ERD Tools out there: - S-Designer/PowerDesigner Data Architect - LogicWorks (now Platinum) ERwin - Cast db-builder - Embarcadero's ER/Studio - Microsoft Visio (now has an ERD module) Others that i'm not as familiar with: - DeZign - Silverrun's RDM - Rational Rose 2000E - Oracle Designer 2000 - Popkin's System Architect - Select Enterprise - RevSQL: http://www.sqlworkshop.com/ - Clear Case hope this helps. boss - How essential the following tools to a DBAs job? (viz) Rational Rose, Clear case for Versioning etc. What are Data Modelling tools avbl. in the market and which are widely used (other than Oracle Designer)?. TIA ___ No banners. No pop-ups. No kidding. Introducing My Way - http://www.myway.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: quriyat INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Boss INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Huge optimization costs with 9.2
How many more of these undocumented but seemingly crucial optimizer parameters has changed from 8i to 9i? I'd think these are a bit more important to know about. Anyone have a list of these changed parameters? Are they noted in the 9i docs? boss We has problems with another undocumented parameter that changed when we migrated to 9i in August last year. _B_TREE_BITMAP_PLANS change from false to true and caused a number of issues with sub-optimal execution plans. Another possible trap for the unwary ... Cheers Richard - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 02, 2003 2:54 AM One of the undocumented init.ora parameters that changed from 8 to 9 is _UNNEST_SUBQUERY (from false to true). You could try if that is the culprit. Of course, since it is an undocumented parameter, get the blessing from Oracle support before using it in a production database. At 10:09 AM 10/1/2003, you wrote: Joan, what is the difference in the plans? What specific feature made the difference? Are the values of optimizer_index_cost_adj and optimizer_index_caching same on both versions? How about histograms? What is with db_file_multiblock_read_count,sort_area_size and hash_area_size? Is everything same as in 8i? May be setting of those parameters can be tweaked to your benefit? On Wed, 2003-10-01 at 11:54, Joan Hsieh wrote: Kirti, I had upgraded a database from 8.1.7.4 to 9.2.0.4. Before the upgrade, performance is good. After upgrade, one query run time from 2 min to 12 hours. Of course, I re-analyzed all tables and indexes. The explain plan changed from hash join to nested-loop. All the parameters are same. So I have to put optimized_feature_enable=8.1.7 to make run normal as usual. I hate to disable the new feature, but no choose. 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 Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Boss INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: oracle newsgroup
Two options you can look into: - read and post via groups.google.com. I post this way using a fake yahoo account that i never check. Be warned; posting to a newsgroup causes open season on your email address for spam. - if your isp doesn't have a newsfeed, you can get a free account around the net. I happened across news.cis.dfn.de, which allows people to get news fed from their server after registration. I subscribe and read news from their feed through Netscape Messenger. Hope this helps, Todd This is a multi-part message in MIME format. --_=_NextPart_001_01C386B1.9DAE7AEB Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable You can access it through the Outlook Newsreader via the Tools menu on IE but... you have to have DNS/ISP set up for it and most companies don't give carte blanche to news because of all the other junk out there. ;-) -Original Message- From: AK [mailto:[EMAIL PROTECTED] Sent: Monday, September 29, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Subject: oracle newsgroup =09 =09 How to one subcribe to Comp.database.oracle newsgroup . Can it be added into outlook directly .=20 =20 thanks, -ak =20 --_=_NextPart_001_01C386B1.9DAE7AEB Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEADTITLEMessage/TITLE META http-equiv=3DContent-Type content=3Dtext/html; = charset=3Dus-ascii META content=3DMSHTML 6.00.2722.900 name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVSPAN class=3D771384117-29092003FONT face=3DArial color=3D#ff = size=3D2You=20 can access it through the Outlook Newsreader via the Tools menu on IE = but... you=20 have to have DNS/ISP set up for it and most companies don't give carte = blanche=20 to news because of all the other junk out there. ;-)/FONT/SPAN/DIV BLOCKQUOTE dir=3Dltr style=3DMARGIN-RIGHT: 0px DIV/DIV DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr = align=3DleftFONT=20 face=3DTahoma size=3D2-Original Message-BRBFrom:/B AK=20 [mailto:[EMAIL PROTECTED] BRBSent:/B Monday, September 29, = 2003=20 12:35 PMBRBTo:/B Multiple recipients of list = ORACLE-LBRBSubject:/B=20 oracle newsgroupBRBR/FONT/DIV DIVFONT face=3DArial size=3D2STRONGHow to one subcribe to=20 Comp/STRONG.Bdatabase.oracle newsgroup .nbsp; Can it be added = into=20 outlook directly . /B/FONT/DIV DIVSTRONGFONT face=3DArial size=3D2/FONT/STRONGnbsp;/DIV DIVSTRONGFONT face=3DArial size=3D2thanks,/FONT/STRONG/DIV DIVSTRONGFONT face=3DArial size=3D2-ak/FONT/STRONG/DIV DIVSTRONGFONT face=3DArial=20 size=3D2/FONT/STRONGnbsp;/DIV/BLOCKQUOTE/BODY/HTML =00 --_=_NextPart_001_01C386B1.9DAE7AEB-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Boss INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).