Re: Oracle 9.2 spfile catch 22

2002-07-14 Thread Yechiel Adar
Yes, I can see the picture: PHB comes in with a new install: Hey Yechiel, install this and check it out. If it works OK you are going to be fired. YES SIR, I drop everything else and make myself unemployed. LOL Yechiel Adar Mehish - Original Message - To: Multiple recipients of list

Re: RE: larry want to take over your e-mai

2002-07-14 Thread Yechiel Adar
You wrote: From their point of view Research and Development is an expense (not an investment). My daughter used to work as a technical writer for a company that tried to sell a tool to created web sites. She left them some months ago. I asked her the other day if that company is still open and

Re: Re:RE: larry want to take over your e-mai

2002-07-14 Thread Yechiel Adar
Well, at least they already got out the program that warn the English that there is No Tea in their cup. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 11, 2002 11:14 PM Hannah, Friday is tomorrow, settle

Re: runInstaller

2002-07-14 Thread Yechiel Adar
Let me clarify a few things. 1) We are using only NT servers. 2) All the programs that need to be installed on the servers are installed by the NT system group. 3) They install the software only. 4) I do an initial install of patches and then turn to them instructions on how to install the

Just a question

2002-07-14 Thread César Aracena
Hi all, and sorry to bother. I joined this list because I want to get into the right track to Oracle DB Administration and Development. Actually, Ive never used Oracle but am interested in learning the most out of it from now. Ive been developing and administering mostly MySQL, PostSQL

RE: OT - a good list for UNIX (Solaris) system administration top

2002-07-14 Thread Andrey Bronfin
;-) -Original Message- Sent: Wed, July 10, 2002 8:49 PM To: Multiple recipients of list ORACLE-L topics Another list as good as this one? I put that dream in the same category as cold fusion, the fountain of youth, and a tasty beer that never gives you a hangover -rje A

RE: Just a question

2002-07-14 Thread Amar Kumar Padhi
Hi, You may not be able to contribute to the listbeing a newcomer, but I would suggest,stick around to gain knowledge. Sorry not aware of any other list for starters. rgds amar http://amzone.netfirms.com -Original Message-From: César Aracena [mailto:[EMAIL PROTECTED]]Sent:

Re: TOra: Toolkit for Oracle

2002-07-14 Thread Jan Pruner
Non MS-Windows http://sourceforge.net/project/showfiles.php?group_id=16636 For Windows http://www.globecom.se/tora/download/tora-alpha-1.3.6.1-windows.exe JP On Saturday 13 July 2002 20:33, you wrote: I've seen some chatter here about Tora, but when I go to http://www.globecom.se/tora/ or

DBMS_JOB does not run on NT

2002-07-14 Thread Andrey Bronfin
Dear gurus ! I submit a job via the DBMS_JOB package , it looks OK , select from user_jobs shows that broken='N' . When i execute the job manually , using dbms_job.run , it runs , but it does not run automatically (each 5 minutes , as i have specified when submitting the job). Any guess ? Thanks

Re: DBMS_JOB does not run on NT

2002-07-14 Thread Jack Silvey
Andrey, Are you issuing a commit after your dbms_job.submit? jack --- Andrey Bronfin [EMAIL PROTECTED] wrote: Dear gurus ! I submit a job via the DBMS_JOB package , it looks OK , select from user_jobs shows that broken='N' . When i execute the job manually , using dbms_job.run , it runs

Re: DBMS_JOB does not run on NT

2002-07-14 Thread CP
Check if you have a non-zero value for JOB_QUEUE_PROCESSES? HTH CP [EMAIL PROTECTED] wrote: Dear gurus ! I submit a job via the DBMS_JOB package , it looks OK , select from user_jobs shows that broken='N' . When i execute the job manually , using dbms_job.run , it runs , but it does not run

RE: Where is Oracle 9.2 init.ora?

2002-07-14 Thread Larry Elkins
Kirti, That's interesting. I guess anyone would have *expected* scope=both to report a problem regarding spfile just as it did when specifying just scope=spfile. I wonder if they are going to say in your TAR that this is the expected behavior ;-) Regards, Larry G. Elkins [EMAIL PROTECTED]

Deleting a Datafile

2002-07-14 Thread Sathish Tatikonda
Hi All, Is it possible to delete a datafile from a tablespace? What I want to do it to move the data from one data file to a bigger data file and delete the old file. If will be of great help to me if any pointers are provided for the same. thanks in advance, Sathish. -- Please see the

Re: Oracle on Linux ... Production Strength ???

2002-07-14 Thread lembark
-- James J. Morrow [EMAIL PROTECTED] on 07/13/02 21:08:18 -0800 By thw way, my preferred Distro is Mandrake. (Bear in mind that RedHat was [and may still be] compiled to run on an 80386. Most modern CPU's have additional features that you have to compile your software to use. Mandrake,

Re: Deleting a Datafile

2002-07-14 Thread Joe Testa
nope, no can do. export the data from the whole tablespace, drop the ts, build new and import. joe Sathish Tatikonda wrote: Hi All, Is it possible to delete a datafile from a tablespace? What I want to do it to move the data from one data file to a bigger data file and delete the old

RE: DBMS_JOB does not run on NT - SOLVED !

2002-07-14 Thread Andrey Bronfin
No , it was not ;-) Sorry , i knew it , but overlooked it ;-) It's working now ! Thanks a lot to all who replied ! DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Sun, July 14, 2002 5:51 PM To: Andrey Bronfin; LazyDBA.com Discussion Is

Re: Deleting a Datafile

2002-07-14 Thread Joe Testa
is resizing the tablespace out of the question? joe Sathish Tatikonda wrote: Hi All, Is it possible to delete a datafile from a tablespace? What I want to do it to move the data from one data file to a bigger data file and delete the old file. If will be of great help to me if any pointers

Re: Deleting a Datafile

2002-07-14 Thread Peter Gram
Hi You can use the alter database datafile '/path/file_name' resize M; to make a bigger file ;-) no need to remove the file from the tablespace ! Sathish Tatikonda wrote: Hi All, Is it possible to delete a datafile from a tablespace? What I want to do it to move the data from one data

OT - unix vs linux vs windows - the future

2002-07-14 Thread Andrey Bronfin
hi ! i might start another war , but i can't resist a part of me which wants to ask : what do you , seasoned gurus, think of everybody's (as it seems to be) plans to abandon the classic unix for linux ? In particular , most database vendors (as well as other enterprise software vendors) name

Re: OT - unix vs linux vs windows - the future

2002-07-14 Thread Joe Testa
I dont think the classic unix that you speak of will go away that fast, too many solaris/aix/hpux machines floating around still. I do any development/testing of features on linux, it cost me nothing but the hardware. RH 7.3 downloaded, no cost. technet member 9ir2 oracle downloaded, no

Re: OT - unix vs linux vs windows - the future

2002-07-14 Thread ltiu
I don't know man. I use whatever gets the job done. ltiu On Sunday 14 July 2002 11:58, Andrey Bronfin wrote: hi ! i might start another war , but i can't resist a part of me which wants to ask : what do you , seasoned gurus, think of everybody's (as it seems to be) plans to abandon the

RE: Where is Oracle 9.2 init.ora?

2002-07-14 Thread Deshpande, Kirti
All Right, Larry. Since we have the test servers and databases; and my Company still pays for 'doing Oracle' the 'scary' way, here is another 'scary thing' I did with SPFILE :) (9iR1 on HP) SQL conn / as sysdba Connected to an idle instance. SQL startup using spfile ORACLE instance

Re: OT - unix vs linux vs windows - the future

2002-07-14 Thread ltiu
Oracle. It's only free during development/education. Charges will be exhorbitant when getting production licenses. Windows and SQL Server is free too - if you pirate, right? It's what every one does : Linux is free but trying to sell this to your IT manager is not. On Sunday 14 July 2002

Re: OT - unix vs linux vs windows - the future

2002-07-14 Thread Alex
Development shops that actually write native code will target an OS with market share. Now, seeing that alot of code written today is interpreted the move to linux, windows, or beatnix is irrelevent. As far as DB vendors targeting linux they move in herds and have just finished their linux port

Re: Deleting a Datafile

2002-07-14 Thread Jared Still
Why do you want to do that? I ask because it is an unusual request. It could be that there is a better solution to whatever you are trying to do. Jared On Sunday 14 July 2002 10:23, Sathish Tatikonda wrote: Hi All, Is it possible to delete a datafile from a tablespace? What I want to do

McCain on Larry Ellison and Corporate Responsibility / Re: OT - unix

2002-07-14 Thread Eric D. Pierce
Speaking of herds, or at least what is left behind on the ground after they pass: on Meet the Press (TV program), Senator John McCain said that Larry Ellison cashed out $700,000,000 of his Oracle stocks just before they lost most of their value (sarcasm: I'm sure he is planning on plowing it

Re: OT - unix vs linux vs windows - the future

2002-07-14 Thread Jared Still
I'm sure that many vendors welcome an opportunity to stop paying royalties to ATT for unix code. I believe that all mainstream vendor implementations of unix have ATT base. Jared On Sunday 14 July 2002 11:58, Andrey Bronfin wrote: hi ! i might start another war , but i can't resist a part