Test only

2001-04-16 Thread Sinardy Xing
test -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re[2]: Re:32bit v. 64bit Oracle

2001-04-16 Thread dgoulet
Cyril, We tried opening a DB that had been run on 32 the bit executables under HP-UX 10.20 with Oracle 64 bit executables on HP-UX 11.0. We received about 8 ORA-00600 errors each with 5 to 8 parameters reported. The folks at OTS told us what we had done in about 2 minutes just from the

OT: RE: stupid DBA

2001-04-16 Thread Anderson, Brian
http://www.darwinawards.com excerpt: Literary Reference The existence of Darwin Awards shows that we apparently do need common sense warnings like, "Caution: Batman cape does not enable wearer to fly." OF COURSE, you have to have the SUPERMAN cape to FLY!!! --

RE: RE: TNS-12500

2001-04-16 Thread Chaim . Katz
On windows NT, we had tns-12500 because the Oracle executable was trying to grow beyound 2gb... Chaim "Deshpande, Kirti" [EMAIL PROTECTED] on 04/15/2001 08:30:20 PM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Chaim

OPS waits

2001-04-16 Thread VIVEK_SHARMA
O.P.S. Setup in Benchmark Runs :- -- 2 DB Servers - ES40 Alpha machines - 4 CPUs , 8 GB RAM - O.S. DEC 5.1 1st APP Server - ES40 Alpha machines - 4 CPUs , 8 GB RAM - O.S. DEC 5.1 2nd APP Server - SUNe420R - 4 CPUs , 4 GB RAM - Solaris 2.6 3rd APP Server -

Re: How does dropping a partition affect the rest of the table?

2001-04-16 Thread Cherie_Machler
Gregory, However, if I have a locally partitioned index, the impact on indexes should be minimized. I believe that I should only have to rebuild the index on the next highest partition. The remainder of the local index partitions should be unaffected. Am I correct in my understanding of the

RE: stupid DBA

2001-04-16 Thread Gogala, Mladen
Well, what did they expect after putting a guy whose name is pronounced something like "wrong way" up there? -Original Message- Sent: Friday, April 13, 2001 7:01 PM To: Multiple recipients of list ORACLE-L Ever considered trying out for fighter pilot in the chinese air force? I think

How to wrap old sqlplus reports with Java and output html

2001-04-16 Thread James Howerton
DBA's developers, We have several reports written in sqlplus with break on statements, calculations, etc. The Java guys are looking for an Oracle tool set or method to wrap the sql in a servlett and produce output in html without re-inventing the reports. They don't want to use 9iAS/Portal

Re:stupid DBA

2001-04-16 Thread dgoulet
Robert, I view life as a series of choices and consequences (yeah I know somewhat depressing). Therefore, If you voted and voted for someone other than Mr Bush, you can complain about him. I voted for Gore, so I do complain yes he is pretty stupid, but then his father was also so what do

Re:RE: stupid DBA

2001-04-16 Thread dgoulet
Well, here's my 2 cents on the server side stuff. From ComputerWorld: The University of North Carolina has finally found a network server that, although missing for four years, hasn't missed a packet in all that time. Try as they might, university administrators couldn't find the server.

RE: stupid DBA

2001-04-16 Thread Weaver, Walt
Cool. Thanks for the info, Stephen. I'll let you know how it goes. --Walt Weaver Bozeman, Montana, USA -Original Message- Sent: Monday, April 16, 2001 10:20 AM To: Multiple recipients of list ORACLE-L Walt: I think you won't be too upset with Linux. At my previous job, part of my

Re: stupid DBA

2001-04-16 Thread Rodd Holman
LOL!! Thank you Mladen, you helped a very bleak Monday become a little brighter. -- Rodd Holman Oracle DBA (605) 988-1373 [EMAIL PROTECTED] Comments made are my own opinions and views. They do not represent views, policies, or procedures of LodgeNet Entertainment Corporation On Monday 16

RE: Database Cache of Oracle9ias

2001-04-16 Thread Thomas Jeff
Title: RE: Database Cache of Oracle9ias What platform? On AIX there's a bug with respect to extproc that will give you this error. Jeff T [EMAIL PROTECTED] -Original Message- From: Oracle DBA [mailto:[EMAIL PROTECTED]] Sent: Friday, April 13, 2001 5:21 PM To: Multiple recipients

RE: RMAN

2001-04-16 Thread Claudio Roca
Try $rman TARGET system/manager@tar RCVCAT rman/rman@cat - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, April 13, 2001 7:05 PM I am trying to setup rman.The catalog database(cat) and target database(tar) are running on Oracle 8.1.5.

RE: RMAN doubts

2001-04-16 Thread Claudio Roca
Sorry to bother you, i was using RMAN to backup to disk for over 1 year, but we need to backup to tape, so, i had to install Legato. I'm having some troubles, and i only want to know if you also experienced the same troubles. I can do backup to sbt_tape, but i can't read the saved files. I

RE: Very Urgent -- Please Help

2001-04-16 Thread Claudio Roca
I did over 10 V7 databases to V8.1.6 upgrade, no matter database size, it always tooked me 40 minutes to upgrade plus catalog and catproc scripts runtime. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 12, 2001 2:51 PM Hi

Where do I find the patch script on the install CD ?

2001-04-16 Thread Pat Brenda Howe
I just finished installing Oracle8.0.6 on a SUN SPARC ULTRA 5. The install cd is : Oracle8 Enterprise Edition Release 8.0.6.0.1 After the install I query v$version and I notice that I have version 8.0.6.0.0 Where do I find the patch on the CD (or the local Oracle Home Directory) to bring it from

RE: stupid DBA

2001-04-16 Thread Khedr, Waleed
Disk corruption or failure. I hope you have a good backup for the recovery! -Original Message- Sent: Friday, April 13, 2001 6:46 PM To: Multiple recipients of list ORACLE-L Stupid "BUSH" time! Stupid US people select Bush as president. Stupid DBAs. Stupid job mkt. Stupid software

RE: crontab script problem

2001-04-16 Thread Miller, Jay
When running a script from cron we first execute a script that sets all the environment variables. Here's the code we use: #SET DATABASE ENVIRONMENT VARIABLES FOR DATABASE nyccp. DSM 2/6/96 # PATH=/oracle/oper:/oracle/product/8.0.4/lib:.:/opt/SUNWspro/bin:/usr/bin/sbi n:/e

Re: Where do I find the patch script on the install CD ?

2001-04-16 Thread Bill Gentry
I have never seen a patch set on the Installation CD. I've always had to download it from Metalink. HTH Bill Gentry DBA Allina Health System Minneapolis, MN 55403 612-775-1190 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent:

RE: stupid DBA

2001-04-16 Thread Eric D. Pierce
Well, according to the stereotype, they aren't very good drivers, so maybe it was inevitable. ep [EMAIL PROTECTED] 04/14 6:15 PM How was it mean? Considering how well they seem to do their job, it would be a heck of a lot easier to become a Chinese fighter pilot than a nurse. ...

RE: Database Cache of Oracle9ias

2001-04-16 Thread Oracle DBA
This is on Red Hat Linux.. Sushant --- Thomas Jeff [EMAIL PROTECTED] wrote: What platform? On AIX there's a bug with respect to extproc that will give you this error. Jeff T [EMAIL PROTECTED] -Original Message- Sent: Friday, April 13, 2001 5:21 PM To: Multiple

Urgent - Migration

2001-04-16 Thread Gilberto Gampert
Hello People! I migrate the Oracle 7.3.4.5 to Oracle 8.1.6.0.0, in the following way: 1) I exported the data 2) I removed off Oracle 7 3) I installed Oracle 8 4) I imported the data The problem is that began to appear the following error in the alert.log: --- Mon Apr 16 15:43:19 2001 Errors in

index query

2001-04-16 Thread Seema Singh
Hi Dbas I have following query regarding index. 1)how to defragment the index except export/drop/create/import option 2)I have seen my index tablespace it is growing fast as compare to data tablespace even. Please advice what I do. Thanks -seema

Do not belive BUSH and your army goverment so much

2001-04-16 Thread Robert Chen
right now, I understand US people also just belive TV or news. The news always controlled by goverment or service for the goverment. This fact is for sure that US is high-handed and arbitrary. US army fly to all over the world and control all the world. I hate this but I feel so frustrated that

Re: Urgent - Migration

2001-04-16 Thread Connor McDonald
You're probably ok - this is more likely a bug in 8.1.6 (there are many which cause 7445's and 600's). Next step would be to add patches to (at least) 8.1.6.2, probably 8.1.6.3+ hth connor --- Gilberto Gampert [EMAIL PROTECTED] wrote: Hello People! I migrate the Oracle 7.3.4.5 to Oracle

RE: Do not belive BUSH and your army goverment so much

2001-04-16 Thread John Lewis
Perhaps we should keep ideologies/politics off of this list. If anyone (Chinese or American) wants to debate they are lots of other lists set up for that. Take it there. I'm here for Oracle not bashing. regards - john f. lewis -Original Message- Sent: Monday, April 16, 2001 2:21 PM

datatype query

2001-04-16 Thread Seema Singh
Hi Dbas Which datatype is used for inserting picture and sound in Oracle 8.1.7 and how? Thanks -seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ:

RE: Urgent - Migration

2001-04-16 Thread Claudio Roca
i migrated 10 oracle 7.3 to 8.1.6 and no need to do al that.. i only run ODMA, and checked an Oracle documentation out . It took me 40minutes to migrate, becaz Odma only create a new oracle 8 dictionary, and then populates the old v7 dict to the new v8 dict. If you have v7 backup, you could

RE: Do not belive BUSH and your army goverment so much

2001-04-16 Thread Glenn Travis
We get enough email on this list already. List, please do not start down this road and respond to this. It will go on forever as it is of political and opinion based nature. Let's nip this off topic thread now. carry on. FWIW: I neither agree nor disagree with the poster's comments. I know

Re: Urgent - Migration

2001-04-16 Thread Cherie_Machler
Gilberto, We got very similar errors when upgrading from 8.0.4 to 8.1.5 and then to 8.1.7. In both cases, we opened a TAR with Oracle and they asked us to turn off the star_transformation_enabled init.ora parameter as a workaround. We did and it made our errors go away. However, this is not

RE: Do not belive BUSH and your army goverment so much

2001-04-16 Thread Dasko, Dan
Dude, take a pill. Yup, that's us alright. Just mindless sheep that believe everything we're told by the big bad Military/Industrial/Media Complex. And we control the entire world. Stop telling everyone. That's supposed to be a secret. I have no doubt that the Chinese people are a peace

Re: Do not belive BUSH and your army goverment so much

2001-04-16 Thread Rodd Holman
Robert, Before you get too self righteous consider some of the following: International law sates that countries can claim 12NM of air/sea space from their coast lines. There is a significant difference between 12NM and 200NM as claimed by China. There is also a significant difference between

RE: Do not belive BUSH and your army goverment so much

2001-04-16 Thread Kimberly Smith
I am neither Chinese or American however, you are doing exactly what you just accused every American of doing. -Original Message- Sent: Monday, April 16, 2001 2:21 PM To: Multiple recipients of list ORACLE-L right now, I understand US people also just belive TV or news. The news

OT: RE: Do not belive BUSH and your army goverment so much

2001-04-16 Thread Stephen Andert
Thanks. Trying to keep caught up on the list is hard enough when the "noise" ratio is low, very frustrating with all this unlabeled offtopic garbage. My 2 cents... Stephen [EMAIL PROTECTED] 04/16 3:35 PM We get enough email on this list already. but I refuse to talk politics and world

RE: Exp/Imp Fromuser/Touser Security

2001-04-16 Thread Hagedorn, Linda
Title: RE: Exp/Imp Fromuser/Touser Security If the sys password file was chmod 400, only the owner can read it. And, the next time it has to be changed, it would have to be changed in a single place to be picked up by any calling script. Crons are owned by the same userid, so it all works

Re: Do not belive BUSH and your army goverment so much

2001-04-16 Thread Robert Chen
You will not hesitate to think that US is the strongest Country in this world. At least I am the only survive in this msg board. Sigh! It's difficult to achieve anything without support. - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, April

RE: datatype query

2001-04-16 Thread Jack C. Applewhite
Seema, BLOB. Carefully. See "Oracle8i Application Developer's Guide - Large Objects (LOBs)". Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] -Original

Re: datatype query

2001-04-16 Thread Rodd Holman
This would be a BLOB, or you could use BFILE. On Monday 16 April 2001 17:10, Seema Singh wrote: Hi Dbas Which datatype is used for inserting picture and sound in Oracle 8.1.7 and how? Thanks -seema _ Get your FREE download of

RE: Do not belive BUSH and your army goverment so much

2001-04-16 Thread Zhong Hong
Title: RE: Do not belive BUSH and your army goverment so much Please! I didn't subscribe to this list to read all these. I'm a Chinese. But I think there is no need for bitterness here. To me, this is more a political game than anything else and I have no interest knowing. Thank you.

Re: Do not belive BUSH and your army goverment so much

2001-04-16 Thread Kevin Kostyszyn
Jeez all, lets take a chill pill. A mistake happened and it really sucked, and there are a million different opinions out there about it, but lets not start bashing eachothers countries and backgrounds and such. We all know the media sucks, we could bash on that for a little while! -

Re: stupid DBA

2001-04-16 Thread Michael Sun
Not to add fuel to fire, and I DO wish we kill trees (or electrons) on more enjoyable subjects than geopolitics or racism, however, I have the following to say, as a person of chinese ancestry. 1) As a member of an ethnic group that is still subjected to discrimination in today's America,

Re: Do not belive BUSH and your army goverment so much

2001-04-16 Thread David A. Barbour
Okay Robert, you've had you 15 minutes of fame. Too bad it made you look so silly. Jared, humor was banished (although it tends to flourish with tongue-in-cheek replies), how about political diatribes (or at least the political diatriber - is that a word?)? Regards, David A. Barbour Oracle

Re: Do not belive BUSH and your army goverment so much

2001-04-16 Thread Jared Still
Yes, the list owner and others would appreciate it. Also, use of the crude language contained in the original post can get you removed from the list. And as I'm currently unemployed, I have a lot of time to monitor this list. :) Jared Still On Monday 16 April 2001 15:01, John Lewis wrote:

OT Re: Do not belive MUSH and your POPCORN goverment so much

2001-04-16 Thread Eric D. Pierce
Celebrate the entreprenurial spirit: http://www.popcornfork.com/ excerpt: --- "CAUTION Ordering and using the POPCORN FORK will automatically cancel your membership in the FLAT WORLD SOCIETY! You may be ridiculed, and put upon by the less enlightened. Your best friends may

Input Cardinalities into dictionary for Optimizer Behaviour

2001-04-16 Thread Murali Vallath
To obtain a good analysis of a SQL statement especially in a new development environment, based on the environment that it is to be deployed on, it would good to sometime reflect/simulate the production volume. Is there a way to input table cardinalities directly into the data dictionary so

Meeting at IOUG

2001-04-16 Thread Murali Vallath
Are any of the floks from the list meeting during the IOUG-A live in Florida. I am attending and would like to join the meeting. Murali Vallath _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see

Re: Meeting at IOUG

2001-04-16 Thread Rachel Carmichael
don't know that any meeting has been scheduled, I do know that a number of the members of the list are presenting and I intend to be at most of those sessions :) on the other hand, Gaja's sessions tend to draw EVERYONE so you can be sure of meeting others on the list there From: "Murali

Re: Meeting at IOUG

2001-04-16 Thread Joseph S. Testa
I'll be there. Joe Murali Vallath wrote: Are any of the floks from the list meeting during the IOUG-A live in Florida. I am attending and would like to join the meeting. Murali Vallath _ Get your FREE download of MSN

RE: OPS waits

2001-04-16 Thread VIVEK_SHARMA
O.P.S. Setup in Benchmark Runs :- -- 2 DB Servers - ES40 Alpha machines - 4 CPUs , 8 GB RAM - O.S. DEC 5.1 1st APP Server - ES40 Alpha machines - 4 CPUs , 8 GB RAM - O.S. DEC 5.1 2nd APP Server - SUNe420R - 4 CPUs , 4 GB RAM - Solaris 2.6 3rd APP Server -