starting up 8i on Win2000 Problems

Hello, I am new to the Windows Platform. I have a Oracle 8i (8.1.6.0.0) on a Windows 2000 system. My problem is this, when I shutdown the system, using svrmgrl and the command shutdown immediate. The system shuts down as one would expect with no errors. However when I try restarting the

RE: Data dictionary for function

Hi all, Thank you for your answers dba_source user_source all_source Sinardy -Original Message- [EMAIL PROTECTED] Sent: Friday, 29 June 2001 1:50 PM To: Multiple recipients of list ORACLE-L dba_all_source Regards Sinardy Xing

Re: Data dictionary for function

Sorry the below should have read dba/all _source table Ravinder_Bahadur@singapore

Re: Data dictionary for function

jaimin wrote: Hi, DBA_SOURCE is the table which stores information about all procedures and fuctions. SQL desc dba_source NameNull?Type --- OWNER NOT NULL VARCHAR2(30)

Re: (No Subject)

hi, just do: '' represent ' SQL create table testtb(a varchar(90)); Table created. SQL insert into testtb values('i love oracle''s money'); 1 row created. SQL select * from testtb; A i love oracle's money SQL

RE:

STOP IT !!! -Original Message- Sent: 29 June 2001 05:10 To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: starting up 8i on Win2000 Problems

hi guys! i was wondering if someone knows about some good resources (documentation and examples) for pl/sql web development using the pl/sql htp, htf and owa_* packages. i would also like to ask a simple but interesting licensing question about the use the pl/sql web interface. starting with

RE: Venkata's pc is back in line VIRUS messgaes again

for those of you on UNIX, write a looping shell script, say 1,000 times which does a mailx to his email account. Just a thought, but if I get one more from him (which incidentally should be triggered by this email) then that is what I considering doing. (I have metioned this to the UNIX S.As and

Re: (No Subject)

Thanks Chao -- On Thu, 28 Jun 2001 23:47:32 chao_ping wrote: hi, just do: '' represent ' SQL create table testtb(a varchar(90)); Table created. SQL insert into testtb values('i love oracle''s money'); 1 row created. SQL select * from testtb; A

Migrate from Oracle Web 7.3/NT to 8i (AS 9i)/2000

HiI have couple of pages on Oracle web Server included in Oracle 7.3 Server.How can I transfer them to Oracle8 - want to move to Windows 2000 whichdoesn't support 7.3, as far as I know.How do I setup the Web Server - Oracle or Apache? And how to transferhomepages, agents, listener... I have

Influencing commit interval of read-only replication's refresh gr

Hi, does some one know of a way to force the refresh process of a read-only snapshot group to commit at predefined intervals: by table, by n number of rows or any other way? The problem that we are facing is that a refresh group has some rapidly changing tables and the rollback segment is not

help

Hi , I have a doubt in pl/sql.I want to insert 5 rows in a table.I want the user to be prompted for entering data 5 times. But this code prompts the user only one time and inserts 5 times.What should i do to achieve my expected behaviour? declare begin for i in 1 .. 5 loop insert into tmpc

Re: What's lock/unlock mechnism

Hi, To find out more about the locking mechanism you can try the oracle concepts manual Jack Helen rwulfjeq

OAS 4.0.8.2

I am running Oracle 8.1.6. on solaris 2.6 After installing Oracle Application Server I am getting this error on trying to start it owsctl start Please wait while the command is being processed on host unetdb2 ... Starting ORB process... waiting for ORB to be ready... The command completed

Re: Invalid packages not being recompiled by Oracle

Hi Paul, I agree completely with you and feel your pain. I have a workaround though, if the changes made to your package does not affect the specification(i.e no new parameters, no new functions/procedures) really, for changes only to the package body, You can do a ALTER PACKAGE package_name

RE: Virus again

Well, I just a got a REAL Virus - Chicken Pox!! Just been to the doctors.. You better hope I can't spread E-Chicken Pox :) -Original Message- Sent: Friday, June 29, 2001 01:41 To: Multiple recipients of list ORACLE-L If I get e-mail from the customer with virus I'll inform him/her

RE: OCP Discount S36

I don't think it does - it is just the Technet membership code.. -Original Message- [EMAIL PROTECTED] Sent: Thursday, June 28, 2001 10:21 To: Multiple recipients of list ORACLE-L OTN says that you can get an OCT 20% discount on the testw with code S36. However, it doesn't say when

Re: OAS 4.0.8.2

Here is th full message owsctl start Please wait while the command is being processed on host unetdb2 ... The ORB process have already been started on host unetdb2. The command is not completed on host unetdb2. ld.so.1: /opt/var/m1/ows/ows/4.0/bin/oassrv: fatal: relocation error: file

Re: Invalid packages not being recompiled by Oracle

On Thu, Jun 28, 2001 at 10:56:23AM -0800, Troiano, Paul (CAP, GEFA) wrote: We have one package A that refers to package B. If package B's body and specification are both recompiled by user 1, package A is correctly marked as invalid. Another user, user 2, then attempts to execute package A

PL/SQL

How can I change this pl/sql code. I want this to happen: I have for instance this blank 5 5 blank 55 which means 55 55 (the spaces ar ethe blanks.) and I want it to be like this: 00 How can I change this code to let this happen: vPOSTAL_NO:=

RE: Invalid packages not being recompiled by Oracle

Paul, From what I remember, if a package has been marked invalid and a user tries to execute it, it DOES get re-compiled at that time, but does not get executed. So the FIRST call to an invalid Package changes it's state to valid. The Second call will actually execute the package. The only

RE: Oracle DBA with SQL Server and Manufacturing Industry

We have an Alpha server here that we are going to be putting into service next year to run a financial application. Currently the os is OpenVMS and will support an oracle database but not the financials. We will have to change the os to Tru64 to handle the financials. The server is a dual ES40

RE: PL/SQL

Roland, Try vPOSTAL_NO := replace(vPOSTAL_NO,' ','0'); lc -Original Message- [EMAIL PROTECTED] Sent: Friday, June 29, 2001 8:30 AM To: Multiple recipients of list ORACLE-L How can I change this pl/sql code. I want this to happen: I have for instance this blank 5 5 blank 55 which

RE: PL/SQL

vPOSTAL_NO:=lpad(replace(nvl(POSTAL_NO,'0'),' ',''),6,'0'); -Original Message- Sent: 29 June 2001 13:30 To: Multiple recipients of list ORACLE-L How can I change this pl/sql code. I want this to happen: I have for instance this blank 5 5 blank 55 which means 55 55

RE: PL/SQL

Roland, try vPOSTAL_NO:= lpad(replace(' 55 55',' ',null),7,'0'); select lpad(replace(' 55 55',' ',null),7,'0') from dual hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, June 29, 2001 8:30 AM To: Multiple recipients of list ORACLE-L

Work around for PL/SQL code

Hi, Let me introduce myself. I am Rangachari Sundar from Chennai India. I have the workaround for the requirement you have posted and here it is vPOSTAL_NO := lpad(replace(trim(recCursor.POSTAL_NO), ' ', ''), 7, '0') ; Trim is not available prior to oracle 8 so if your version is prior to 8

Re[3]: Pocket Guide

Dick, Would you be interested in reviewing an RMAN pocket ref? I'm currently editing the book, and it should be ready for review in a week or two. If you'd be interested in reading it over, let me know. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698

RE: 9i Open Day (UK Listers)

I am sure lots of people will want to meet you now that you have annnouced to the list that you have got chicken pox Where is the meet? - Bracknell I assume, and how do you get an invite? John -Original Message- Sent: 29 June 01 13:31 To: Multiple recipients of list ORACLE-L Hi

Re: Influencing commit interval of read-only replication's refresh gr

Hi, does some one know of a way to force the refresh process of a read-only snapshot group to commit at predefined intervals: by table, by n number of rows or any other way? The problem that we are facing is that a refresh group has some rapidly changing tables and the rollback segment is

Re[2]: Pocket Guide

What about O'Reilly's Oracle SQL: The Essential Ref? It's about 370 pages long, covers SQL syntax and a few other things. Has anyone looked at that? Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com *

RE: 9i Open Day (UK Listers)

I'm definitely there and am staying overnight on the Thursday so will be partaking in a fair few beverages Lee -Original Message- Sent: 29 June 2001 13:31 To: Multiple recipients of list ORACLE-L Hi all UK listers, I was just wondering how many people from the UK on here have

RE: OCP Discount S36

Here is what the web site says: Sign Up For a Test Now Register for Oracle certification testing (mention promotional code S36 to receive your OTN 20% discount) -- There is no mention of an expiration date. Ken I don't think it does - it

Re[2]: What's lock/unlock mechnism

One can influence the locking of data via the lock table command and for update of portions of a SQL cursor. As a general rule of thumb I totally discourage anyone from ever using the lock table command. Certainly the process within the server is complicated as needs be, but it is one of the

RE: 9i Open Day (UK Listers)

I recieved the offical invite on my doormat this morning. I was wonderring whether to go and I see that it starts at 13:00+ which means I can still go the work in the morning. If I decide to go then a get-together /drinks would be great. - Mike. -Original Message- Sent: 29 June

RE: Oracle DBA with SQL Server and Manufacturing Industry

Ron, Is Oracle Financials no longer supported on OpenVMS?. 10.7 financials was definitely OK on VMS although not many sites ran it and I thought 11.0 was out for VMS as well. John -Original Message- Sent: 29 June 01 14:06 To: Multiple recipients of list ORACLE-L We have an Alpha

RE: Virus again

I beleive there is definately an association, like the dude is still on the list, set up some stupid VB thing tha takes parts of messages and attaches viruses to them and sends them out That's my guess. KK -Original Message- Sent: Thursday, June 28, 2001 7:56 PM To: Multiple

RE: OT RE: 24 x 7 on NT?

Title: OT RE: 24 x 7 on NT? Thanks for the link, I love that story:)) KK -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jacques KilchoerSent: Thursday, June 28, 2001 6:28 PMTo: Multiple recipients of list ORACLE-LSubject: OT RE: 24 x 7 on

Re: A Question on the Basics of PL/SQL

On Thursday 28 June 2001 18:01, MacGregor, Ian A. wrote: Here's a line from the package header for dbms_standard: function dictionary_obj_name_list (object_list out ora_name_list_t) return binary_integer; The function returns both a binary integer and a table of

Re: audits

Bill, Auditors are likely folks originally trained as accountants and CPA's. This reminds me of the days when I fixed computers for a living. The bean counters decided that $0.25 per board could be saved in manufacturing by not putting test points on the boards. ( A pin soldered to the board

Re: SGA QUESTION

200MB? I realize simply adding memory is not the solution for fixing a poorly tuned database, but on the other hand, if you have a lot of memory why not use it? - Greg -- Hi Jared, I think like Greg . Why not use 2-4 gb of 8 gb memory for SGA. ? If It has bad results

Re: A Question on the Basics of PL/SQL

Jared Still wrote: On Thursday 28 June 2001 18:01, MacGregor, Ian A. wrote: Here's a line from the package header for dbms_standard: function dictionary_obj_name_list (object_list out ora_name_list_t) return binary_integer; The function returns both a binary integer

MetaDink Returns

Maybe because it's Friday? Fri, 29 Jun 2001 14:10:44 GMT ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at SURE.SURE_API, line 1291 ORA-06512: at METALINK.ML2_DOCUMENTS, line 324 ORA-06512: at line 7 DAD name: plsql PROCEDURE :

Why are my indexes being ignored?

Hi, I created an index on a table. The table has about 83,000 rows. The index is a simple index on one field, 35 different values of the index. I analyzed the table and I analyzed the index, trying it both with a histogram and without a histogram. No matter how I do it, it does a full table

db file sequential reads

Hi all, We have SAP application runing on a machine and Oracle 8.1.6.2 instance on an other, the two machines are connected to a gigabyte network. time response of the requests from SAP to Oracle is very long. We investigated with utlbstat and utlestat and we found that we have too much waits

Two indexes same columns

If there is a primary key on a table (which inherently builds an index), is it still necessary for performance to build a seperate index on the same columns as those identified in the primary key or is the index generated by the primary key sufficient? -- Please see the official ORACLE-L FAQ:

Re: Why are my indexes being ignored?

What is the sql statement that you are executing against this table? Carle, William T (Bill), NLCIO wrote: Hi, I created an index on a table. The table has about 83,000 rows. The index is a simple index on one field, 35 different values of the index. I analyzed the table and I analyzed the

RE: Why are my indexes being ignored?

I'm returning 117 rows. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- Sent: Friday, June 29, 2001 9:50 AM To: [EMAIL PROTECTED]; Carle, William T (Bill), NLCIO Subject:Re: Why are my indexes being ignored? Carle, William T

advanced replication

I was beginning to think advanced replication looked like a reasonable solution for an applicaiton. Then I read: Replication environments supporting both multimaster and snapshot replication can be challenging to configure and manage. To help administer these replication environments, Oracle

RE: 9i Open Day (UK Listers)

mais non. Oracle HQ Thames Business Park in Reading. http://www.oracle.com/uk/start/9iopenday Regards Lee -Original Message- Sent: 29 June 2001 14:52 To: Multiple recipients of list ORACLE-L I am sure lots of people will want to meet you now that you have annnouced to the list

SAP Interview Questions

We are looking to hire an SAP Systems Analyst. Can anyone suggest some good questions/answers specific to SAP? I have seen lists of Oracle interview questions so I was wondering if anyone has seen any on SAP? Or, if you just know some good questions/answers, please send them to me. Thanks. --

RE: ORA-12638: Credential retrieval failed URGENT!!!!

Look in C:\oracle\ora81\network\admin\sqlnet.ora for the line SQLNET.AUTHENTICATION_SERVICES= (NTS) This is why Oracle is trying to retrieve user information from the domain. I ran into this when I had a laptop plugged into the network, and I installed Oracle onto it, then tried to access

RE: Two indexes same columns

Connie, When you create the PK constraint, Oracle automatically creates a unique index to enforce it. You should explicitly name the tablespace in which this index is to be created. Otherwise Oracle will just create it in the scema owner's default tablespace - not necessarily a performance

RE: Re[2]: Common Oracle RDBMS Misconceptions

Yup, you need Oracle 8i Application Programming by Wrox Press. And I got paid by the page rather than as a percentage of sales, so I can say that with a clear conscience! ;0) g -Original Message- Sent: Tuesday, June 26, 2001 8:27 PM To: Multiple recipients of list ORACLE-L BTW: IMHO,

RE: OT::Take a look.

Dick, McCain is what one should think of as a dyslexic Republican. He thinks he's on the right when he's really on the left. ;) [EMAIL PROTECTED] 06/28/01 04:26PM snip Dick Goulet PS: For those of you who feel I'm Republican bashing, I'm not. I'd have VERY happily voted for McCain, even if

RE: starting up 8i on Win2000 Problems

u have to apply patch 8.1.6.3.4 -Original Message- Sent: Friday, June 29, 2001 2:46 AM To: Multiple recipients of list ORACLE-L Hello, I am new to the Windows Platform. I have a Oracle 8i (8.1.6.0.0) on a Windows 2000 system. My problem is this, when I shutdown the system, using

RE: 9i Open Day (UK Listers)

LOL - my doctor ensured me that I should be ok within a week or so. If not - then I won't be coming :( You can register on the web @ http://www.oracle.com/uk/start/9iopenday or call 01252 771499 Regards Mark -Original Message- Sent: Friday, June 29, 2001 02:52 To: Multiple recipients

Re: Why are my indexes being ignored?

Carle, William T (Bill), NLCIO wrote: Hi, I created an index on a table. The table has about 83,000 rows. The index is a simple index on one field, 35 different values of the index. I analyzed the table and I analyzed the index, trying it both with a histogram and without a

Re: Two indexes same columns

No, there would be no benefit and it probably wouldn't be allowed anyway unless you reversed the columns in the 2nd index. Regards, Mike Hately. |+--- || Connie | || Milliken | || cemail@sprin| |

RE: Virus again

S'OK. This list won't let you send it as an attachment. At 03:15 AM 6/29/01 -0800, you wrote: Well, I just a got a REAL Virus - Chicken Pox!! Just been to the doctors.. You better hope I can't spread E-Chicken Pox :) Dennis Taylor Good judgement comes from

RE: OT: Re: Common Oracle RDBMS Misconceptions

Rachel, I love those animations on the last slide!! :0) g -Original Message- Sent: Wednesday, June 27, 2001 11:45 AM To: Multiple recipients of list ORACLE-L Joe, Oops, not that I forgot, I don't think I knew. okay KEVIN!!! :) Will send him a new copy to put up

Setting PCTFREE PCTUSED in a Datawarehouse

I read in the Oracle docs that setting a high PCTUSED ( such as 60/70) would increase the cost of INSERTS to the table. Can someone explain this , pleas e! thanks vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra INET: [EMAIL PROTECTED] Fat City

RE: Why are my indexes being ignored?

index is not selective enough. it would wind up pulling MORE db blocks in using the index than a FTS. hth - Hannibal -Original Message- Sent: Friday, June 29, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Hi, I created an index on a table. The table has about 83,000

Good Beginner Oracle book recommendations:

Hello, I inherited an oracle database not too long ago, and I've never used Oracle. So far it's running fine and I've been able to wing the startup/shutdown procedures from looking on the net, and most of the time just keeping my fingers crossed. Went to the book store yesterday,

Re: Two indexes same columns

I agree, there is no benefit, but it perfectly allowed to create as many indexes on the same columns, as you wish. May be some DBA performance is evaluated based on 'used db space' :) Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To:

Re: Re[2]: Pocket Guide

Hi Jonathan, We still have HELP facility with 8.1.6.2. See below please... Regards Rafiq Connected to: Oracle8i Enterprise Edition Release 8.1.6.2.0 - Production With the Partitioning option JServer Release 8.1.6.2.0 - Production SQL help create table CREATE TABLE command PURPOSE: To

RE: Why are my indexes being ignored?

u didn't specify which type of index u have created. but for such low selectivity bitmap index might helps... -Original Message- Sent: Friday, June 29, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Hi, I created an index on a table. The table has about 83,000 rows.

RE: Why are my indexes being ignored?

You table doesn't have a degree 1 does it?. I've seen examples where this caused a lot of indexes to be ignored. -Original Message- Sent: 29 June 2001 16:53 To: Multiple recipients of list ORACLE-L I'm returning 117 rows. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL

Re: starting up 8i on Win2000 Problems

Yes , It occurs to me too. To overcome this error.Sometimes I need to create my database with REMOTE_LOGIN_PASSWORD _FILE=NONE. Then after creating the DB , change it to exclusive. If the problem does not go away , create a new password file with ORAPWD Then it will be ok. - Original

RE: OT: Re: Common Oracle RDBMS Misconceptions

thanks I thought it would be a good way to end it on a smile From: Guy Hammond [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT: Re: Common Oracle RDBMS Misconceptions Date: Fri, 29 Jun 2001 08:11:48 -0800 Rachel, I

RE: OT::Take a look.

Yea, Dick. I guess for real republicans, look at Helms, DeLay, and Rehnquist?? -Original Message- Sent: Friday, June 29, 2001 12:12 PM To: Multiple recipients of list ORACLE-L Dick, McCain is what one should think of as a dyslexic Republican. He thinks he's on the right when he's

Why this sql is running in parallel ??

Title: Why this sql is running in parallel ?? Hi All, I have a query which is running parallel with degree 4. I don't want this sql to run in parallel. My database is 8.1.6 optimizer_mode = CHOOSE ALL tables are analyzed Tables and index have degree =1 No hint for the parallelism is

RE: Why are my indexes being ignored?

The select statement is: select objid from trafficassignmentpersistent where subclassidentifier = 17; Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- Sent: Friday, June 29, 2001 10:53 AM To: Multiple recipients of list ORACLE-L Subject:

Off Topic posts hit the limit

Dear list members, Due to the fact that I am once again employed, I find that I no longer have time to read every message on Oracle-L. In fact, I don't have time at the moment to read most of them. So when I go home, and cozy up to the computer for a read of what's going on in Oracle-L, I

RE: 9i Open Day (UK Listers)

Reading or bracknell, may as well be the moon. I've got a living to make. I read the blurb on my invitation and it looked like a barely-scratch-the-surface-sales-job. I've got 9i installed and I can glean the same depth of information from the Oracle web site. Mind you, if I was in the area I

RE: OCP Discount S36

No restriction like this. They are advertising it on Oracle Education site.Not applicable in Japan only... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 29 Jun 2001 03:15:57 -0800 I don't think it does - it is just the Technet

Re: Good Beginner Oracle book recommendations:

Peter wrote: I'm looking for something that I can use as a reference when I need to, and also something I can read in my spare time to better understand Oracle. Oracle DBA101 from Oracle Press. good book, geared to learning ORACLE, used it to train my Jr. DBA, use it myself to look

Re: Install Oracle 9i on SUSE Linux 7.1

Hi, read the chapter 'Non-Interactive Installation and Configuration' in your platform-dependant Oracle9i Installation Guide. BTW Are there any hardcore dba's out there which installing via scp from one to another machine? oli [EMAIL PROTECTED] wrote: So basically I encountered not

RE: Why this sql is running in parallel ??

Title: Why this sql is running in parallel ?? No, tables are not partitioned -Original Message-From: Mohan, Ross [mailto:[EMAIL PROTECTED]]Sent: Friday, June 29, 2001 12:11 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Why this sql is running in parallel ??

RE: Good Beginner Oracle book recommendations:

Oracle DBA 101 by Marlene Theriault, Rachel Carmichael, and James Viscusi. That is what I started with and it was a great source. Also, you will notice that some of these authors participate on this list. Peter, May I add 'Oracle Tuning 101 by Gaja Vaidyanatha and Kirti Deshpande' to your

Perl and SQL+ and svgmgrl

Greetings members, Can I use commands like the one below in perl or I needs to use the DBI for any database use? I would like to migrate some shell scripts into perl, but I do not see if it would be convenient or feasible... sqlplus / -s EOF comands in here EOF Samples would be great!

Re: Delete me

revoke posting from [EMAIL PROTECTED] due to too much testing. joe [EMAIL PROTECTED] 06/29/01 12:45AM Hi,I am changing e-mail addresssorry for the inconvenience Best Regards Sinardy-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Sinardy Xing INET: [EMAIL

RE: Setting PCTFREE PCTUSED in a Datawarehouse

Title: RE: Setting PCTFREE PCTUSED in a Datawarehouse Hi Vikas, The docs should have discussed the reason why. High pctused can lead to a block going on and off the freelist frequently as deletes/inserts are processed, and also can leave the amount of free space inadequate for a new

Re: Pocket Guide

Was this an upgrade from a previous version? Or new install? What script did you run to get the SQL command help. I know where the one for SQL*Plus resides, but it does not contain SQL help. Jon --- Mohammad Rafiq wrote:

Re:RE: OT::Take a look.

OH, damn. Jared Bruce forgive me and I will keep it civil. As far as republicans and democrats go I'm neither (registered as an independent). Politicians are all dirty, there isn't a one that does not have a significant skeleton in the closet waiting to bash them. I'm also in favor of term

Sql question

I want to get every date between two user entered date's whether or not it exists in the table and then the quantity of data for the date if any exists. My table t1 has date and quantity values (may be more than one quantity field per date) and I want 0 for all dates in the range where no data

RE: Why this sql is running in parallel ??

Title: Why this sql is running in parallel ?? Whoops, I sent my earlier message too fast. You've already checked the degree on table and index. Hmmm... Puzzling... I'm curious to see the answer if you ever get one. R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Give me an hour

RE: Why this sql is running in parallel ??

What does v$pq_sysstat show? What does v$pq_sesstat show? (If session is still connected). - Kirti -Original Message- From: Gupta, Brijesh [SMTP:[EMAIL PROTECTED]] Sent: Friday, June 29, 2001 1:01 PM To: Multiple recipients of list ORACLE-L Subject: RE: Why this sql is

RE: Why this sql is running in parallel ??

Title: Why this sql is running in parallel ?? select from parameters where is_session_adjusted is TRUE. is there anything? -Original Message-From: Gupta, Brijesh [mailto:[EMAIL PROTECTED]]Sent: Friday, June 29, 2001 12:51 PMTo: Multiple recipients of list ORACLE-LSubject:

RE: Pocket Guide

Jon, just fooling around, I came up with this. run it thru sqlplus. obviously, change the table reference to your table. set serveroutput on spool results.xls DECLARE l_date DATE; start_date DATE := to_date('s_date','mm/dd/'); end_Date DATE := to_date('e_Date','mm/dd/'); loc_sum

RE: Sql question

Title: RE: Sql question John, I see two options. Both include a cross reference table with every date in it. 1. Outer join the dates table with the data table and nvl after the sum to replace nulls with 0's. Or 2. Simply union-all your query as it stands right now with SELECT

RE: Why this sql is running in parallel ??

Title: Why this sql is running in parallel ?? Have you checked the column DEGREE in DBA_TABLES for this table? R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Give me an hour alone in a bank Pay all my tickets, wipe the slate blank Give me a car, fill up the tank Tell me a boat

Re: OT::Take a look.

[EMAIL PROTECTED] wrote: OH, damn. Jared Bruce forgive me and I will keep it civil. As far as republicans and democrats go I'm neither (registered as an independent). Politicians are all dirty, there isn't a one that does not have a significant skeleton in the closet waiting to bash

RE: Good Beginner Oracle book recommendations:

John, Thank you for the endorsement. BTW, John also contributed to the book, and was a technical reviewer as well !! Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: John Kanagaraj [SMTP:[EMAIL PROTECTED]] Sent:

RE: Sql question

John, just fooling around, I came up with this. run it thru sqlplus. obviously, change the table reference to your table. set serveroutput on spool results.xls DECLARE l_date DATE; start_date DATE := to_date('s_date','mm/dd/'); end_Date DATE := to_date('e_Date','mm/dd/'); loc_sum

RE: Sql question

John, It's a pretty common practice to create a dates table. Comes in handy in many ways, one of which you've just encountered. Sorry that wasn't the answer you wanted. Have a great weekend anyway :-). Yosi -Original Message- From: Shaw, John B [mailto:[EMAIL PROTECTED]] Sent:

RE: Good Beginner Oracle book recommendations:

A hearty second to both these books (though the Tuning Book is definitely something to look at later). DBA 101 is perfect for where you are now. I've finally gotten my copy of Tuning 101 and am breaking the spine to have it open on my desk. I snatch the opportunity to read pages in between

RE: Griping about auditing (not the Oracle Kind)

As you might have gathered from my previous e-mail I'm not a big fan of functional division as opposed to project division. Since I was moved to a different building from the developers much of the time I don't spend dealing with the new paperwork and bureaucracy I spend on the phone. I can see

Re: Procedural Replication

David Turner wrote: I have heard numbers of about 100-800 transactions per minute as the limit for Oracle replication, but does anyone know if this would include procedural replication. If so does anyone out there know of some better solutions for replicationg a really high number of

Re: A Question on the Basics of PL/SQL

MacGregor, Ian A. wrote: Functions are used when when a value must be returned. The quotes are around value because the return type is not necessarily scalar. Under most circumstances a function only returns one value. I believe in sticking to that rule, although Oracle does not always:

BIG PROBLEM

Hello all, I just joined this list today and am in need of desperate help!!! In its infinite wisdom HR decided to lay off our only oracle dba!!! I am trying to get some backups working on our database using rman. It seems to backup our datafiles ok, but I am getting the following error ...

  1   2   >