Re: ORA-00904 on a valid view when using count(*)

follow-up on this one... it seems that everything else won't work like select max(open) from gain_view or select name from gain_view or select max(length(security_name)) from gain_view... except for select * from gain_view... tried these for almost all columns and am still getting 904 error...

Re: ORA-00904 on a valid view when using count(*)

follow-up on this one... it seems that everything else won't work like select max(open) from gain_view or select name from gain_view or select max(length(security_name)) from gain_view... except for select * from gain_view... tried these for almost all columns and am still getting 904 error...

Re: ORA-00904 on a valid view when using count(*)

Maria Aurora VT de la Vega wrote: follow-up on this one... it seems that everything else won't work like select max(open) from gain_view or select name from gain_view or select max(length(security_name)) from gain_view... except for select * from gain_view... tried these for almost all

XP Professional 9i

Will 9i run on XP Professional client? And, no I am not interested in putting Linux on my home PC at this time. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient Systems, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz

Re: x$ksmpp table question

george, try using pmap pid hth deepak --- George Schlossnagle [EMAIL PROTECTED] wrote: I want access to the fll heap structure though. My process pga is huge, I want to see what the allocations are. George - Original Message - From: Khedr, Waleed To: Multiple

RE: XP Professional 9i

We are not a member of metastink. I looked at OTN an it's only certified up to W2000. So, I was wondering if anyone knew if it is cert. for XP Prof. or when it will be? Thanks, Ken -Original Message- Sent: Saturday, December 29, 2001 7:50 AM To: Multiple recipients of list

RE: XP Professional 9i

Now what would make you think that we would recommend that? Oh, wait, cause its what advice is given to everyone;-) -Original Message- Sent: Saturday, December 29, 2001 4:35 AM To: Multiple recipients of list ORACLE-L Will 9i run on XP Professional client? And, no I am not interested

Shutdown Normal

Will shutdown normal allow me access the DB as SYS or SYSTEM while keeping the regular users out? Or, is there a better way of doing this? Thanks, Ken -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services

Re: Shutdown Normal

Ken Janusz wrote: Will shutdown normal allow me access the DB as SYS or SYSTEM while keeping the regular users out? Or, is there a better way of doing this? Thanks, Ken shutdown normal? Never using it. If you really want to keep users out you must first kick out those who are

Information on Oracle i-store

Hi All, I need to start working with Oracle i-store. Could you please share with me any books, technical articles, white papers you know or have. It would also be great if you know any resources on the web and their location. thanks in advance, Sathish. -- Please see the official ORACLE-L FAQ:

Re: x$ksmpp table question

That was how I spotted the bad processes in the first place. Now I want details on what is swelling their pgas. x$ksmpp will give that for my own session, I want the same information for the sessions in question. George On Saturday, December 29, 2001, at 08:10 AM, Deepak Thapliyal wrote:

Re: XP Professional 9i

That brings rise to the question Why aren't you a member of MetaStink? Have you purchased Oracle Support? If so, you likely have access to MetaLink. If not, you need to. You'll never be able to successfully implement an Oracle based application on 9i without support. You at least need to

Re: XP Professional 9i

If you have a CSI # you can register on Metalink. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, December 29, 2001 8:25 AM We are not a member of metastink. I looked at OTN an it's only certified up to W2000. So, I was wondering if

Re: XP Professional 9i

fed-up, elitist rant I can't take it anymore! The problem with Windows is IT ALLOWS STUPID PEOPLE TO THINK THEY CAN USE COMPUTERS!!! As wages are driven down by idiots who don't really want to learn in the marketplace, its also cutting into my money-making opportunities. /fed-up, elitist rant

RE: XP Professional 9i

Jared: We are not on MetaStink because my company won't pay for it. It's their problem not mine. Ken -Original Message- Sent: Saturday, December 29, 2001 11:15 AM To: Multiple recipients of list ORACLE-L Subject:Re: XP Professional 9i That brings rise to the question

RE: XP Professional 9i

Ken, A co-worker of mine has installed Oracle 9i on XP Home Edition. This is for learning etc. Nothing to do with any Business related work. From what I know (from Metalink) 9i will be supported only on XP Professional Edition(32-bit at the moment, currently no support for 64-bit XP ). HTH, -

Re: XP Professional 9i

Well, if you're interested in getting MetaLink access, you could write up a brief memo on the need for support so that you will at least have access to software patches. If nothing else, it will be CYA for you so the damagers can't come back on you, asking why you didn't let them know about it.

RE: XP Professional 9i

-We are not on MetaStink because my company won't pay for it. It's their -problem not mine. Just another f***ing brain fart by DAMAGEMENT D**e -Original Message- Sent: Saturday, December 29, 2001 11:55 AM To: Multiple recipients of list ORACLE-L Jared: We

Re: XP Professional 9i

Ken, i think if you have to deal w/installing oracle, then it WILL be your problem. :( joe Ken Janusz wrote: Jared: We are not on MetaStink because my company won't pay for it. It's their problem not mine. Ken -Original Message- Sent: Saturday, December 29, 2001 11:15