RE: Please Help - ora error

2001-08-16 Thread G, Subrahmanyam (CAP)
Hi In case of Temporary Tablespace the Initital segemnt and next segment should be equal to the sort_area_size parameter. bye G.Subrahmanyam -Original Message- Sent: Thursday, August 16, 2001 8:28 PM To: Multiple recipients of list ORACLE-L Hello all, I have a strage error. 'ORA-01

Re: Which view maintain droped constraint record?

2001-08-16 Thread Galen Boyer
On Thu, 16 Aug 2001, [EMAIL PROTECTED] wrote: >> > Which view is required to check if any constraint has beed >> > droped? means which Data dictionary table maintain >> > constraint drop record? >> >>DBA_CONSTRAINTS >> >>Here is where you can find out about it and its friends. >> >>http://otn.ora

RE: Deep Doo-Doo

2001-08-16 Thread C.S.Venkata Subramanian
Hi, I tried to view the TAR posted by you, But it said that I don't have sufficient privileges to view the TAR. Can u pl send me a copy of the TAR 1766421.999. TIA venkat -- On Thu, 16 Aug 2001 05:10:58 Farnsworth, Dave wrote: >I did this from svrmgrl. The database was shutdawn at the time

Re: Which view maintain droped constraint record?

2001-08-16 Thread Seema Singh
hi DBA_CONSTRAINTS describes all constraint definitions in the database not maintain droped constraint. >From: Galen Boyer <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: Which view maintain droped constraint record?

Re: Which view maintain droped constraint record?

2001-08-16 Thread Seema Singh
hi DBA_CONSTRAINTS describes all constraint definitions in the database not maintain droped constraint. >From: Galen Boyer <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: Which view maintain droped constraint record?

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

2001-08-16 Thread Galen Boyer
On Thu, 16 Aug 2001, [EMAIL PROTECTED] wrote: > when I use svrmgrl to shutdown the instance and then try to > start it up, it complains because the init file does not exist > in %ORACLE_HOME%\pfile use the "-pfile c:\mine\initMINE.ora" option when starting up using svrmgrl. > BUT the oradim DID

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

2001-08-16 Thread Galen Boyer
On Thu, 16 Aug 2001, [EMAIL PROTECTED] wrote: > I do not remember how to define a procedure in a package > definition so that it is executed every time the package is > called. I haven't created packages, but I thought you didn't call a package. I thought you called a "method" of a package.

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

2001-08-16 Thread Reardon, Bruce (CALBBAY)
Babette, I'm not sure if I have read this anywhere but I think that the registry entry (as created by oradim) might be used when the service is started. However, when using startup the Oracle executable looks in %oracle_home%\database for the file initMINE.ora. What I do is create a file called

Re: Please Help - ora error

2001-08-16 Thread Galen Boyer
On Thu, 16 Aug 2001, [EMAIL PROTECTED] wrote: > 'ORA-01658: unable to create INITIAL extent for segment in > tablespace TEMP'. This is saying that Oracle is trying to use the TEMP tablespace for some, temporary work, but it can't gain control of anymore space. [...] > ORDER BY executions desc

Re: characterset problem

2001-08-16 Thread Galen Boyer
On Thu, 16 Aug 2001, [EMAIL PROTECTED] wrote: > But how does sqlnet comes into picture when we use OAS ? Also > how does nls language in dad affect the application ? Hm... Not sure. I guess there is no need for sqlnet if coming through OAS? Hm... I guess my experience isn't really able to hel

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

2001-08-16 Thread Babette Turner-Underwood
Title: RE: No TNSListner service after intall 8.1.7 on Win 2k As everyone in this thread seems so knowledgeable about NT, I would like to digress and ask a related question.   When I use oradim to create a service, oradim -new -sid MINE -pfile c:\mine\initMINE.ora   The service is creat

RE: OT - Vaccines

2001-08-16 Thread MacGregor, Ian A.
Mercury is a component of thimerosal which was used to preserve vaccines. The vaccines being manufactured today in the U.S. do not have thimerosal except for DTAP. It seemed someone noticed we were injecting our children with more Mercury then the EPA allows; thus the move to get the Mercury

Re: Openworld Abstracts

2001-08-16 Thread Rachel Carmichael
well it looks like some good ones on the DBA track, heavily Oracle employees though. But there are some I'm definitely going to want to see. >From: "Adams, Matthew (GEA, 088130)" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >S

Re: A high-availability question (standby , replication or ....)

2001-08-16 Thread Babette Turner-Underwood
Ahh but it does not have to sit there just waiting !!! We had a DEC TruCluster, with the ASE failover software (available software everywhere). This was NOT OPS We still used our failover box but for less powerful and less critical app. We decided that during failover, we could tolerate sligh

Re: Open World Entertainment

2001-08-16 Thread Rachel Carmichael
ooh ooh, if I don't correct the quiz you write for Amazon this year, can I get a ticket? hey -- did they accept your abstract? >From: Jeremiah Wilton <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: Open World Enter

Re: Checking Oracle user Process in unix

2001-08-16 Thread Babette Turner-Underwood
No,  Not quite right. Oracle WILL spawn a process if you are using dedicate server processes. It will ONLY NOT spawn the process if you are using MTS   (well technically it could, if it needed an additional server process and you were not yet at the max_servers value but I digress..

Re: Open World Entertainment

2001-08-16 Thread Rachel Carmichael
not a clue as yet... they tend not to say anything about it. Last year it was a performance by Lenny Kravitz >From: "Smith, Ron L." <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Open World Entertainment >Date: Thu, 16 Au

RE: OT - Vaccines

2001-08-16 Thread Rachel Carmichael
I'm sure there are (but I'm betting that they are making it very difficult to prove it) >From: "Mohan, Ross" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: OT - Vaccines >Date: Thu, 16 Aug 2001 14:09:05 -0800 > >I bet

Re: Delete followed by Select Count(1) - SLOW

2001-08-16 Thread Rachel Carmichael
truncate resets the highwater mark delete does not, at least not until you have done the count... at that point the highwater mark is reset >From: Walter K <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Delete follow

8.1.7/HP-UX 11/Package Question #2

2001-08-16 Thread Vergara, Michael (TEM)
Hi Again: Boy...it's been a while since I did this kind of PL/SQL - packages! I do not remember how to define a procedure in a package definition so that it is executed every time the package is called. Can someone point me to the doco for this? Or give me a hint? Thanx, Mike --- =

Please Help - ora error

2001-08-16 Thread Viraj Luthra
Hello all, I have a strage error. 'ORA-01658: unable to create INITIAL extent for segment in tablespace TEMP'. The clients TEMP tablespace is 200M. The sql is:- SELECT a.username, length(sql_text), substr(sql_text,1,100) as "SQL TEXT", substr(sql_text,101,250) as "Second TEXT", substr(sql_t

RE: OT - Vaccines

2001-08-16 Thread Hagedorn, Linda
Title: RE: OT - Vaccines The NY laws allow for religious exemption from vaccinations in the school system: www.health.state.ny.us/nysdoh/immun/guide/immguid.pdf, page 16, "NYS Requirements for School and Post-Secondary Institution Attendance".  While the state school representatives may thin

RE: No TNSListner service after install 8.1.7 on Win 2k

2001-08-16 Thread Reardon, Bruce (CALBBAY)
Hi, On NT / W2K to get a listener service I have found that you need 2 things: 1 - a (valid) listener.ora file (may be optional but certainly needed if you want a correctly functioning listener) 2 - from a CMD prompt issue the "lsnrctl start" command and this will create the service for the liste

Re: Delete followed by Select Count(1) - SLOW

2001-08-16 Thread Deepak Thapliyal
Hi Jonathan, Can you tell us a little bit more about delayed block cleanouts .. if you can Thx Deepak --- Jonathan Lewis <[EMAIL PROTECTED]> wrote: > Apart from the comments other posters > have made about truncate and the HWM, > bear in mind that a scan after deleting 100,000 > rows would prob

8.1.7/HP-UX 11/Package Question

2001-08-16 Thread Vergara, Michael (TEM)
Hi All: We just upgraded our primary database from 8.0.5 to 8.1.7. I've heard in 8i that packages and procedures can now be created which can be executed as a user other than the one who owns the procedure. I haven't messed with this capability yet, but I have a question... If I create a pack

Re: Delete followed by Select Count(1) - SLOW

2001-08-16 Thread Jonathan Lewis
Apart from the comments other posters have made about truncate and the HWM, bear in mind that a scan after deleting 100,000 rows would probably be doing a lot of delayed block cleanout - resulting in plenty of redo log, and possibly a lot of dbwr activity. Jonathan Lewis Seminars on getting the

Re: Open World Entertainment

2001-08-16 Thread Scott Shafer
Gimme a microphone, Ross' cleaned speedo, a feather boa, and 5-6 long island iced teas... --Hannibal Jr. "Smith, Ron L." wrote: > > Does anyone know what the Wednesday night entertainment will be at Oracle > Open World this year? _ Do Yo

RE: OT - Vaccines

2001-08-16 Thread Mohan, Ross
right...a kid near dirty water...poor hygiene...poor nutrition... well, that kid might benefit from the vaccine for a malaria or what have you that runs rampant in Mexico. Now, in NYC, when was the last case of malaria? And, if you saw it, it would likely be *far* less virulent. (Read "Evo

Re: Open World Entertainment

2001-08-16 Thread Jeremiah Wilton
On Thu, 16 Aug 2001, Smith, Ron L. wrote: > Does anyone know what the Wednesday night entertainment will be at Oracle > Open World this year? Me. I'll be playing "Waltzing Matilda" on my accordion in the Marriott sports bar. I hear there's already a thriving black market for tickets. -- Jeremi

Open World Entertainment

2001-08-16 Thread Smith, Ron L.
Does anyone know what the Wednesday night entertainment will be at Oracle Open World this year? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Cal

RE: OT - Vaccines

2001-08-16 Thread Mohan, Ross
lol.. I just get more interested in doing my own research and forming my own beliefs the older i get. Worked for me in DBA trenches...it's working for me in life. but.."doctor".naw... lol -Original Message- Sent: Thursday, August 16, 2001 6:16 PM To: Multiple recipi

Diffs in SQL*Plus formatting between 8/8i

2001-08-16 Thread Jesse, Rich
Hey all, One other slightly puzzling, erm, puzzle. The default column format seems to have changed between 8.0.6 and 8.1.7 in SQL*Plus, but I can't seem to figure out what it is or find any mention of it in any Oracle doc. We aren't using any "login.sql" files. It doesn't really bug me because

RE: A high-availability question (standby , replication or ....)

2001-08-16 Thread Kevin Lange
HACMP on AIX works the same way. It is more complex like I said to setup and run. But the failover abilities are Great. But it was expensive. Lots of dual hardware that just sat there waiting for a failover. -Original Message- Sent: Thursday, August 16, 2001 5:04 PM To: Multiple recip

RE: OT - Vaccines

2001-08-16 Thread Kevin Kostyszyn
Yeah Dr. Ross... you get'em:) KK -Original Message- Sent: Thursday, August 16, 2001 5:49 PM To: Multiple recipients of list ORACLE-L "...Children who have evidence of immunity as demonstrated by laboratory confirmation of immunity or a reliable medical history of disease are exempt from

Re: characterset problem

2001-08-16 Thread Big Planet
But how does sqlnet comes into picture when we use OAS ? Also how does nls language in dad affect the application ? BigP - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, August 16, 2001 12:19 PM > On Thu, 16 Aug 2001, [EMAIL PROTECTED

Re: Delete followed by Select Count(1) - SLOW

2001-08-16 Thread JOE TESTA
HWM, oracle will search up to the high water mark when doing a count, like you proposed, so if you're gonna delete all of the rows anyways, save time(now and later) by doing the truncate.   joe >>> [EMAIL PROTECTED] 08/16/01 05:32PM >>>I have a user that deleted all of the rows in a table(i.e

RE: Comment on 'Practical Oracle 8i'

2001-08-16 Thread Stephen Andert
That's nothing, I've got 3 486's in my garage.    Stephen     If you have any questions, please feel free to call me or drop me a note.   Stephen Andert480-445-2506>>> [EMAIL PROTECTED] 08/16/01 01:06PM >>> i got a 75Mhz pentium sitting in my desk drawer :)   joe >>> [EMAIL PROTECTED] 08/16/

Re: OT - Vaccines

2001-08-16 Thread Scott Shafer
Same here. Besides, this close to the border, I get to see the results of no vaccinations with regularity. I'll give my kids the shots. Scott Shafer San Antonio, TX Rachel Carmichael wrote: > > yes there are exceptions and you don't HAVE to give your child the vaccine. > > on the other hand

Performance Problem...

2001-08-16 Thread Richard Huntley
While stress testing a batch report created using a Java Servlet against 8.1.5 on Solaris 2.6, initially a large report was taking 1 hour and 20 minutes. After performing a trace on the application, I discovered that no database activity was occurring at all, which was also evident by the cpu be

RE: OT - Vaccines

2001-08-16 Thread Mohan, Ross
I bet you a scotch there are religious exemptions in NYC, too, RC. :) -Original Message- Sent: Thursday, August 16, 2001 5:48 PM To: Multiple recipients of list ORACLE-L yes there are exceptions and you don't HAVE to give your child the vaccine. on the other hand, NYC will not allow

RE: Delete followed by Select Count(1) - SLOW

2001-08-16 Thread Vergara, Michael (TEM)
Truncate basically resets the table's highwater mark to 0. Deletes don't do that. A 'select count(*)' does a full table scan, which much touch all the blocks up to the HWM, and that's what's taking the time. The REUSE STORAGE option keeps the extents allocated to the table, but the HWM is stil

RE: Delete followed by Select Count(1) - SLOW

2001-08-16 Thread Christopher Spence
Yes, It has been known if you delete all records, use a truncate and not delete. Otherwise it will still behave like it is full as it has to touch all the extents. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have th

Re: A high-availability question (standby , replication or ....)

2001-08-16 Thread Rama Malladi
MC/Serviceguard in HP. This offers availability for the database as well as application. Standby is a good alternative. Risk with Standby is fail-over is manual and user intervention required, also keeping the Standby in Sync is a problem. MC/Serviceguard allows you to have multiple boxes in the c

Openworld Abstracts

2001-08-16 Thread Adams, Matthew (GEA, 088130)
Title: Openworld Abstracts It looks like the abstracts for Openworld 2001 are now online,  for those of you who might be attending (not me, I have enough trouble convincing management to send me one conference). http://www.oracle.com/openworld/us/conference Matt Adams - GE Applianc

RE: Rollback after truncate?? + 2 more questions :-)

2001-08-16 Thread Csillag Zsolt
Tom, Thank you for your answer - it has solved my problem. At 05:11 2001.08.16. -0800, you wrote: >Zsolt, > >The correct call for the function if the function exists within the package >would be: > > Insert into A > ( Select Col1 ,PackageName.MyFunction(Col1) > from B ); > >Tom

RE: OT - Vaccines

2001-08-16 Thread Mohan, Ross
"...Children who have evidence of immunity as demonstrated by laboratory confirmation of immunity or a reliable medical history of disease are exempt from such requirement" || This says, basically, that is it really ambiguous.lol "After July 1, 2001, all children who have not ye

Re: Delete followed by Select Count(1) - SLOW

2001-08-16 Thread Deepak Thapliyal
Hi Walter, The extents you refer to in ur thread is the allocated space. Oracle by default scans upto the high watermark. The reason truncate is fast is cause it resets the high watermark so oracle did not scan anything for u when it returned 0 rows .. however in case of delete, it still scanned

RE: OT - Vaccines

2001-08-16 Thread Rachel Carmichael
yes there are exceptions and you don't HAVE to give your child the vaccine. on the other hand, NYC will not allow you to register your child for school if you cannot show proof of vaccination. And if you don't send your child to either public school, private school or prove that you are homesch

NT: howto create a listener service

2001-08-16 Thread Paul Drake
at a command prompt, type C:\> lsnrctl start error 1060 - will create a service. This assumes that you have a listener.ora in the folder %ORACLE_HOME%\Network\Admin\ and that the listener name is "LISTENER". This is a good thing to add to a db_create.bat that the dbca does not include, as it

Delete followed by Select Count(1) - SLOW

2001-08-16 Thread Walter K
I have a user that deleted all of the rows in a table (i.e. 100,000), waited for it to complete, and then ran a SELECT COUNT(1) FROM . It took a few minutes for '0 rows' to be returned to the prompt. The table has ~60 extents (128k ea.). Granted, the number of extents is excessive but it's a devel

OT RE: Comment on 'Practical Oracle 8i'

2001-08-16 Thread Mohan, Ross
ROFL -Original Message-From: Kathy Duret [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 16, 2001 4:45 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Comment on 'Practical Oracle 8i' Bet you say that to all the girls ;)   Kathy   -Original M

Re: Ways to improve speediness of truncate, drop, coalesce

2001-08-16 Thread Jonathan Lewis
If you are going to drop all tables, the best bet is to use a PL/SQL loop which does: for r1 in (select table_name, tablespace_name from user_tables where ...) dbms_utility.exec_ddl_statement('drop table ' || r1.table_name); dbms_utility.exec_ddl_statement('alter tablespace ' || r1.table

RE: OT - Vaccines

2001-08-16 Thread Mohan, Ross
yikes.the immune system is fabulously complexsecond in complexity only to the brain itself...and it is still very very much in development at early ages...this is why kids -- all kids -- get more colds, etc than us older folks...the system is literally "learning" for the first few years or

query performance

2001-08-16 Thread Harvinder Singh
Hi, I am running the follwoing query and it is running very slow: select * from v_mci_com_leader_summary where accountid=1011 and intervalid=1490 EXPLAIN PLAN looks like: ID Query Plan -- --- 0 SELECT STATEMENTC

Re: changing long col to varchar and vice versa

2001-08-16 Thread DBarbour
Export and Import David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Schoen Volker

RE: OT - Vaccines

2001-08-16 Thread MakoSoft
Okay, I think we can both eat some words. It is legislated, but there are religious or physical endangerment clauses (Title 32, Chapter 1, Section 46): http://leg1.state.va.us/cgi-bin/legp504.exe?000+cod+32.1-46 http://www.elkokidsdoc.com/Pages/WellChild/W_Ex_ChickPox.html This second site

RE: Comment on 'Practical Oracle 8i'

2001-08-16 Thread Glenn Travis
Title: Message I have 2 p133 pcs at home (one running win98 for kids games, the other running linux mandrake).    can you believe buy.com was selling 512MB PC133 SDRAM for <$50 yesterday?! (it was their dealoftheday special and not the cheap stuff either).  wow!  we've come along way since I

RE: No TNSListner service after install 8.1.7 on Win 2k

2001-08-16 Thread Cale, Rick T (Richard)
Thanks for the input. I am going to have a database but I did not want the starter database I want to create my own. A tnslistener service should get created regardless of whether I opted for the starter database or not. Thanks Rick -Original Message- Sent: Thursday, August 16, 2001 4:13

Re: Which view maintain droped constraint record?

2001-08-16 Thread Galen Boyer
On Thu, 16 Aug 2001, [EMAIL PROTECTED] wrote: > Which view is required to check if any constraint has beed > droped? means which Data dictionary table maintain constraint > drop record? DBA_CONSTRAINTS Here is where you can find out about it and its friends. http://otn.oracle.com/docs/products

RE: Comment on 'Practical Oracle 8i'

2001-08-16 Thread Kathy Duret
Bet you say that to all the girls ;)   Kathy   -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 16, 2001 1:06 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Comment on 'Practical Oracle 8i' i got a 75Mhz pentium sitting in my desk

RE: No TNSListner service after install 8.1.7 on Win 2k

2001-08-16 Thread Mercadante, Thomas F
ORACLE_SID is not listed in my Registry anywhere, but ORACLE_HOME is (816 on NT). As I said, ORACLE_SID does not get created automatically by any piece of Oracle software that I know of. You may create it by hand in environmental settings in Control Panel|System|Advanced. ORADIM can create servi

OT - RE: Comment on 'Practical Oracle 8i'

2001-08-16 Thread Vergara, Michael (TEM)
Title: RE: Comment on 'Practical Oracle 8i' I agree.  I recently upgraded my Eye Doctor's office server from a 386-25 with 4M of RAM and 300M of disk to an NT server.  I think she liked the older system better, to no surprise.  I ran 5 terminals from that machine with the Pick O/S and it work

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

2001-08-16 Thread Bill Conner
At 12:21 PM 8/16/01 -0800, you wrote: >On Thu, 16 Aug 2001, [EMAIL PROTECTED] wrote: > > >> Does any one know of tools available for running Unix on NT > >> besides MKS Unix. Preferably a shareware tool. > > As far as tools for bash on NT/W2K - I like cygwin - > > http://sources.redhat.com/cygwin

Antique Processors [RE: Comment on 'Practical Oracle 8i']

2001-08-16 Thread Deshpande, Kirti
I still have my 486 / 33MHz PC with 220 MB SCSI drive for a few odd things :) - Kirti > -Original Message- > From: JOE TESTA [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, August 16, 2001 3:06 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Comment on 'Practical Oracle

Re: OT - Vaccines

2001-08-16 Thread Scott Shafer
Give the kid some baby motrin or baby tylenol prior to the shot. Works wonders. I've got two who just got a round of vaccinations this week. Scott Shafer San Antonio, TX Kathy Duret wrote: > > Thanks for the link. As a new parent of a 4 month old, I am always looking for >things to read a

OEM change manager

2001-08-16 Thread JOE TESTA
Anyone using this consistently, i've just started to use it to compare prod <-> dev and its pretty kewl.   joe  

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

2001-08-16 Thread Galen Boyer
On Thu, 16 Aug 2001, [EMAIL PROTECTED] wrote: >> Does any one know of tools available for running Unix on NT >> besides MKS Unix. Preferably a shareware tool. > As far as tools for bash on NT/W2K - I like cygwin - > http://sources.redhat.com/cygwin I second this choice. Unix and Windows togeth

RE: Comment on 'Practical Oracle 8i'

2001-08-16 Thread DBarbour
Hey - Linux rocks on a 486DX2-66. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Gogala,

RE: Usage of Number type for table columns - Thanks to all

2001-08-16 Thread Rao, Maheswara
Thank you all who took the time to answer the above question. Now, I am going to allow columns types as floating. I copied all the replies to this question so that somebody could benefit from this. Once again thanks to Dick Goulet, Kevin Lange, David A. Barbour, Galen Boyer. Replies to the abo

Allow only certain ports for sql*net traffic

2001-08-16 Thread Cale, Rick T (Richard)
Hi DBAs, I asking on behalf of another user so bear with me. They are running Oracle 7.3.x and they want to restrict certain ports for sql*net traffic. Currently when a client makes a sql*net connect it spawns another process another port for sql*net traffic. Is there some oracle configuration

RE: OT - Vaccines

2001-08-16 Thread Kathy Duret
Thanks for the link. As a new parent of a 4 month old, I am always looking for things to read about newborns. Some Health centers (Long Beach, CA) are now requiring children to have TB shots before they can be entered into day care. My pediatrician refuses (thankfully) to do it before 6 mon

RE: Comment on 'Practical Oracle 8i'

2001-08-16 Thread Adams, Matthew (GEA, 088130)
Title: RE: Comment on 'Practical Oracle 8i' What wrong with a 100MHz Pentium?  I still do a lot of LaTex work (and other stuff) on a 386-25.  As long as the machine serves your needs and works, use it. > > > > For example.  100MHz Pentium is no where near 1/15 the speed > > of the 1.5GHz >

RE: Comment on 'Practical Oracle 8i'

2001-08-16 Thread Christopher Spence
Title: Message I just sold 5 166Mhz pentiums chips and heat sinks for $18 at show 2 weeks ago :)     "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322

RE: No TNSListner service after install 8.1.7 on Win 2k

2001-08-16 Thread tday6
I'll give this a whack though I suspect that there are people who could do a better job. The Windows registry is the conceptual equivalent of the UNIX environmental variables. ORACLE_SID, ORACLE_HOME, etc can be found under HK_LOCAL_MACHINE\Software\Oracle. You can change these using REGEDIT; h

Disk Names - sdXX vs. cXtXdXsX

2001-08-16 Thread Walter K
Is there a method or utility to translate disk names reported by sar from the sdXX format to the cXtXdX format? I'm on a Sun platform. Many thanks in advance. -w __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messe

OT - Vaccines

2001-08-16 Thread Mohan, Ross
It's probably NOT "state law", but "mandated" by the State Health Office, an unelected, non-academic bureau w/in State Govt. Of course, if you can provide the law (code and section) from the Commonwealth Law that shows this, I'll eat my words (virtually, of course!) :-) something like 40 stat

Which view maintain droped constraint record?

2001-08-16 Thread Seema Singh
Hi Which view is required to check if any constraint has beed droped? means which Data dictionary table maintain constraint drop record? Thanks in advance. -Dinesh _ Get your FREE download of MSN Explorer at http://explorer.msn.com/

RE: OT - Vaccines

2001-08-16 Thread Hagedorn, Linda
Title: RE: OT - Vaccines Remember, there is always a medical exception to any vaccine.   If someone has said, 'It's required', remember the US is not a communist state.  They cannot hold you down and give you a vaccine, nor can they force you to have your children vaccinated.  They will also

RE: Comment on 'Practical Oracle 8i'

2001-08-16 Thread JOE TESTA
i got a 75Mhz pentium sitting in my desk drawer :)   joe >>> [EMAIL PROTECTED] 08/16/01 03:45PM -Original Message-> From: Christopher Spence [mailto:[EMAIL PROTECTED]]> Sent: Thursday, August 16, 2001 1:52 PM> To: Multiple recipients of list ORACLE-L> Subject: RE: Comment on 'Pr

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

2001-08-16 Thread Mercadante, Thomas F
Title: RE: No TNSListner service after intall 8.1.7 on Win 2k Rick,   I think Networking services means TNSNAMES/SQLNET.ORA stuff (like a client install).   You could do a custom install (I think) and just install TNS Listener, and not the starter database.   Tom Mercadante Oracle Certified

Re: OT Slam for the day: Re: Oracle DBA Needed in Greensboro,

2001-08-16 Thread Scott Shafer
If you don't like the messages, killfile the sender. Scott Shafer San Antonio, TX "Somebody needs to killfile somebody. I don't care who killfiles whom, but someone needs to do it." - Bill Roberts Ron Rogers wrote: > > I think that OraStaff is doing us a service by providing us as much infor

Tuning an Oracle/Unix file system - Sun/OS 5.6 Oracle v8.1.7.2

2001-08-16 Thread Brian MacLean
Title: Tuning an Oracle/Unix file system - Sun/OS 5.6 Oracle v8.1.7.2 Anybody play with tuning a UFS containing only Oracle datafiles? I'm interested particularly in the "tunefs -m ..." and the "mount forcedirectio ..." command options, but if you have other suggestions please note them. T

RE: What file(s) does Oracle read in deciding what has been insta

2001-08-16 Thread Grabowy, Chris
I was in a similiar situation. I was installing Oracle onto the D drive. But installation software created C:\Program Files\Oracle on the C drive to contain all the installation info/logs and current software installed list. So I had to delete the Oracle directory on the D drive and C:\Program Fi

RE: Help scheduling Hot Backup on NT...

2001-08-16 Thread Boivin, Patrice J
Is the Schedule Service shown as Running in the services applet in control panel? Just a thought. If yes, I agree with Bunyamin, what syntax are you using? Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services

RE: Comment on 'Practical Oracle 8i'

2001-08-16 Thread Gogala, Mladen
> -Original Message- > From: Christopher Spence [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 16, 2001 1:52 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Comment on 'Practical Oracle 8i' > > For example. 100MHz Pentium is no where near 1/15 the speed > of the 1.5G

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

2001-08-16 Thread Paul Drake
Hi Denmark, I really haven't been posting to the list at all lately. This one I can't pass up. Scott and myself here at PSS (now Encoda Systems) have prepared a set of batch jobs/scripts for configuring arch/exp/hot/cold/scheduling backups for NT/W2K (dictionary driven). They include the use of

RE: OT - Vaccines

2001-08-16 Thread MakoSoft
As having a few chicken pox scars (luckily in areas that are not seen) I understand this some. The vaccine also prevents Shingles later in life. Shingles normally happens in older people where your immune system is stressed/suppressed. It is quite painful. Even though I am not very old, I

Re: RE: What file(s) does Oracle read in deciding what has been insta

2001-08-16 Thread Jon Walthour
Delete the directory structure under C:\Program Files\Oracle, as well. That's where Oracle keeps the inventory information (among other things). Jon Walthour > > From: Christopher Spence <[EMAIL PROTECTED]> > Date: 2001/08/16 Thu PM 01:28:15 EDT > To: Multiple recipients of list ORACLE-L <[EMAI

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

2001-08-16 Thread Cale, Rick T (Richard)
Title: RE: No TNSListner service after intall 8.1.7 on Win 2k Ok, I am getting a little closer to figuring out what is going on. I did mis-state the type of install I did first. It was minimal installation without the starter database. This did NOT create a listener service. However it clear

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

2001-08-16 Thread Galen Boyer
On Thu, 16 Aug 2001, [EMAIL PROTECTED] wrote: > I ran into this as well. I figured I didn't need a listener on > my w2k box because everything was going to be local. > > However I couldn't connect via sqlplus gui without a listener > (no listener error - maybe because I am specifying the sid).

RE: Checking Oracle user Process in unix

2001-08-16 Thread Jyoti N
Whenever you say $sqlplus , Oracle spawns a dedicated server process to connect to database using Bequeath protocol (in this case) which bypasses the listener ,I guess. When you use the connect string(sqlplus@), Oracle connects thru the listener process/port(whatever), so probably, it does not requ

Re: OT: cryptography speech

2001-08-16 Thread tday6
Yup. VM/CMS on IBM mainframes would do the same. Scott Canaan <[EMAIL PROTECTED]To:

Re: Help scheduling Hot Backup on NT...

2001-08-16 Thread Bunyamin K. Karadeniz
I have experienced the same problem on NT 4 next week. When you do it from scheduler (not at command) , it is ok . The problem is AT command. not your script . Test what I say and see that I am right. bunyamin - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECT

Re: characterset problem

2001-08-16 Thread Galen Boyer
On Thu, 16 Aug 2001, [EMAIL PROTECTED] wrote: > Hi there , We have UTF-8 database. We are using OAS with UTF-8 > setting and java at front end connects to OAS socket to send > data to be inserted into oracle Is it required to convert data > send by Java to be converted to UTF8 ? OAS (OAS > NLS_L

RE: A high-availability question (standby , replication or ....)

2001-08-16 Thread Kevin Lange
Don't we all ... -Original Message- Sent: Thursday, August 16, 2001 1:33 PM To: Multiple recipients of list ORACLE-L ) > >Rachel is 100% right (do we ever expect differently ??) > you shouldn't... I make mistakes all the time __

RE: Speed up Truncate tables - rebuild index

2001-08-16 Thread Grabowy, Chris
Title: RE: Speed up Truncate tables - rebuild index Yes, the point of my message was simply a quick reminder to rebuild the indexes on a table that has been ALTER TABLE...MOVE moved.   I havent tested this, but I believe Lisa is right, in part, if the table is truncated, then moved, then why

Re: Re:RE: Index space not freed when rows deleted?

2001-08-16 Thread Jonathan Lewis
Comments in line Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 16 August 2001 18:38 |Jay, |

RE: RAID or NOT to RAID? What's the diff???

2001-08-16 Thread Eric D. Pierce
I would love to take a nice train trip for 3 or 4 days, up to canada, or across the desert and rocky mountains, and do some reading on the train. take a laptop to run test database? > > -- > > From: Hallas John <[EMAIL PROTECTED]> > Date: Tue, 14 Aug 2001 14:54:0

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

2001-08-16 Thread Haskins, Ed
Title: RE: No TNSListner service after intall 8.1.7 on Win 2k Lisa,   C:\> set ORACLE_SID=SID_NAME Then... C:\> set ORACLE_SID ORACLE_SID=SID_NAME   Ed Haskins Oracle DBA Verizon Wireless -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 16, 20

Re: Ways to improve speediness of truncate, drop, coalesce

2001-08-16 Thread tday6
Set the tablespace to some reasonable INITIAL and NEXT that accommodates all the objects with less than 100 extents per object. Let all the objects in the tablespace inherit their storage parameters from the tablespace. You will never have any fragmentation of the tablespace and will not need to

  1   2   3   >