HDTenEightyP/NetNews huggingface dataset:
From: jaakola@cc.helsinki.fi
Newsgroups: comp.databases.oracle
Subject: Re: SQL*ReportWriter order by clause (PLEASE HELP)
Date: 26 Sep 92 12:04:30 GMT
Organization: University of Helsinki

In article <1992Sep26.030925.14899@homebase.vistachrome.com>, andy@homebase.vistachrome.com (Andy Finkenstadt) writes:
> 3: but in Reportwriter the same "select" is SLO-O-O-W.
> 
> ReportWriter sometimes builds temporary tables to do some or all of
> its page layout and calculations.  It reads records from the original
> tables and then writes them to the temporary tables, then does a
> select/order by on the temporary table which requires the full table
> scan sort-merge since no indexes are created on its "temporarily"
> created table.

Is it really so? According to my *INTUITION* (which means I might well
be wrong) SRW performs the queries as-is (except some changes implied by
parent-child column linkage). Why should SRW sort the rows again, isn't
the ORDER BY clause in the query enough?

Forward references (such as %total or &NUM_PAGES) need some temporary
storage, but I think SRW uses RAM and/or disk (operating system files,
not Oracle files) space to hold the rows. That's the way I would have
implemented it. Comments, Oracle gurus?

> 
> Such is from my experience, and a judicious 'strings' of the sqlrep
> binary.
> 

Have you strings'ed runrep? I just used strings on RUNREP.PXE and found
no indication of temporary tables. How about strings on generated
reports? Or using SQL_TRACE and tkprof?

By the way, when I strings'ed RUNREP.PXE I found some SQL statements
which definitily belong to only SQLREP.PXE. Wouldn't it pay to optimize
RUNREP.PXE executable size, since RAM is a scarce resource on a PC and
the abovementioned temporary space would surely benefit from extra free
RAM? Comments, Oracle?

[To those not used to UNIX: strings is a program which extracts
printable strings from non-text files]

Well, then back to the original question:

Neil, could you post the whole queries and ALL indexes on the table(s)?
That's because the where part may force the optimizer to pick an index
which conflicts with another index suitable for sorts.
--
Juhani Jaakola
jaakola@cc.helsinki.fi
Newsgroups: comp.databases.oracle
From: sstephen@us.oracle.com
Subject: Re: Oracle on a PC?
Followup-To: comp.databases.oracle
Organization: Oracle Corporation, USA
Date: Mon, 28 Sep 1992 01:46:36 GMT
X-Disclaimer: This message was written by an unauthenticated user
              at Oracle Corporation.  The opinions expressed are those
              of the user and not necessarily those of Oracle.

In article <1992Sep25.185317.2899@spss.com>, brent@spss.com (Brent Lambert) writes:
> Regarding the following scenario:
>     386 PC
>     DOS 5
>     MS Windows
>     No network
> 
> Is there a version of Oracle 6 which will run both a server and
> clients (Windows Pro*C) in that environment?  What is the product
> called?  What is a valid connect string?  How does client programming
> differ from writing a Windows, Pro*C program that will access an
> Oracle Server for OS/2 over Lan Manager?  
> 

DOS is a non-multitasking operating system, so an Oracle 6 database for DOS is
basically a single client database.  Your programs are written the same way
on a local DOS database or a remote multitasking database.  Even if you didn't
put in any special connect string in your program, I could access my local
database with the connect string "S:" or a remote database with "X:server",
"T:host:sid", "A:...", etc., by setting up my CONFIG.ORA.  So, accessing local
versus remote is one detail you don't have to worry about when programming.

> -- 
> The above statements are not the opinions or policies of SPSS Inc.
> The above statements may not be the opinions of Brent Lambert.
> The first disclaimer is a policy of SPSS Inc.
> Subsequent disclaimers are probably the opinion of Brent Lambert.

Scott Stephens -- soley representing his own vain rantings.
Newsgroups: comp.databases.oracle
From: sparker@unity.ncsu.edu (Shachindra Parker)
Subject: Oracle technical services?
Organization: North Carolina State University Project Unity
Date: Sun, 27 Sep 1992 21:27:41 GMT

I am a graduate student at the North Carolina State University, Raleigh.  I am
starting work on a materials property database using ORACLE V6.0.

My quetions being very basic I don't want to address them into this group.  I was wondering if I could find some help from ORACLE CORP. itself by e-mail, rather than calling them up.  Does anybody know of any such thing?  I would appreciate any replies and suggestions.  Thanks in advance.

________________________________________________________________________________

                       Sachin Parker
                       NC State University, Raleigh  
                       sparker@unity.ncsu.edu
          
________________________________________________________________________________
From: epeas@abds2.aberdeen.chevron.com (John Peach)
Newsgroups: comp.databases.oracle
Subject: Re: Oracle file managerCLOSE
Date: 2 Oct 92 07:41:53 GMT
Reply-To: epeas@abds2.aberdeen.chevron.com
Organization: Chevron (UK) Ltd.
Disclaimer: The opinions expressed are mine; _not_ those of        
            the company I work for.

In article <FDaZRB1w165w@netlink.cts.com>, tumidity@netlink.cts.com (Joel Garry) writes:
|> sstephen@us.oracle.com writes:
|> > 
|> > The database is stored in a set of UNIX files.  When you issue "create
|> > database", it does a "creat" system call to create unix files in the
|> > $ORACLE_HOME/dbs directory.  If ORACLE created it's own file structure, you

--------stuff deleted

|> > of these indexes are.
|> > 
|> > Scott Stephens -- representing my own rantings.
|> 
|> I seem to recall reading that you can mount the oracle database "raw"
|> on a unix system, and it would run faster.  Anybody have any actual
|> experience with this?  And is it in ORACLE7?
|> 

Yes, I used to have an instance using raw files until someone configured
swap space on top of it! I restored it on normal UNIX filespace and
didn't notice any difference, although it is hardly a critical
application.


|> --                    
|> INTERNET:  tumidity@netlink.cts.com (Joel Garry)
|> UUCP:   ...!ryptyde!netlink!tumidity
|> NetLink Online Communications * Public Access in San Diego, CA (619) 453-1115

-- 
                               John Peach
                           Chevron (UK) Ltd.
   Ninian House, Crawpeel Road, Altens, Aberdeen, AB1 4LG, Scotland.
 Internet: epeas@abds2.aberdeen.chevron.com      Phone: +44 224 242637
From: "richard hajinlian" <richard.hajinlian@channel1.com>
Newsgroups: comp.databases.oracle
Subject: usr exits and dll's
Date: 29 Sep 92 13:41:52 EST
Reply-To: "richard hajinlian" <richard.hajinlian@channel1.com>
Distribution: comp
Organization: Channel 1 Communications

I am writing a user exit under os/2 and was wondering if anyone can tell
me if this seems ok under Oracle v6 and forms v 4?

I have a form that is supposed to call my C function upon entering a
field.  The C function does some socket calls to a remote system and
returns a value for the form field.

My first thought is to have my C module a DLL and link the forms routine
to it.  So in a nutshell my questions are:
1.) Can I use a DLL as a user exit?
2.) Should the user exit call my c funtions or should the user exit be
my functions?

Any comments would be appreciated.
  Thanks in advance people.
--
Channel 1 (R)   Cambridge, MA

Newsgroups: comp.databases.oracle
Newsgroups: comp.databases.oracle
Subject: Re: Oracle file managerCLOSE
From: tumidity@netlink.cts.com (Joel Garry)
Date: Thu, 01 Oct 92 11:25:38 PDT
Organization: NetLink Online Communications, San Diego CA

sstephen@us.oracle.com writes:
> 
> The database is stored in a set of UNIX files.  When you issue "create
> database", it does a "creat" system call to create unix files in the
> $ORACLE_HOME/dbs directory.  If ORACLE created it's own file structure, you
> wouldn't be able to back them up using normal UNIX commands.  So, yes, inodes
> and dnodes are created for these files, they are stored and accessed the same
> as any other filesystem.  If Oracle kept a directory of contiguosly allocated
> disk pointers, you would never be able to recover from disk crashes or restor
> from backups.  The drawbacks of using unix files for data storage are
> relatively small since both Oracle and UNIX depend on memory caching frequent
> accessed data.  I don't know if the files are contiguous anymore.  In Oracle 
> you used to have to manually create your data files with a utility called
> "ccf", (create contiguous file).  I know that those datafile contain some
> internal indexes into the rest of the file but I don't know what the structur
> of these indexes are.
> 
> Scott Stephens -- representing my own rantings.

I seem to recall reading that you can mount the oracle database "raw"
on a unix system, and it would run faster.  Anybody have any actual
experience with this?  And is it in ORACLE7?

--                    
INTERNET:  tumidity@netlink.cts.com (Joel Garry)
UUCP:   ...!ryptyde!netlink!tumidity
NetLink Online Communications * Public Access in San Diego, CA (619) 453-1115
From: robin@prc.unisys.com (Robin McEntire)
Subject: semaphores
Keywords: semaphores
Organization: Paramax Systems
Date: Thu, 1 Oct 1992 19:34:54 GMT

I'm running release 6.0.30 and I'm having problems with running out of
semaphores on my machine.  Part of the problem may be just not having 
enough, since I periodically add new databases to our suite of DBs.  But
it looks as though part of the problem is that Oracle is, at times, not
properly releasing it's semaphores.

Has anyone else had this problem?

thanks,
  robin


-- 
--------------------------------------------------------------------------------
Robin McEntire				   | Internet: robin@prc.unisys.com
Paramax					   |
Valley Forge Labs Research and Development | 
--------------------------------------------------------------------------------
From: 946753@arniew.llnl.gov (Arnie Weinstein)
Newsgroups: comp.databases.oracle
Subject: SQL*FORMS and SQL*REPORTWRITER running natively on next
Keywords: ORACLE NEXT
Date: 5 Oct 92 15:39:45 GMT
Organization: Lawrence Livermore National Lab

Does anyone have any experience running SQL*FORMS or REPORTWRITER natively on the
NeXT machine.
From: jared.hecker@factory.com (Jared Hecker) 
Newsgroups: comp.databases.oracle
Subject: Re: Oracle file managerC
Date: 28 Sep 92 22:14:00 GMT
Distribution: world
Organization: Invention Factory's BBS - New York City, NY - 212-274-1243v.32bis
Reply-To: jared.hecker@factory.com (Jared Hecker) 

TO: ssteph@oracle.com

SR> Scott Stephens -- representing my own rantings.
SR>

Is that 'cuz KJ won't let you rant on CI$ anymore?

BTW, Scott, when the heck are you guys gonna allow >99 extents 
per table?  It's a real PITN when you have a mix of large and
small tables.  Fragmentation becomes more than annoying in an
active database.

Maybe you guys can kick it around bettween games of 3-on-3 at the 
health club...

jh
---
 . RoseReader 1.70 G002691
                                                         
Newsgroups: comp.databases.oracle
From: carl.pedersen@dartmouth.edu (L. Carl Pedersen)
Newsgroups: comp.databases.oracle
Subject: Re: Forms 4.0
Date: 30 Sep 92 00:02:25 GMT
Followup-To: comp.databases.oracle
Organization: Dartmouth College

In article <KMALLORY.92Sep29133949@hqsun4.oracle.com>, kmallory@oracle.com
(Kevin Mallory) wrote:
> 
[A bunch of great news about the new SQL*Forms.  Omitted for brevity.]
>
> Please do not send questions about specific features to me via mail.
> Please post your questions here and we will be happy to answer them.

OK, here goes:

A while back, I posted a question about ON-ERROR and ON-MESSAGE triggers. 
I got no responses at all, posted, mailed or otherwise.  

We're using SQL*Forms 3.0.16.9.0 on VMS 5.3.

I would like to replace all or most of the builtin error messages with
"custom" error messages.   I can do this using ON-ERROR and/or ON-MESSAGE
triggers.  An example of this technique appears in the manual: "Advanced
SQL*Forms Techniques".

The problem is that when I use the MESSAGE procedure in ON-ERROR or
ON-MESSAGE, a subsequent reference to FORM_SUCCESS will return TRUE, even
if it would have returned FALSE before the trigger fired.

This makes it extremely difficult for the code in all of my other triggers
to determine whether or not errors have happened.  I've managed to work
around this problem only by creating an elaborate system of my own using
several global variables and procedures that need to be called from dozens
of different places in my form.

It's possible that the problem with FORM_SUCCESS (and other similar
procedures) is just a bug in this version of forms.  The SQL*Forms manual
leave room for doubt.  For example, many of the flowcharts in chapter 21
have a box that says "Display a message", with a specific message, followed
by an arrow that says "Stop with failure".  The question is, if
FORM_SUCCESS has a value of TRUE, how can I tell that failure has occurred?
 (I consider it significant that the "Display a Message" flowchart *always*
stops with success.)

It's also possible that what we have here is a more basic design problem. 
My Forms manual says that FORM_SUCCESS "returns the outcome of the action
most recently performed...."  Clearly, it is doing that for me.  The
trouble is that this isn't always the most useful thing for it to return. 
I *think* it'd be better if FORM_SUCCESS was set to FALSE whenever we go
through one of those "Stop with failure" boxes on the flow chart.

I've asked several people at Oracle about this and so far I've gotten no
clarification.  

Aside from this nasty problem, I also don't like the fact that if I forget
to check for success/faiure after a packaged procedure call - my code will
continue to execute as if nothing happened - blundering along and possibly
doing damage or at least confusing the user with additional errors.  Seems
to be like it'd be better for the packaged procedures to raise exceptions
or something.

Is the error-handling situation any better in SQL*Forms 4.0?

Also, how can I become a beta-tester for Forms 4.0 - either on the
Macintosh or VMS?
Xref: sparky comp.databases.oracle:1760 comp.dcom.lans.ethernet:2129
From: cuikrnx@gsusgi2.gsu.edu (Keith Nelms)
Newsgroups: comp.databases.oracle,comp.dcom.lans.ethernet
Subject: Job:  UNIX/Networking/SQL in Atlanta
Date: 6 Oct 92 14:19:03 GMT
Organization: Georgia State University



MEMORANDUM

TO:       Interested Parties

FROM:     Winfred Owens

DATE:     October 5, 1992

SUBJECT:  Position Opening

The Office of Government Information, part of the Division of
Planning and Information, has the following position open.  I would
appreciate your posting this notice and passing the word to
interested candidates.


                Network/Database Support Consultant:

The Georgia Department of Community Affairs, Office of Government
Information, has a vacancy for a position in network management and
support.  An additional responsibility is database administration.

The position is non-merit (i.e., not "civil service") and will pay
in the mid-$30s, plus benefits.

A minimum of a Bachelor's Degree in Computer Sciences (Graduate
degree would be a plus) or a related field, plus two to three years
experience, is required.

Experience with the following is required:
   - UNIX (preferably SUN)
   - SQL database (preferably ORACLE)
   - networking (Ethernet and Appletalk required, TOPS experience a plus)

Experience networking multiple platforms is required. Familiarity
with a Mac environment is required; DOS experience is a plus.
Networking UNIX to Mac is strongly preferred.

Experience with geographic information systems a plus.

Responsibilities include installing and maintaining hardware and
software; maintaining user accounts; performing backups and
recoveries as needed; providing file server assistance to users;
utilizing a variety of computers including PCs and Macs; and
maintaining the statewide planning database and assuring its quality.

For consideration, please submit a resume and salary history with
cover letter by October 30, 1992 to:

Winfred Owens
Director, Office of Government Information
Division of Planning and Information
1200 Equitable Building
100 Peachtree Street
Atlanta, GA 30303
(404-656-3879)

E-Mail applications not accepted.

No recruiters or consultants, please.

An Equal Opportunity Employer




\\\\\  Keith R. Nelms, PE       |||  Doctoral Student  /////////////
 \\\\\  Information Management  |||  Instructional Technology  ////
  \\\\\  Georgia Department of  |||  Georgia State University  ///
   \\\\\  Community Affairs     |||  cuikrnx@gsuvm1.gsu.edu  ////
    \\\\\  404-656-3879         |||  404-932-2935  /////////////
From: ciuffoli@CS.ColoState.EDU (carlos edis  ciuffoli)
Newsgroups: comp.databases.oracle
Subject: SQL-Loader
Date: 29 Sep 92 17:26:21 GMT
Organization: Colorado State University, Computer Science Department


Have any one loaded negative integers from a file using SQl-loader before ?
I have looked in the manual (SQL loader) and it does not talk much about
negative integers.   I have defined this field as :

create table ..
..
..
earn_amt	        number(7,2) ,
...
..
My ctl file looks like :


options (rows =100)
load data
infile  ......
replace
reclen 173
into table  ...
(
 ....
 ...
 earn_amt		position (167-179) decimal external,
 ...
 ..
 . )


Here is what the data looks like


E001                  0246202401                         2401 03224746892093092093085                                     1783    A900105M1007420912 000.00 PCR000.00 000001338.89-                                       1930910719309207193093072402000000.000    000000258.41-X

I can't see  anything wrong with the way I have things defined. However, I never have worked with this type of data. 

I appreciate any help, thanks.

Cheers !


-------------------------------------------------------------------------------
Carlo Ciufoli                       |Voice 303-491-6064
Computer Programmer                 |e-mail : ciuffoli@vienna.ir.colostate.edu
Budgets & Institutional Analysis    |       : ciuffoli@lamar.ColoState.edu
Colorado State University           |Disclaimer: my opinions are my own and not
Fort Collins,CO. 80525. Great U.S.A.|            of my employer.
-------------------------------------------------------------------------------
From: oispeggy@ubvmsd.cc.buffalo.edu (Peggy Brown)
Newsgroups: comp.databases.oracle
Subject: moving data from Oracle to Lotus on a pc
Date: 30 Sep 92 19:47:00 GMT
Organization: University at Buffalo
News-Software: VAX/VMS VNEWS 1.41

Does anyone have experience downloading Oracle data to a file and 
then uploading the file to Lotus on a pc?

Our Oracle application is on a VAX 4000.

Thanks,

- Peggy -
oispeggy@ubvms.cc.buffalo.edu
Newsgroups: comp.databases.oracle
From: johnh@nnshh127.uucp (John Hawkins)
Subject: Business Objects ->end user data access
Organization: Northern Telecom Inc., Nashville, TN
Distribution: usa
Date: Sat, 03 Oct 1992 00:27:57 GMT

Is anybody using BusinessObjects put out by Business Objects, Inc. ?

If so, what do you think of the product?  Tell me more!

I need to find a decent ad-hoc reporting tool yesterday!!

Thanks,
John Hawkins

Please reply to  nvjhh01@NT.COM

I disclaim! I disclaim!

Newsgroups: comp.databases.oracle
From: brad@cerberus.bhpese.oz.au (Brad Keifer)
Subject: Recovering ORACLE db after system crash
Organization: BHP, Newcastle, Australia
Date: Tue, 6 Oct 1992 22:55:52 GMT
Keywords: recover, oracle


We are currently running ORACLE Version 6.0.31.0.1 on an RS/6000, running
AIX Version 3.2.  A power failure took out the machine the other day while
ORACLE was being used. When the machine was brought up again, we had
trouble starting ORACLE. The error message we got was ORA-1545 (see below).
So to get ORACLE started I commented out the rollback_segments statement in
the init.ora file and started ORACLE. 
Using SQLDBA to look at the rollback segments table indicated that one of
the rollback segments had a status of "NEEDS RECOVERY".
I couldn't drop the table because ORACLE told me to put it offline, I 
couldn't alter it offline either, neither could I recover tablespace
"rollback_segment".

In the end we were desperate so we restored from tape.

What should I have done?


Oerr: Version 6.0.31.0.1 - Production on Wed Oct 07 08:47:21 1992

Copyright (c) Oracle Corporation 1989.  All rights reserved.

01545, 00000, "rollback segment '%s' specified not available"
// *Cause: 1) Try to acquire offline rollback segment during startup.
//	   2) Try to drop a rollback segment that contains active transactions.
// *Action: 1) Bring the tablespace containing the rollback segment online or
//	       do not specify the rollback segment in init.ora.
//	    2) If the rollback segment is in use, shutdown the instance using
//	       rollback segment, else if the rollback segment needs recovery,
//	       find out the errors that are holding back the rolling back
//	       of the transactions and take appropriate actions.

-- 
Brad Keifer, BHP Information Technology, Newcastle Region, Australia
PO Box 216.  Hamilton.  NSW.  2303
internet: brad@cerberus.bhpese.oz.au            Phone: +61 49 402126
                                                Fax:   +61 49 402165
Newsgroups: comp.databases.oracle
From: dtb@otto (David Bath)
Newsgroups: comp.databases.oracle
Subject: Re: Pro*C Variables and Define Tokens
Date: 29 Sep 92 10:50:47 GMT
Organization: RMIT Computer Centre
NNTP-Posting-Host: otto.bf.rmit.oz.au

If anyone is having a problem that means you want VARCHARS to be
#defined (or even runtime defined !) I have a library of C routines
that allows you to manage VARCHARS nicely.

This includes the following C calls that mimic string.h type functions
but also allow you to convert strings to varchars
	vch_malloc
	vch_vchcpy
	vch_strcpy
	str_vchcpy

If anyone wants it, I can mail it to you
If heaps of people want it I will post the source to comp.databases.oracle

========================================================================
David T. Bath
email: 	dtb@otto.bf.rmit.oz.au
Work: 	Global Technology Corporation, Carlton, Vic, OZ  (03) 3477511
#include <disclaimer.h>
=======================================================================
-- 
========================================================================
David T. Bath
email: 	dtb@otto.bf.rmit.oz.au
Work: 	Global Technology Corporation, Carlton, Vic, OZ  (03) 3477511
From: tumidity@netlink.cts.com (Joel Garry)
Newsgroups: list.epixinfo,comp.databases.oracle
Subject: Re: orasrv: server already running: Address already in use
Date: 5 Oct 92 21:50:41 GMT
Organization: NetLink Online Communications, San Diego CA

peter.steele@acadiau.ca (Peter Steele) writes:

> This error occurs when orasrv, the oracle kernel daemon, is
> shutdown and the restart command is issued to soon after the
> shutdown. Waiting a couple of minutes usually solves the problem.
> However, we occasional get a situation where orasrv gets confused
> and will issue this error indefinitely. The only way we've discovered
> to clear this error is by rebooting, which isn't desirable on
> a production machine.
> 
> Has anyone seen this error, where Oracle gets confused and won't
> let you restart orasrv?
> --
If you are on a unix machine, run ipcs to find out what semaphores and
shared memory areas are being used.  Run ipcrm to remove them.  Then
do a normal start.  I've also run into this when given a bad Oracle
installation tape, which required the additional step of chmod +x on
the executables.

--                    
INTERNET:  tumidity@netlink.cts.com (Joel Garry)
UUCP:   ...!ryptyde!netlink!tumidity
NetLink Online Communications * Public Access in San Diego, CA (619) 453-1115
Xref: sparky comp.databases.oracle:1745 pnw.general:2229