RE: Good DBA vs. Bad DBA

Dare I ask... do you have a Good Manager vs. Bad Manager list? ;o) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Monday, May 06, 2002 4:14 PM To: Multiple recipients of list ORACLE-L I posted my list of Good DBA vs. Bad DBA on the DBA

RE: 8i OCP questions

They will post it something like 6 months before the planned retirement. I think you have some time yet -Original Message- [EMAIL PROTECTED] Sent: Monday, May 06, 2002 12:57 PM To: Multiple recipients of list ORACLE-L Hi, I cannot find any info on Oracle web site concerning time

Re: change a database connection in a stored procedure?

Hello kranti, Use dynamic SQL. Monday, May 06, 2002, 8:23:29 PM, you wrote: kp Hi List, kp Can someone tell me is it possible to change a database connection kp in a stored procedure? if so how? kp TIA kp Kranti -- Best regards, Sergeymailto:[EMAIL

Re: ORA-03113: end-of-file on communication channel

Hi, Kill -9 PID of pmon process and wait for 10 seconds, everything will be cleaned for you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Manh Tran INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Erwin - Does this thing work?

There is a way around that pesky FK problem. Unfortunately we are using it... No FK's. And they wonder why they have data problems... -Original Message- [EMAIL PROTECTED] Sent: Monday, May 06, 2002 10:43 AM To: Multiple recipients of list ORACLE-L Hi Lisa, Yes. But its a

RE: ERD generation tool - Active SCM

Hey, how do you give that truncate only privilege -Original Message- Peterson Sent: Monday, May 06, 2002 8:54 AM To: Multiple recipients of list ORACLE-L this is exactly my point. It would have been better to give your developer truncate only privileges, and that too only on a

RE: Licences for testing

Just catching up after the long weekend here, I have been under the understanding that if you are a development partner then you are covered for all products for as many installations for testing and development and learning purposes. Is this wrong or changed ?? If not then it may be in your

Re[2]: IN() question

Hello Roy, You can include null in an IN() but it will have no effect. Monday, May 06, 2002, 11:53:30 PM, you wrote: PRE Does this mean that you can't include Null as a value in an IN() clause? PRE That is, would something like: SQL SELECT COUNT(*) 2 from leisure_plan_master_temp 3

RE: DB Version upgrade with CreateDB/Import Risky???

But you don't have to migrate Upgrade... Different. -Original Message- WILLIAMS Sent: Monday, May 06, 2002 1:18 PM To: Multiple recipients of list ORACLE-L This was a couple of years ago, so I don't have a distinct recollection of the problems. We are on Compaq Tru64. Most

RE: Datawarehousing help

Oh, good idea! When's it being published Rachel? -Original Message- Chris Sent: Monday, May 06, 2002 1:55 PM To: Multiple recipients of list ORACLE-L Cool!! Here comes Oracle Data Warehousing 101... -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 06, 2002

RE: DB Size script

You can get the size of database using DBA studio. Which gives separately the actual space consumed by the data and the size of table spaces. Aleem -Original Message- Sent: Tuesday, May 07, 2002 3:39 AM To: Multiple recipients of list ORACLE-L Subject:Re: DB Size script

RE: Reverse Key Index Performance

I have never used RKI's nor have I read up on them before this posting; this is pure conjecture. As I recall this was happening in a correlated subquery. Is it possible that using a normal forward-key index the indexed could be stepped through sequentially , whereas using the reverse

Re[2]: how to put ' on statement

Hello mitchell, Try to make like this: select 'ALTER TABLESPACE rename file '''||file_name||''' to '''||file_name||''';' from dba_data_files where tablespace_name = 'TBL_STATEMENT'; Tuesday, May 07, 2002, 5:53:11 AM, you wrote: m hi m I forget how to put single qutation on sql. somebody can

RE: Oracle Presentation for Beginners!

Ed, I owe your (or Melody) a beer or maybe two :-) ... Thanks a lot! Keijo __ Ota itsellesi luotettava kotimainen email http://www.jippii.fi/ Tutustu samalla netin parhaaseen pelipaikkaan JIPPIIGAMESIIN. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET:

RE: Can Partition be set an Session Level

Hi Dennis Williams U r correct while Querying the table I want to set at session level to use the partition. is it possible Rgds Ayyappan.S Ayyappan - I'm just trying to understand your question. Pardon me if I'm a little slow, it is Monday. Okay, you have a partitioned table. That is a

Re: groupping and percentages

Hello Gurelei, Use subqueries: select a.group Group, a.number Number, a.number/b.cnt*100 Percent from (select group, count(group) number from test_table group by group) a, (select count(*) cnt from test_table) b; Wednesday, May 01, 2002, 1:57:39 AM, you wrote: G Hi all: G

<    1   2