RE: OFF TOPIC:Be careful from www.crescent.cc company

2002-07-18 Thread Khedr, Waleed
Honestly I do not what the problem is. There are tons of companies that do the same thing. These are the companies that really make huge money. They bring people on H1-B (I'm not sure about the visa name) to US and pay them low wages while getting paid very good rates. Probably they are unable

RE: Oracle Migration 8.1.6.0 to 8.1.7.2

2002-07-18 Thread Paul . Parker
Currently going through a migration from 8.1.6.0.0 to 8.1.7.4 1. Had 8.1.6 installed. 2. Install 8.1.7.0 into new ORACLE_HOME 3. Apply pathset to get to 8.1.7.4 4. Upgrade database to 8.1.7.4 You only need to upgrade once, with only 2 oracle homes. Paul -Original Message- Sent:

Re: Cognos

2002-07-18 Thread Jay Hostetter
Their OLAP tool is PowerPlay. Their report writer is Impromptu. Which product are they pushing on you? I think PowerPlay is a great tool and easy to use. When we first bought it (3 or 4 years ago), I had a cube built within a day. It was much cheaper and easier to use the Oracle Express.

a quick SQL performance question - rethinked

2002-07-18 Thread Andrey Bronfin
Dear gurus ! I apologize for wasting your time. I have had a second thought and realized that option (2) is not feasible, simply because i might miss some records, i.e. delete the records that are inserted into MYTAB DURING the execution of the cursor. I.e. , time will pass between the opening of

RE: Cognos

2002-07-18 Thread Thomas Day
I worked as part of a best practices group once that used Oracle as the DBMS, Brio for the metadata and Cognos for the data mining/analysis. My impression was that Cognos worked great with highly trained users who had a great deal of business knowledge in a particular area. It is not an ad-hoc

Re: Cognos

2002-07-18 Thread KENNETH JANUSZ
I am not familiar with the term cube. Could someone give me a short definition? Thanks, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 18, 2002 2:35 PM Their OLAP tool is PowerPlay. Their report writer is

RE: Unindexed foreign key

2002-07-18 Thread Freeman, Robert
Well, that depends on if the FK is enforced or not too. There should be minimal performance impact with an unenforced FK with regards to inserts. In a DW FK's are often present but not enforced. Unenforced FK's in DW's are used for a number of reasons, query rewrite among them. Some of the old

RE: A DBA looks at OAS | IAS vs. Locally-built Apache (commen

2002-07-18 Thread Boivin, Patrice J
I don't think it's deliberate, probably just because products are being rolled out so quickly and the technology is changing. OAS and OWS were different from iAS, they used an Oracle-built (I believe) web server. iAS relies on Apache. As for the change from 1.0 to 9I rel 2 for iAS, probably

Re: (Fwd)

2002-07-18 Thread James J. Morrow
Eric D. Pierce wrote: trying again... --- Forwarded message follows --- Responsibility / Re: OT -unix Date: Mon, 15 Jul 2002 18:55:37 -0400 Connect the dots, contrary to the highly postured false rectitude that you are conveying, Ellison has a very long track record of

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

2002-07-18 Thread Freeman, Robert
I will see what I can do. Thanks Scott! RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i  (Sybex) Clark Griswold: Eddie, has

RE: OT: Just a laff! Gates gooses geese guano gunners

2002-07-18 Thread John Weatherman
There aren't THAT many gooses! John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, July 18, 2002 3:14 PM To: Multiple recipients of list ORACLE-L Everyone who has ever gotten a gpf gets reincarnated as a goose From: John Kanagaraj

SQL Query

2002-07-18 Thread Ramasubramanian, Shankar (Cognizant)
Hi Friends, I just need a help in a sql . I am having rows in a table as follows Field1(ID)Field2(NAME) -- 1 RAM 1 SHAM 1 PAT 2 MAN 2 JOHN Now i want the output to be as follows

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

2002-07-18 Thread Scott . Shafer
Good luck. The smooth install is at a grinding halt at the moment, with half the components throwing java exceptions all over the place. Did I mention java sucks? Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Freeman, Robert [SMTP:[EMAIL PROTECTED]] Sent:

RE: Cognos

2002-07-18 Thread John Weatherman
Paul, Yes and no. As I understand datamarts, you do some renormalization, and you make sure that the end user looking at the data will have a reasonable chance of getting good information out from their queries. What is being suggested here is access to a clone of the Prod OLAP system. Many

RE: a couple of questions

2002-07-18 Thread David Miller
Hi Greg (and all), 32-bit applications will run under 64-bit OS (Solaris 7-9 and on) with no problems. In fact a lot of the unix commands are 32-bit and probably will remain so. The main reason to go beyond 32-bit is if you need an address space for a single process to be above 4 GB. Not

Re: a quick SQL performance question - rethinked

2002-07-18 Thread Rajesh . Rao
Andrey, Instead of explicitly using 'where rowid = ', why not consider the use 'for update of' and 'where current of'? Raj Andrey Bronfin

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

2002-07-18 Thread Freeman, Robert
Thats the problem with technology today I think man, the stacks get more and more complicatedThere is UNIX, NT, IIS, Apache, C, Java, Java Beans, Java Applets, .NET, ASP, XML, EI EI Oh... Oh for the day when one could DBA and develop the most incredible C code and not struggle to

RE: Cognos

2002-07-18 Thread Freeman, Robert
What about a meta-data repository, and a catalog of all those columns and the relationships (or lack thereof) between them. (assuming the users would use such a thing). Would that not help eliminate the problem you are concerned about? RF Robert G. Freeman - Oracle OCP Oracle Database Architect

RE: a quick SQL performance question - rethinked

2002-07-18 Thread kkennedy
Hi Andrey, If the volume of rows is not too great, you can use a technique I've used. Retrieve the rowids and store them in a PL/SQL table as you process them. At the end of the processing loop, use a forall loop to delete the rows using the PL/SQL table. I know a 2000 row PL/SQL table

RE: Cognos

2002-07-18 Thread Browett, Darren
We have deployed cognos, first a local install on all P.C.'s and we are now migrating to the Web based solution. The original selling point was that everybody would be able to quickly and easily create their own reports, with the users accessing our production databases. How wrong that was.

OT: finding pasword emails. Virus ???

2002-07-18 Thread Danisment Gazi Unal (ubTools)
Hello list, I'm getting many finding pasword emails from non-registered users. have you got this type of email ? is it a spam or virus ? regards... -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

2002-07-18 Thread Jenkins, Michael - EDS
Let's not forget the new .mac -Original Message- Sent: Thursday, July 18, 2002 4:59 PM To: Multiple recipients of list ORACLE-L Thats the problem with technology today I think man, the stacks get more and more complicatedThere is UNIX, NT, IIS, Apache, C, Java, Java Beans, Java

RE: finding pasword emails. Virus ???

2002-07-18 Thread Seefelt, Beth
I have gotten one also. It appears to be some type of attempted virus. Its an html message that attempts to execute an attachment as an application. The attachment is called password.txt, I assume to fool the email filters. As far as I can tell, it didn't work on my machine, and I did a

Re:RE: Cognos

2002-07-18 Thread dgoulet
Paul, I FULLY agree. But it's damned nice if that tool does not become an administrative nightmare. The COGNOS metadata layer, although damned nice will become just that. Why, because sales folks call a particular data field one thing and engineers call it something else. and as far as

RE: finding pasword emails. Virus ???

2002-07-18 Thread Ron Rogers
from an earlier email notification...IT IS A VIRUS [EMAIL PROTECTED] 07/15/02 05:49PM It's a new one not KLEZ ... -BEGIN PGP SIGNED MESSAGE- A number of people have received email from contacts at other sites with the subject line Your Password! This is a new email-based worm

Connection create time is long

2002-07-18 Thread Bond Mike A Contr OC-ALC/TILC
Hi, I am seeing a relatively large difference in the time it takes to create a database connection. There are two instances (8.1.6.3.8) running on our NT 4.0 server. When my users complained, one instance had 20 sessions and connect time took 2-3 seconds while the other, busier prod instance

Re: Function

2002-07-18 Thread Jared . Still
Make Oracle do the work. HTH Jared create or replace function is_number( chk_data_in varchar2 ) return boolean is dummy number(38,4); begin dummy := to_number(chk_data_in); return true; exception when value_error then return false; when others then

RE: finding pasword emails. Virus ???

2002-07-18 Thread Rachel Carmichael
frethem virus -- it's real search for frethem on symantec and you should find lots of hits --- Seefelt, Beth [EMAIL PROTECTED] wrote: I have gotten one also. It appears to be some type of attempted virus. Its an html message that attempts to execute an attachment as an application. The

Re: OT: finding pasword emails. Virus ???

2002-07-18 Thread Rachel Carmichael
it's a virus search for frethem.. --- Danisment Gazi Unal (ubTools) [EMAIL PROTECTED] wrote: Hello list, I'm getting many finding pasword emails from non-registered users. have you got this type of email ? is it a spam or virus ? regards... -- Danisment Gazi Unal

RE: IMP/EXP Problem

2002-07-18 Thread Ron Rogers
Hamid, Export your table with the INDEXES=N option, Drop the indexes from the target table ,Clean up the original table if it to be completely overwritten. Import the data. You could also insert into the original table with a select from the source table across a database link. 6 M rows took

RE: Oracle9i : OLAP and Data Mining Options

2002-07-18 Thread MacGregor, Ian A.
Yes, the OLAP option is at extra cost. Ian MacGregor Stanford Linear Acclerator Center [EMAIL PROTECTED] -Original Message- Sent: Thursday, July 18, 2002 1:08 AM To: Multiple recipients of list ORACLE-L Has anyone installed and used the OLAP and Data Mining Options in 9iRelease2 ?

RE: Cognos

2002-07-18 Thread Jared . Still
Paul, IMO it depends on where that data resides. If it's in the production OLTP system, it might be their data, but they're aren't responsible for the performance of the database, I am. So they don't get to play there. If it's in their replicated database I've created for reporting, they can

RE: Cognos

2002-07-18 Thread Paul . Parker
Totally agree. I didn't make the point of accessing the production OLTP system, as I didn't think that anybody is still doing that :) Any serious reporting should be off of a database setup specifically for that purpose. Through a proper meta-data layer, the joins between dimensions and

RE: Re[2]: OFF TOPIC:Be careful from www.crescent.cc company

2002-07-18 Thread DENNIS WILLIAMS
If they did to me what was described, I think I would contact a lawyer or two and see if with a U.S. address and a person's name if they could do anything to help me. -Original Message- Sent: Thursday, July 18, 2002 11:53 AM To: Multiple recipients of list ORACLE-L Ruth, A search

RE: Cognos

2002-07-18 Thread DENNIS WILLIAMS
Ken - A spreadsheet is 2-dimensional. 3 dimensions can be represented as a cube. OLAP involves analysis with 3 or more dimensions. Since you can't draw more than 3 dimensions, it has been handy to call the multidimensional structure a cube. This works pretty well with nontechnical people. Dennis

RE: Cognos

2002-07-18 Thread Jared . Still
I didn't make the point of accessing the production OLTP system, as I didn't think that anybody is still doing that :) Well... I'm still weaning them off of that particular bad habit. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/18/2002 04:44 PM Please respond to ORACLE-L

anydata

2002-07-18 Thread Rachel Carmichael
Thank you to everyone for your help with this... we ended up deciding NOT to use ANYDATA in the system It helps that vignette is not yet certified on 9i :) Rachel __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes

DB copying : Attack of the Clones!

2002-07-18 Thread Deshpande, Kirti
Listers, I was 'volunteered' to participate in a task force charged with finding quick solutions (in less than 2 weeks) to support following Dgmt decision: Clone 14 production databases in their entirety for ongoing code testing, recreating production problems etc. The cloned databases will

Re: DB copying : Attack of the Clones!

2002-07-18 Thread Henry Poras
Kirti, We had the same kind of issue when I was at my last job. Never came up with a solution I was totally happy with. We just ended up using our cold backups (minimal downtime since they were copied from a third mirror. Just shutdown, split, startup, copy to tape or whereever). For our database

Re: RE: a couple of questions

2002-07-18 Thread Tim Gorman
I haven't been following this thread, but I saw the phrase database independent and couldn't help chiming in... For the past couple years, whenever someone mentioned database independence as justification for certain decisions, I suggest that they stick with MySQL and save themselves the

Re: OFF TOPIC:Be careful from www.crescent.cc company

2002-07-18 Thread Tim Gorman
that's interesting. that address in Bethesda is the same building that Oracle has occupied a majority of space for years... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 18, 2002 10:23 AM And further, reseaching Cocos (Keeling)

Where to Find Sample QUESTIONS for OCP-DBA Exams?

2002-07-18 Thread Cruiser
Hi list-guys ! I am a Newbee, preparing for OCP/DBA Oracle8i Exams. I would appreciate if some one can help me for the following queries. 1) When exactly Oracle8i is expiring? Is it favorible right now to register for Oracle 8i exams? 2) Is any body has sample questions for DBA exams or

Re: Re:Millions of sequence in a database to record the counter

2002-07-18 Thread chaos
dgoulet£¬ Guess you like living up to your name! :) Thanks for your suggestions:) Anyway, having a sequence for each product would be a nightmare so I would not recommend it. Besides a sequence can get tossed off when you have caching turned on and bounce your DB. That being

RE: Sequence number generation

2002-07-18 Thread Abdul Aleem
To have a better control, we always use tables for holding counters. Depending upon the requirement, either one table to hold different counters or multiple tables, sometime in master tables as well. This does not any additional coding, the trigger in which you fetch from sequence you select

Oracle9i : OLAP and Data Mining Options

2002-07-18 Thread hkchital
Has anyone installed and used the OLAP and Data Mining Options in 9iRelease2 ? If you upgraded from 8i, did you have to have to pay any additional fee for the license for these options (as they did not exist in 8i) ? Hemant K Chitale http://hkchital.tripod.com -- Please see the official

Re: SQL Join or Subquery

2002-07-18 Thread Jack van Zanen
Hi Try: select t1.sensor_id,t1.temp_c from temperature t1 where t1.timestamp = (select max(t2.timestamp) from temperature t2 where t1.sensor_id=t2.sensor_id) Jack

RE: Oracle-L, SQL-loader

2002-07-18 Thread cosltemp-g . manoj
BDY.RTF Description: RTF file

RE: GZip/WinZip...hot backups...

2002-07-18 Thread Bishop Lewis
From what i remember Winzip has a file limit of 4gb... Lewis Bishop --- Barclays Enable/ISS/OPTS Oracle Database Consultant Phone: 020 8298 3418 Mobile: 07950 380857 Email:[EMAIL PROTECTED] -Original Message- Sent: 17 July 2002 20:24 To: Multiple recipients of list ORACLE-L This

Re: SQL Join or Subquery

2002-07-18 Thread Jack van Zanen
Or with the sensor name included select t1.sensor_id,s.naam,t1.temp_c from temperature t1, sensor s where t1.timestamp = (select max(t2.timestamp) from temperature t2 where t1.sensor_id=t2.sensor_id) and s.sensor_id=t1.sensor_id 11:30:15 29-CC1-JACK

RE: RE: a couple of questions

2002-07-18 Thread Connor McDonald
database indepdent... oh dear...You're doomed :-) --- Rachel Carmichael [EMAIL PROTECTED] wrote: and here they want to be database independent sigh. it's for a content management system --- Toepke, Kevin M [EMAIL PROTECTED] wrote: I agree, it looks messy and confusing... However,

Re:experiences oracle on linux rh

2002-07-18 Thread Markus Reger
Mailer Daemon [EMAIL PROTECTED] 07/16/02 16:41 PM The destination address you specified for your message could not be reached because of a locking problem. Your message is being returned to you so that you can resend it if you desire. The locking problem should be resolved within a few

RE: a couple of questions

2002-07-18 Thread Loughmiller, Greg
As an additional side note to the 64 bit phase of this thread... Solaris 9 is 64 bit by default. So the statement made by an individual (a field engineer) if anyone has plans on moving to a Solaris 9 environment, one will need to use the 64 bit Oracle version. I'm not totally convinced of that

[no subject]

2002-07-18 Thread ismail nural
i have oracle 8i on windows 2000 server. i have installed developer 6 . Now i can not connect database. Now I get the message on startup: Could not start ORACLEORAHOME81AGENT service on local computer error 3221356553. When i want to start svrmgrl i got sp1 lang.msb not found. what can i do to

OFF TOPIC:Be careful from www.crescent.cc company

2002-07-18 Thread SK OracleDBA
Hello, Guys, Thought of making all of you aware with dirty game played by Crescent Cc (www.crescent.cc). I got trapped with this company's offer letter and lost money, lost job, got lots of frustration etc. .etc Sharing this with all of you just thinking that – you guys will think twice

RE: RE: a couple of questions

2002-07-18 Thread Rachel Carmichael
no, I do have SOME input -- we'll be hiring a consultant DBA on this, at least to get it up and running. I have some control over who we hire. I'm going to make sure I get someone who is willing and able to say NO. And I refuse to mention the ANY datatype :) Rachel --- Connor McDonald [EMAIL

RE: RE: a couple of questions

2002-07-18 Thread Farnsworth, Dave
Rachel, I have talked to some very talented SQL Server DBA's that have used sql_variant data types. They all agreed that this data type is not worth the time. They would get unexplainable results. It is not so much a database issue but rather it is a coding and understanding of the data

RE: OFF TOPIC:Be careful from www.crescent.cc company

2002-07-18 Thread Robertson Lee - lerobe
Caveat Emptor my friend. I would have never have sent either money or educational qualifications (esp. originals) either domestically or abroad to anyone, no matter what. Once bitten twice shy is a good way to look at it from your point of view. -Original Message- Sent: 18 July 2002

Re: a couple of questions

2002-07-18 Thread Igor Neyman
same here, is it a new trend? they say, they don't want to waist my precious time on initial design meetings :-) I get to deal with all the crap, they design, afterwards... Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL

Re: Sequence number generation

2002-07-18 Thread Igor Neyman
so, what do you do, when you need to lock counter table and it's already locked by another process? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 18, 2002 3:38 AM To have a better

Re[2]:RE: (Fwd/2)

2002-07-18 Thread dgoulet
AW ^%$, Pardon me! It's Motorola not Magnavox. Damned old age showing itself, again!! Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 7/17/2002 2:33 PM Magnavox? As in the TV? ;) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED]

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

2002-07-18 Thread Gene Sais
Now I am confused. Supposedly, I just received the latest 9iAS from Oracle and its version is 1.0.2.2.2a. Is this 9iAS release 2, 9iAS release 1.0.2, etc? Gene [EMAIL PROTECTED] 07/17/02 05:28PM Robert, After having just fought a battle with iAS 1.0.2.2 do yourself a favor and get hold

RE: OFF TOPIC:Be careful from www.crescent.cc company

2002-07-18 Thread John . Hallas
Surely in your case that is all hypothetical isn't it Lee :) -Original Message- Sent: 18 July 2002 14:49 To: Multiple recipients of list ORACLE-L Caveat Emptor my friend. I would have never have sent either money or educational qualifications (esp. originals) either domestically or

RE: GZip/WinZip...hot backups...

2002-07-18 Thread Grabowy, Chris
My humble apologies to the list... He checked the backup script... host gzip -cf1 /disk2/oradata/rcdc/system.dbf /disk1/orabkup/rcdc/system.gz Good call Richard... There was a junior DBA that he was training that had setup the backup script. Oh well. Sorry for wasting everyone's time. A

DBA Manager Needed in Florida..

2002-07-18 Thread OraStaff
Position: DBA Manager Location: Ft. Lauderdale, Florida Salary Range: 80K to low 90s plus bonus of up to 12% Relocation Assistance is provided. PLEASE DO NOT send your resume for this position UNLESS you have the skills outlined below for this position. DO NOT send your resume unless you

RE: a couple of questions

2002-07-18 Thread Whittle Jerome Contr NCI
Title: RE: a couple of questions Nope. Been happening for years. Where ignorance is bliss 'tis folly to be wise. Thomas Gray (1716-1771) Damagement likes to be happy. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message-

Fwd:Destination address unreachable

2002-07-18 Thread dgoulet
Hey, Is anyone else getting these messages from FatCity? Dick Goulet Forward Header_ Author: Mailer Daemon [EMAIL PROTECTED] Date: 7/18/2002 6:20 AM The destination address you specified for your message could not be reached because of a locking

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

2002-07-18 Thread Scott . Shafer
Gene, I dunno anymore. 9.0.2 came out in May '02, according to the cd. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Gene Sais [SMTP:[EMAIL PROTECTED]] Sent: Thursday, July 18, 2002 9:18 AM To: Multiple recipients of list ORACLE-L Subject: RE: A DBA

RE: Sequence number generation

2002-07-18 Thread Hately Mike
I really don't see where this method scores over a sequence number. But I can see a number of places where it loses out. What happens when you select from the table and then don't commit the transaction that selected it? You'll still have a gap in your sequence. It's the same as a sequence but

RE: Sequence number generation

2002-07-18 Thread Cary Millsap
But be careful! Using tables for sequence numbers is a dead-certain guarantee that your application can never scale. The only way you can avoid performance problems with this kind of application design is to never let a lot of users use the system. If the locks don't kill you, then contention

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

2002-07-18 Thread MacGregor, Ian A.
I believe, about 95% confident, that they are the same. I think Oracle applications customers receive the the 1.0.2X numbered versions. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Thursday, July 18, 2002 7:18 AM To: Multiple recipients

Re: DBA Manager Needed in Florida..

2002-07-18 Thread Gene Sais
hmmm, they haven't filled that position yet. *wondering why* if anyone on the list is interested and wants to know the answer, email me privately. gene ps. florida is a small dba/it market. [EMAIL PROTECTED] 07/18/02 10:33AM Position: DBA Manager Location: Ft. Lauderdale, Florida Salary

RE: GZip/WinZip...hot backups...

2002-07-18 Thread Ji, Richard
You are welcome. :) -Original Message- Sent: Thursday, July 18, 2002 10:28 AM To: Multiple recipients of list ORACLE-L My humble apologies to the list... He checked the backup script... host gzip -cf1 /disk2/oradata/rcdc/system.dbf /disk1/orabkup/rcdc/system.gz Good call

Re: OFF TOPIC:Be careful from www.crescent.cc company

2002-07-18 Thread Ruth Gramolini
The domain .cc is defined as: CC Cocos (Keeling) Islands. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 18, 2002 10:23 AM Surely in your case that is all hypothetical isn't it Lee :) -Original Message- Sent: 18

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

2002-07-18 Thread Hately Mike
Sorry Gene, the latest version is 9.0.2. 1.0.2.2.2 was the previous release. Version 9.0.2 is quite different (in respects of install method and hardware requirements at least) so if you're familiar with 9iAS already you might want to evaluate R2 for a while. Or sit tight and let the early

IMP/EXP Problem

2002-07-18 Thread Hamid Alavi
Dear List, I am trying to import a table from another database which has partitioning, so after got few errors regarding the specific tablespace when I create the same tablespace it start loading data but after few thousand records stop with ORA-00018, my question is if we have a table which

Re:RE: RE: (Fwd/2)

2002-07-18 Thread dgoulet
Well, Let's see. It looked like Win2000 for the most part, acted like Win2000 only better faster. Their Office look alike package (little different in feel but not functionality) worked like Office2000 just a little faster. And to boot they had a copy of Doom running right off of the Windows

Re: Fwd:Destination address unreachable

2002-07-18 Thread Ruth Gramolini
I have gotten them in the past, not today tho. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 18, 2002 11:23 AM Hey, Is anyone else getting these messages from FatCity? Dick Goulet Forward

Cognos

2002-07-18 Thread John Weatherman
Anybody have any experience with Cognos? We've got a bhb that thinks its the solution for giving every end user access to the raw data (groan...loudly!)... I've argued every which-a-way against the concept, now I have to fight the specifics HELP! John P Weatherman Database Administrator

Re: OFF TOPIC:Be careful from www.crescent.cc company

2002-07-18 Thread Ruth Gramolini
And further, reseaching Cocos (Keeling) Islands via google.com. Tracing the domain you get: Whois Lookup for 'crescent.cc' [whois.nic.cc] eNIC Registry Whois Server Version 1.7 Domain Name: CRESCENT.CC Registrar: eNIC Corporation Whois Server: whois.enicregistrar.com Name

RE: OFF TOPIC:Be careful from www.crescent.cc company

2002-07-18 Thread Linda . Miller-Coker
I reported it to the FBI. Yea, it's not 9/11 but people are getting ripped off. [EMAIL PROTECTED]@fatcity.com on 07/18/2002 09:23:26 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Surely in your

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

2002-07-18 Thread Gene Sais
I have the cds released Feb-02. I received them 2 weeks ago. I would hate to think Oracle had extra's of the old stuff and passed it on :). Will be logging a tar. Thanks, Gene [EMAIL PROTECTED] 07/18/02 11:33AM Gene, I dunno anymore. 9.0.2 came out in May '02, according to the cd.

OT: peopleslop HR question

2002-07-18 Thread JOE TESTA
For those of you running PS HR, a question was posed to me, is the salary field encrypted, so that the DBA can't go in and look at everyones salary. OB oracle part: OMF stands for what?, Oracle Managed Files. joe

Millions of sequence in a database to record the counter for millions of products?

2002-07-18 Thread chaos
hi, dbas: Maybe this is some stupid idear, but this is the best idear i can think , the following is the requirement of our site: 1. every view to the one page(one product) is recorded, and the count is added by one, doing a commit. 2. There is 1700K pageview to

Re: DBA Manager Needed in Florida..

2002-07-18 Thread Gene Sais
OK, I said in private, but I received too many emails, so I will respond here omitting the company name :) Its w/ a co. known down here as a sweat shop. They have been looking for a dba mgr for almost a yr. This is also the co. who made the news after Sep 11, telling their employees to

RE: IMP/EXP Problem

2002-07-18 Thread DENNIS WILLIAMS
Hamid Did you pre-create the table on your target database, or are you allowing imp to create it? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, July 18, 2002 11:29 AM To: Multiple recipients of list ORACLE-L Dear List, I am trying

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

2002-07-18 Thread Scott . Shafer
The 9.0.2 differs significantly from the 1.0.2.2 at least for HPUX. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: MacGregor, Ian A. [SMTP:[EMAIL PROTECTED]] Sent: Thursday, July 18, 2002 10:38 AM To: Multiple recipients of list ORACLE-L Subject: RE: A

RE: DBMS_JOB interval wierdness

2002-07-18 Thread Jesse, Rich
Yup, Kevin, it was the job erroring that was causing it to resubmit itself every 24 hours. At least after 11 or so failures, it did. I threw in some error trapping, and all's well. Thanks! Rich Jesse System/Database Administrator [EMAIL PROTECTED]

Function

2002-07-18 Thread Hamid Alavi
Hi List, Is there any way that I can check to see if the value in a variable is a number? Example: is_number('100') = TRUE is_number('ABC') = FALSE Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The

Hints and Case Statements

2002-07-18 Thread Scott Canaan
I have run into a performance issue that I can't find any information on. There is a query that has a case statement in it. We added indexes to the fields being referenced in the case statement, but Oracle doesn't use the indexes. I added hints to the SQL to force it to use the indexes, it

RE: Cognos

2002-07-18 Thread Vergara, Michael (TEM)
Our Data Warehouse group uses Cognos PowerPlay to build cubes for the end users, and Cognos Impromptu for on-line drill-down and reporting. IMHO, Cognos writes crappy SQL. The users say they cannot insert hints, so you have to be ready for almost any kind of query. It's got a nice GUI, though,

Oracle Migration 8.1.6.0 to 8.1.7.2

2002-07-18 Thread Fowler, Kenneth R
List, One of the DBA's here needs to migrate a fairly sizeable database from 8.1.6.0 to 8.1.7.2 on Solaris. The doc's state that it is advisable to migrate to 8.1.7.0 and then go to 8.1.7.2 but we don't have 8.1.7.0 installed and don't want to install it unless we really have to. Anyone know

Re[2]: OFF TOPIC:Be careful from www.crescent.cc company

2002-07-18 Thread dgoulet
Ruth, A search of the Internet for Crescent Cc revealed the following: Crescent Systems A Software Consuting Group Suite 1200 7735 Old Georgetown Rd. Bethesda, MD 20814 Phone: 301.657.8277 x222 fax: 301.657.3724 http://crescent.cc/ Which if you go there

RE: A DBA looks at OAS | IAS vs. Locally-built Apache (commen

2002-07-18 Thread Hately Mike
All, to my mind this conversation (among people who genuinely take an interest in Oracle products) pretty much demonstrates how confusing Oracle's versioning system is. Does anyone think this is deliberate? Is there any gain to them in confusing customers or is it just incompetence on their part?

Re:OT: peopleslop HR question

2002-07-18 Thread dgoulet
Joe, NO. Dick Goulet Reply Separator Author: JOE TESTA [EMAIL PROTECTED] Date: 7/18/2002 8:33 AM For those of you running PS HR, a question was posed to me, is the salary field encrypted, so that the DBA can't go in and look at everyones

Re: OFF TOPIC:Be careful from www.crescent.cc company

2002-07-18 Thread Bill Conner
Found a little: crescent systems home In the business world, it's so easy to lose a competitive edge. Technology can change so quickly, you may not even realize it. Until your competitors have passed you by. Your company's ability to stay in the game and maintain profitability is

RE: RE: Cognos

2002-07-18 Thread Vergara, Michael (TEM)
That's too true. For a while we were building cubes on UNIX (actually HP-UX) systems, but Cognos completely desupported UNIX systems. And even when then did, the Windows cubes built a lot faster than the UNIX cubes did. -Original Message- Sent: Thursday, July 18, 2002 9:37 AM To:

RE: Oracle Migration 8.1.6.0 to 8.1.7.2

2002-07-18 Thread Vergara, Michael (TEM)
Ken: My Two Cents'... It seems to me that you're gonna have to install the 8.1.7.0.0 code in order to apply the 8.1.7.2 patch. So where's the problem? You install 8.1.7, upgrade the DB, apply the .2 patch, and it's Miller Time. Cheers, Mike -Original Message- Sent: Thursday, July

RE: Cognos

2002-07-18 Thread johanna . doran
I had experience with it once. Even took a training class. The project NEVER flew. I guess it depends on how your data is laod out. Our database was SO complex that the company I worked for hired a consultant to create the CUBE. after 4-6 months, he had a few erroneous reports to show

RE: Cognos

2002-07-18 Thread Scott . Shafer
Conos cube builds = database performance killer, especially if users are allowed to build data cubes on the fly. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: John Weatherman [SMTP:[EMAIL PROTECTED]] Sent: Thursday, July 18, 2002 11:08 AM To: Multiple

RE: A DBA looks at OAS | IAS vs. Locally-built Apache

2002-07-18 Thread Hately Mike
Gene, the order as far as memory serves is roughly: Oracle WebServer 2.x Oracle Web Server/Oracle Application Server 3.0.x Oracle Application Server 4.0.x Oracle 9i Application Server 1.0 - 1.0.2.2.2 Oracle 9i Application Server 9.0.2 (Release 2) - 13th May release date I think. There was some

  1   2   >