Backup & recovery tools for 7.3.4 from 9i

2002-07-18 Thread Beatriz Martínez Jiménez
Hello, we have an application running the Oracle 7.3.4 version. We have recently bought the 9i 9.0.1 version. Is it possible to use the 9i backup and recovery tools to backup the 7.3.4. database? If the answer is no, between which database versions, for example from 9i to 8i? 9i to 8? Thanks a lot

SQLLoader

2002-07-18 Thread Sackwitz, Antje
Hi, I have to load an ASCII dump into Oracle with loader that contains date information in a different national character set than my databse. Can I specify a different nls_lang ( Do an alter session set = nls_lang...) before the load? If so, can you please give me the syntax? Regards, Antje Sackw

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

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 ex

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 (Keelin

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 lice

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

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

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 http://autos.yahoo.

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

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. Denni

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 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 fact

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: 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: 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 apro

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: 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 > applica

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 raise

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 ha

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 w

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 tr

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 search

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, Jav

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: 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. Wha

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 shoul

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 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 understa

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 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 like

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 of

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:

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 F

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 <[EM

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: (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 rec

RE: Robert Freeman - RMAN Resources

2002-07-18 Thread Freeman, Robert
The 101 Backup and Recovery book by Oracle Press that Dennis mentioned is good. I don't have the book here on my desk, and Amazon for some reason doesn't mention the authors names on it's web page (need to shout at OP about that maybe)... Also there is a O'Reilly RMAN handbook that is out, but it

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 they

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 pe

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 Im

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-ho

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 o

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. B

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: Th

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 to

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

2002-07-18 Thread Bill Conner
Naw, some "which site are you looking" for popped up and it was in there i have not been able to get on the site yet either. At 10:52 AM 7/18/2002 -0800, you wrote: >Did you actually get to a web site? I got 'not found'. >Ruth >- Original Message - >To: "Multiple recipients of list ORA

RE: Oracle Migration 8.1.6.0 to 8.1.7.2

2002-07-18 Thread Baker, Barbara
Ken: I asked this question of the list several weeks ago, and got no reply. I installed 8.1.7.0 on the system, patched up to 8.1.7.3, and then upgraded my test database. I now want to go directly to exactly the same code tree with my production database because (1) it's been tested with exactly th

RE: Cognos

2002-07-18 Thread Paul . Parker
Cognos notwithstanding, isn't the objective in the case of Data Warehouse/DSS/Reporting/BI (or whatever the latest buzzword is for generating reports) to give end-users access to the data. These end-users then generate the own reports, without the need for IT every time they need a new total on a

Cognos

2002-07-18 Thread Bill Becker
Huh? We use cognos transformer and enterprise server on Solaris, because that's also where our Oracle db resides. Cognos told us they were "re-emphasizing" the unix side of the business, because they realized it was significant. We evaluated Business Objects/Brio/Cognos back in 1998, and went wi

Oracle 7.3.4 crash

2002-07-18 Thread Robert Monical
I had an interesting problem this morning with a 7.3.4.4 database on Win2K. It stopped working at 10:16 this morning. In archive log mode. Lightly loaded, 3-4 log switches a day After some investigation, it appears that 1 log file and 2 control files were changed to read only (and hidden). Wo

Re: Unindexed foreign key

2002-07-18 Thread basher 59
Terrible expecially on inserts into the database, it may have to do a full table scan to insert one record. Don't do it. >From: "Shishir Kumar Mishra" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Unindexed foreign key

Re: OT: Just a laff! "Gates gooses geese guano gunners"

2002-07-18 Thread Martin Brown
Everyone who has ever gotten a gpf gets reincarnated as a goose >From: John Kanagaraj <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: OT: Just a laff! "Gates gooses geese guano gunners" >Date: Wed, 17 Jul 2002 12:04:22

a quick SQL performance question.

2002-07-18 Thread Andrey Bronfin
Dear all ! I've got a cursor , which selects approximately 25% of records in a table (the total number of records in that table is typically 2 to 20 thousands). For each record ,fetched in that cursor, i need to do some processing , and then delete that record. Now, what's faster: 1) Add the rowi

RE: A DBA looks at OAS

2002-07-18 Thread Eric D. Pierce
At work we ordered 9iAS R2 (for NT/Win2000) in May. We just got it the other day. I have to wait for some old lab machines to go to surplus status (many months) before I can make a couple sandbox win2000 servers to test it and the 9i db (and 9i iDS). books ??? http://www.amazon.com/exec/obid

ADMIN: Re:RE: Destination address unreachable

2002-07-18 Thread bruceb
Doug, Kevin and others -- Sorry about getting so many of the returned messages. These "locks" occur when our primary mail server is dealing with spam or viruses on one of our mailing lists. It temporarily shunts mail to a non-mailing-list-aware server so that mail will continue to work, but

RE: Oracle Migration 8.1.6.0 to 8.1.7.2

2002-07-18 Thread Fowler, Kenneth R
The server already has 8.1.6.0 and 8.1.7.2 installed in separate oracle homes. We could install 8.1.7.0 in a third oracle home (we have the media) but are trying to avoid that as we would only need it for migration after which we have no use for it. So I was just wondering if we can migrate dire

(Fwd) FW: Oracle 9i Application Server,

2002-07-18 Thread Eric D. Pierce
fwiw, naming/numbering of 9i AS R2 on Windows: [(9.0.2.0.1) CD Pack v1 for MS Windows] -Original Message- Sent: Wednesday, July 17, 2002 6:55 PM To: [software librarian] ... Thanks for the info. It is correct that I don't need it for the production Oracle database v8.1.7 that I'm try

Oracle migration

2002-07-18 Thread Bill Becker
You may want to review metalink doc id 188061.1 entitled "Upgrading Directly to an 8.1.7 Patch Set". We followed this for an 8.1.6.0 upgrade to 8.1.7.4. on Solaris. However, this does require setting up a new oracle_home. A summary of the steps are: 1) Install the base 8.1.7.0.0 directory tree

RE: peopleslop HR question

2002-07-18 Thread Karniotis, Stephen
Joe:      I do not thing the salary is encrypted.  I believe it is considered an open field.   Thank You   Stephen P. Karniotis Product Architect Compuware Corporation Direct:   (248) 865-4350 Mobile:  (248) 408-2918 Email:  [E

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

2002-07-18 Thread Ruth Gramolini
Did you actually get to a web site? I got 'not found'. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, July 18, 2002 1:48 PM Found a little: crescent systems home In the business world, it's so easy to lose a competitive edge. T

Re: Function

2002-07-18 Thread Alex
Look for owa_pattern.match() On Thu, 18 Jul 2002, Hamid Alavi wrote: > 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

Re:Oracle Migration 8.1.6.0 to 8.1.7.2

2002-07-18 Thread dgoulet
Ken, How do you plan on getting to 8.1.7.2? You need to apply the patch set ontop of an 8.1.7.0 install. I'd double check your CD's. Dick Goulet Reply Separator Author: "Fowler; Kenneth R" <[EMAIL PROTECTED]> Date: 7/18/2002 9:43 AM List, On

RE: peopleslop HR question

2002-07-18 Thread Toepke, Kevin M
Joe   on previous PS HR implementations (versions through PS 7.1) the answer is no. In fact there was no encrypted data in the system.   Kevin -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, July 18, 2002 12:34 PMTo: Multiple recipients of list ORAC

Re: Cognos

2002-07-18 Thread Ruth Gramolini
I used Cognos a few years ago on an HP Image3000 database. It is pricey but delivers as advertised. Great products! Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, July 18, 2002 12:08 PM > Anybody have any experience with "Cogno

RE: Function

2002-07-18 Thread kkennedy
Try: create or replace function is_number( parm in varchar2 ) return boolean is x number; begin x := to_number( parm ); return true; exception when value_error then return false; end; Kevin Kennedy First Point Energy Corporation -Original Message- Sent: Thursday, July 18, 2

RE: IMP/EXP Problem

2002-07-18 Thread Hamid Alavi
Dennis, I allow IMP to create it. -Original Message- Sent: Thursday, July 18, 2002 10:08 AM To: Multiple recipients of list ORACLE-L 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 PRO

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

2002-07-18 Thread dgoulet
Chaos, Guess you like living up to your name! :) 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 the case, your sequences will not reflect t

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

2002-07-18 Thread johanna . doran
Yeah, but what if they are taking the credentials to apply for US Visa's ... > -Original Message- > From: [EMAIL PROTECTED]@SUNGARD On Behalf Of [EMAIL PROTECTED] > Sent: Thursday, July 18, 2002 12:29 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: OFF

Re:Cognos

2002-07-18 Thread dgoulet
John, We did an eval on Cognos Query about 6 months ago. Decided against it, even though we use their Power Play and SQR products already. Reasons: 1) to much stuff to install on the server. Their install puts 6 to 8 services onto a Windows server for some of their "advanced" features

Re:RE: Cognos

2002-07-18 Thread dgoulet
John, One last point to add to my reply of before. They don't support HP-UX, actually I don't think they support any Unix. Dick Goulet Reply Separator Author: "Vergara; Michael (TEM)" <[EMAIL PROTECTED]> Date: 7/18/2002 9:28 AM Our Data Wareho

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

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

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 a

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 18,

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: Vergar

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 www.crescent.cc/

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 sa

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[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

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 if

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,

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

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 infor

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] Quad/Te

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:

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 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 remov

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 record

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  

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

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 ca

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 Server:

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: 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 Header__

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

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 part

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 adopter

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: 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 Richard..

  1   2   >