kalido vs OLAP services

2002-07-31 Thread novicedba
Hi all, novice is back with stupid questions :) I have started working with a tool called Kalido. I have touched it for only past few days. Seems interesting. www.kalido.com My question is I heard someone claiming that what ever is possible with kalido is easily possible with OLAP

novice learns a new thing

2002-05-27 Thread novicedba
Hi all, I noticed something strange. Logically it makes sense but nevertheless strange. I don't know how to pur it in words. So seniors please help === SQL conn hlledw/hlledw@orcl9iConnected.SQL grant select on edw_week_lvl to scott;

Re: novice learns a new thing

2002-05-27 Thread novicedba
But the interesting point is that scott never granted the privileges on the object to test1 Coz I am a NoviceDBA Oracle Certifiable DBBS An obstacle is something you see when you take your eyes off the goal -- Anonymous - Original Message - To: Multiple recipients of list ORACLE-L

Re: OTN Download Hanging

2002-01-04 Thread novicedba
Hi, I have downloaded it to my office PC and it works fine. So I do not think the problem is with the installable coz I am a NoviceDBA Oracle Certifiable DBBS - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 02, 2002 6:20 PM

Re: One more to the list of Myths exploded

2001-09-30 Thread novicedba
unfortunately yes Thanks to jared's example i have a clearer idea now :) coz I am a NoviceDBA Oracle Certifiable DBBS - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 28, 2001 3:00 PM Which myth did you have in mind ? I

Re: How to subtract 1 from current month

2001-09-27 Thread novicedba
select hiredate,add_months(hiredate,-1) from emp; coz I am a NoviceDBA Oracle Certifiable DBBS - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 17, 2001 9:30 PM I am trying to find coding examples of date functions. I need

fire the trigger selectively when a column is updated

2001-08-25 Thread novicedba
Hi everyone, One of my developers wanted to know if it is possible to write a trigger only if a particular column is changed, essentially making it a column level trigger.I gathered from the article below that it is possible in SQL server. Just wanted to know if this is possible in oracle.

OT:I was thrown out of the list

2001-08-09 Thread novicedba
Hi, I did not receive a mail for two days, I started smelling rat and sent a test mail to the list. I was told I am not a member. Is it some revamping happening or I was thrown out because did people start receiving viruses from my id ??? list administrator please help jared bruce

question about d2k - urgent

2001-07-25 Thread novicedba
hi everyone, wanted to know about key mapping in developer 2000. I know that hot key mapping can be changed by modifying .res file. but it has its own limitations (I was told this) 1)Combinations are restricted. 2) if any other product made in D2k is installed then its shortcuts will

9i for AIX is avaialble for download on technet.

2001-07-23 Thread novicedba
hi everyone, In case you haven't noticed 9i for AIX is available for download on technet. When will 9i for NT come :( cozI am anoviceOracle Certifiable DBBS

Re: Certification

2001-07-19 Thread novicedba
mail me at [EMAIL PROTECTED] I will try and help you cozI am anoviceOracle Certifiable DBBS - Original Message - From: Robertson Lee - lerobe To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 18, 2001 5:00 PM Subject: Certification Oh dear,

Re: ONS Install - my life is at an end

2001-07-13 Thread novicedba
://www.orafaq.com -- Author: novicedba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from

OT-Oracle User Groups in India

2001-07-11 Thread novicedba
Hi, I wanted to know if there are any Oracle User Groups in India. I visited http://www.eoug.com/usergroup-list.htmwhich lists all the user groups, the two links provided for India don't seem to be the proper ones. One is UKOUG and the other link does not work. I am in Bangalore, India

table aliases save time when parsing??

2001-07-10 Thread novicedba
Hi, was reading CorrelatedSubqueries.pdf from oriolecorp. In fact it's good programming practice to use aliases in every situation where more than one table is referred to in a statement, since it saves time when parsing. Can some one please explain how it helps? cozI am anoviceOracle

Re: UTL_SMTP

2001-07-10 Thread novicedba
: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: novicedba INET: [EMAIL PROTECTED] Fat City Network Services

Setting event 10032

2001-07-10 Thread novicedba
hi all, this is an excerpt from Steve Adams site http://www.ixora.com.au/newsletter/2000_12.htm First you need to determine the largest disk sort that is performed by the batch process. This can be done by setting event 10032 at level 1 in the session and then examining the process trace

Re: Global Temp Tables and Indexes

2001-07-09 Thread novicedba
-- Author: novicedba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list

setting an event -10032

2001-07-09 Thread novicedba
hi all, this is an excerpt from Steve Adams site http://www.ixora.com.au/newsletter/2000_12.htm First you need to determine the largest disk sort that is performed by the batch process. This can be done by setting event 10032 at level 1 in the session and then examining the process trace

Forms question

2001-07-08 Thread novicedba
Hello one of my developers has a weird(!) requirement In one of the applications the block level propertyquery all records has been set to yes and the users want it that way, butthey also want to have a dialogue popping up which would allow them to abort the query ifthey wish to. The

Re:

2001-07-06 Thread novicedba
information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: novicedba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Simple SQL Query Question

2001-07-02 Thread novicedba
SELECT STATION,EMISSION_FREQ,RECEPTION_FREQ,DECODE(SUBSTR(NVL(TO_CHAR(RECEPTION_FREQ),'NONE'),1,1),'N',EMISSION_FREQ*1,EMISSION_FREQ*2) VALUEFROM TEST; STATION EMISSION_FREQ RECEPTION_FREQ VALUE-- - -- -STAT1 192.5 193.5 385STAT2 192.5

Re: Simple SQL Query Question

2001-07-02 Thread novicedba
you could achieve this using decode cozI am anoviceOracle Certifiable DBBS - Original Message - From: ALEMU Abiy To: Multiple recipients of list ORACLE-L Sent: Monday, July 02, 2001 1:00 PM Subject: Simple SQL Query Question I've a table with the following

Re: Exploding the Myths paper

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

Re: Simple SQL Query Question

2001-07-02 Thread novicedba
-- - --STAT1 192.5 193.5STAT2 192.5STAT2194 STAT1 193.5 194.5 STAT2195 I would like to have a value for STAT1 which is equal to 2*2=4 and for STAT2 equal to 3*1=3 -Message d'origine-De: novicedba [mailto:[EMAIL PROTECTED]]Envoyé: lundi 2 juillet

Re: Common Oracle RDBMS Misconceptions

2001-06-28 Thread novicedba
: No Sender Info found in the address Book On Jun 26, 2001 at 01:05:59AM, novicedba wrote: Hi everyone, I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton I was shocked to read Hot backup mode explained If this is true then I may

Re: Common Oracle RDBMS Misconceptions

2001-06-28 Thread novicedba
[EMAIL PROTECTED] Sent: Tuesday, June 26, 2001 4:03 PM On Jun 26, 2001 at 01:05:59AM, novicedba wrote: Hi everyone, I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton I was shocked to read Hot backup mode explained If this is true then I may be a victim of a disease

Re: Re:

2001-06-28 Thread novicedba
to participate, giving their own interpretations. Marlene and I designed that presentation as an all day workshop, and it was meant first and foremost to be educational AND entertaining. The paper will be on the NYOUG website in a few days. Rachel From: novicedba [EMAIL PROTECTED] Reply-To: [EMAIL

Re: Common Oracle RDBMS Misconceptions

2001-06-28 Thread novicedba
/entry/Infinite-Monkey-Theorem .html Cheers Greg -Original Message- Sent: Thursday, 28 June 2001 14:21 To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: novicedba INET: [EMAIL PROTECTED] Fat City Network Services

Re: test

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

No Subject

2001-06-27 Thread novicedba
LISTS

Common Oracle RDBMS Misconceptions

2001-06-26 Thread novicedba
Hi everyone, I visited Jeremiah Wilton's web page http://www.speakeasy.net/~jwilton I was shocked to read Hot backup mode explained If this is true then I may be a victim of a disease called 'Common Oracle RDBMS Misconceptions' . Somebody help me!! (Jim carrey-MASK style) Please help me. If

Re: Common Oracle RDBMS Misconceptions

2001-06-26 Thread novicedba
myself. Is it possible that rather than visiting Jeremiah's site at www.speakeasy.net poor old novicedba visited www.spankeasy.net (I'm not even sure it exists and I'm at work so I won't be checking). If it does exist I'm sure that switching logs means something entirely different

Re: Undocumented Init.Ora Parms

2001-06-22 Thread novicedba
to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: novicedba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

9i on redhat 7.0 --help me

2001-06-21 Thread novicedba
Hi, install.pdf reads Operating System: Oracle9i is certified on SuSe 7.1, Kernel 2.4.4 and the operating system library GNU Lib C 2.2. I have Redhat 7.0 with kernel 2.2.16--22 I think I need to upgrade my kernel to 2.4.4 but don't know how to, redhat site doesn't give great info nor did

No Subject

2001-06-18 Thread novicedba
LIST

Re: Removing Older version of Oracle on NT Machine

2001-06-12 Thread novicedba
Hi, We run our databases on NT and we face this problem once in a while. For the benefit of our consultants working on the client side I had prepared a document. This has worked perfectly for me as well as for our consultants on the client side. I am aware that the present problem is removing one

Re: regarding isqlPlus

2001-06-11 Thread novicedba
Hi, yes I have tried working with isqlplus. It gets installed fine and works fine too. There is a proper installation doc following which it could be installed. It is buggy as you can expect it to be. everyone who used it at our place liked it (though I had the headache of killing the

ksrchdelete7

2001-06-08 Thread novicedba
Hi, Database 8.1.5 OS - NT On my test database I deleted certain tablespaces and then shutdown the databases, deleted the datafiles (still in recycle bin) and restarted the database . The database started fine no errors. When I check the alert log I found the string ksrchdelete7

8i for solaris on intel

2001-06-06 Thread novicedba
Hi, I have a Solaris test system on Intel. This is first time I installed Solaris. I am trying to findout in i can install the oracle 9i on this system. Can someone enlighten me. I don't mind installing any version as it is for test purposes, but 9i will be a great thing to do novice

Re: OEM 2.1 cannot contact agent on a node

2001-06-06 Thread novicedba
list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: novicedba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

How do I corrupt a block

2001-05-31 Thread novicedba
hi, This may sound funny. I want to know how to corrupt a block. I want to test the different methods of identifying block corruption, but I don't have sample data blocks. Please help me novice

Re: How do I corrupt a block

2001-05-31 Thread novicedba
unfortunately i am on NT I can not use BBED because i don't know the password is there any other way - Original Message - To: 'novicedba' [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 11:40 PM I do not recommend this, but since you are bent on doing this: (Hope you are on Unix

Re: Oracle 8.1.7 and Apache

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