HDTenEightyP/NetNews huggingface dataset:
From: john@timer1.UUCP (john)
Newsgroups: comp.databases.oracle
Subject: Problem on field of DEFAULT WHERE/ORDER BY on Form 3.0
Keywords: SqlForm3.0, Oracle
Date: 27 Aug 92 19:24:14 GMT
Organization: Rightime Econometrics, Inc., The Forst Pavilion, Wyncote, PA 19095-1596

Hi, world:

In our company, we implemented a "Task Manager" with SqlForm30 to 
keep track of our projects. When user run the form, we want him/her
see only the tasks he/she is allowed to see. So, we put some conditions
in DEFAULT WHERE/ORDER BY field of form30. Here is the piece from INP 
file:

      ORDERING = <<<
      where requestor in  (select access_name from DS_manager.user_access30
            where user_name = lower(USER))
         or request_for in (select dept_code from
            DS_manager.dept_access30 where user_name = lower(USER))
         or assigned = lower(USER)
      ORDER BY Date_completed desc,DATE_REQUIRED, PRIORITY, date_entered
      >>>

When I added in 4th OR condition in it then generate and execute it, it
had segment fault and core is dumped (on unix environment) but if I trimmed
that part, it goes fine. We guessed that the buffer mighted be too small 
to hold the whold conditions.

Does any one know any limit on the buffer size of DEFAULT WHERE/ORDER BY
field of block definition screen on Form 3.0. Or, it might be the limit
of the number of "OR" conditions 

Any info will be apprecaited.

John Chan (Rightime Econometrics, Inc)
From: kml@cellar.org (John Galt)
Newsgroups: comp.databases.oracle
Subject: Re: Oracle7 userids
Date: 2 Sep 92 12:57:06 GMT
Organization: The Cellar BBS and public access system

pihlab@hhcs.gov.au writes:

> 
> Under Oracle6 when you revoke all access for a user there is no easy
> way of actually removing them completely from the database ie they still
> appear in the DBA_USERS table as a valid but inactive user.
> 
> Has this changed under Oracle7 ?
> 
> -- 
> 
> Bruce...        pihlab @ hhcs.gov.au
>                  ^^
> 
> PS. Someone please post a followup to this news group so I know that my

Not only can you DROP USER in V7, you can also drop all their objects
automatically via the DROP USER x CASCADE command.  See Volume II,
page 18-17 of the V7 Developers Version DBA Guide.  This command gets
rid of the user's old account completely.

kml.



       As a matter of fact, no, I don't have a life.
  kml%cellar@tredysvr.tredydev.unisys.com - My other account is a Mercedes.
Newsgroups: comp.databases.oracle
From: wwm@ef2007.efhd.ford.com (William Meahan)
Subject: Re: SQL*plus -- limiting maximum number of returned rows?
Organization: EFHD Ford Motor Company
X-Newsreader: Tin 1.1 PL3
Distribution: usa
Date: Mon, 31 Aug 1992 22:58:59 GMT

GO.MSB@isumvs.iastate.edu writes:
: In article <BtuK40.8By@ef2007.efhd.ford.com>,
: wwm@ef2007.efhd.ford.com (William Meahan) writes:
: >In SQL*Plus (not embedded SQL!) is there any way of limiting the number
: >of rows returned by a query?
: >
: >I am working on a report that is supposed to find the "top 5" items in
: >a catagory.  The query returns 0 or more rows based on the selection
: >criteria, sorted in the appropriate order.  Some queries return a dozen
: >or more rows, but I'm only interested in the first 5.
: >
: >If I were using embedded SQL in a C program (or a perl script using
: >oraperl) the solution would be trivial.  For internal reasons, however,
: >I'm stuck with using SQL*Plus.
: >
: >Any ideas?
: >--
: >Bill Meahan                     |EFHD Information Systems Staff
: >Technical Consultant            |Ford Motor Company
: >wwm@ef2007.efhd.ford.com        | +1 313 487 6122
: >...!fmsrl7!ef2007!wwm           |I'm not paid to speak for Ford!
: ---------------------------------
:   try   WHERE ROWNUM < 6
: 
: ALthough this works, I hate it.  If the query returns 2000 rows, it still
: does and you wait for it to do so.  It then hands you the first 5 or whatever
: you request.  ROWNUM is a pseudo-column and doesn't exist until some rows are
: returned.
: 
: Marvin Beck    Iowa State University

Yep.  That'll do exactly what I _ASKED_ for, but not what I want :-(
(don't you just hate it when your brain goes on vacation while you're
entering a question into NetNews?)

The reality is more complex.

Consider the following records:


Machine  Station   Fault   Count
-------- --------  ------- -----
Machine1 Station1  Code22  32
Machine1 Station1  Code36  16
Machine2 Station1  Code06  427
Machine1 Station2  Code13  202
...
etc.


The select will return many rows with combinations of Machine, Station and
Fault.  The trick is to select the "Top 5" Faults for EACH combination
of Machine and Station based on the value of Count.

Much trickier, eh?
-- 
Bill Meahan			|EFHD Information Systems Staff
Technical Consultant		|Ford Motor Company
wwm@ef2007.efhd.ford.com      	| +1 313 487 6122
...!fmsrl7!ef2007!wwm           |I'm not paid to speak for Ford!
QUIT

....!fmsrl7!ef2007!wwm           |I'm not paid to speak for Ford!
Newsgroups: comp.databases.oracle
Subject: how to compress database and move indexes to different tablespace
From: suskind@bbs.mdcbbs.com
Date: 2 Sep 92 10:06:26 GMT
Organization: E-SYSTEMS
Nntp-Posting-User: kohlhase

I am trying to compress my database. While I am at it I am moving stuff
into various tablespaces to improve performance and layout. My original
database has only ONE tablespace "system". My new database will have
"system", "user", "temp", and "index". I can see how to easily move
a user's tables into the "user" tablespace by only giving him resource
in that tablespace and altering his user account so "user" is his default
tablespace. 

However, how to I move the corrisponding indexes? I have tried using the
"show" option of IMP to generate a file, but this file is in such a poor
format I cannot use it without EXTENSIVE editing. Does anybody have a
utility that will take the file generated by the "show" option and make it
usable? The format I get is ONLY 80 column records and EVERY line is
enclosed in double quotes.

thanks in advance

+---------------------------------------------------------------------+
Barry A. Suskind                  Internet:   suskind%edoras@mdcbbs.com
MaBell: 703-560-5000x2348             UUCP: uunet!mdcbbs!edoras!suskind
E-Systems / Melpar Division 7700 Arlington Blvd, Falls Church, VA 22046
JSNM                                             Just Stark Naked Magic
From: pihlab@hhcs.gov.au
Newsgroups: comp.databases.oracle
Subject: Re: Name of trace file currently being written.
Date: 4 Sep 92 08:24:28 +1000
Organization: Aust. Dept. Health, Housing and Community Services

In article <BtwpHz.59J@nntp-sc.Intel.COM>, kortikar@mipos2.intel.com () writes:
> Hi 
> 
> I would like to find out name of trace file currently being written.
> 
> set sql_trace true;
> explain plan .......
> set sql_trace false;
> 
> I currenlty use "ls -lt /oracle/rdbms/log/*trc | head -1" to find this out.
> I need it for automating tkprof.
> 
> Thanks a lot in advance.   
> 
> Aniruddha Kortikar  (kortikar@mipos2.intel.com)

I'm not sure how you would do that under UNIX.  Do you have a facility to
observe who is locking files?  If so the check the trace directory for some
file being locked by your session.

I'm working in Oracle under VMS and the way we do this is to define a logical
(ie a directory definition) which overrides Oracle's default TRACE directory
(for MY CURRENT session only).  In this way I know that the TRACE file in MY
particular directory is mine.  Can you do that under Oracle for UNIX.

Hope this helps.

-- 

Bruce...        pihlab @ hhcs.gov.au
                 ^^
*******************************************************************
* Bruce Pihlamae  --  Database Administration                     *
* Commonwealth Department of Health, Housing & Community Services *
* Canberra, Australia                             (W) 06-289-7056 *
*******************************************************************
* These are my own thoughts and opinions, few that I have.        *
*******************************************************************
Newsgroups: comp.databases.oracle
From: byron@sfsuvax1.sfsu.edu (Byron Chun)
Subject: Approach for Windows - SQL*Net
Organization: California State University, Sacramento
Date: Sat, 29 Aug 1992 00:05:55 GMT

Has anyone used Approach for Windows to "approach" an Oracle server?

I an having trouble doing this - namely, what's required?  The
documentation is not clear.  I have a MS-Lan Manager workstation
with local Oracle 6.0 installed, TCP/IP for MS-DOS 1.1.6 (or something)
3Com 3C501 and 3C503 boards.  How do I tell the SQLTCP task what my
IP address is?  Is this necessary?  I have not been able to get SQLPlus
to talk to another host yet.  What am I missing?            

Very Frustrated in San Francisco...  :<


-- 
byron@sfsuvax1.sfsu.edu           =====================================
                                  | My employer will allow me to have |
"It's not in my job description,  | an opinion.  They just won't back |
 but I'll do it anyway."          | me if things go sour.             |
Newsgroups: comp.databases.oracle
From: tcox@netcom.com (Thomas Cox)
Subject: Re: Other Forms than SQL*FORMS
Date: Sun, 30 Aug 92 22:22:08 GMT
Organization: Netcom - Online Communication Services (408 241-9760 guest)
Summary: Yes, Virginia
Followup-To: comp.databases.oracle

john@sequent.com (John Vander Borght) writes:
>sjs@netcom.com (Stephen Schow) writes:

>>Anyone know much about other forms generation packages that work with the
>>Oracle RDMS.  This could include Client/Server as well as UNIX based.

>There are a number of packages.  [list deleted]

No kidding.

If you want the whole list of products that work with Oracle
databases, you should get Oracle part number 52294-0292, the Oracle
_Business Alliance Program Products and Services Catalog_.

The answer to Stephen's question can be found in Section 2:  of the
135 software packages listed as coming from "independent software
vendors", 32 are in the category "Application Development Tools".  I'm
not sure if that is the same as "forms generation packages".  If you
wanted CASE tools, try the four CASE tool vendors listed (or Oracle's
own CASE tools, which are not listed here).

That doesn't count the other 327 products listed as coming from "Value
Added Resellers".  

The Catalog also has 73 listings for Preferred Systems Integrators
(USA only it looked like), and a brief listing of Independent Oracle
Consultants. 

Oh, if you want to be _in_ the catalog, send me e-mail at
tcox@us.oracle.com, and I'll forward it wherever it's supposed to go.
(Please, just your name and number, USA only.  Thanks.)  

Hope this was helpful.

Cheers.
	-- Tom
-- 
Tom Cox      DoD #1776   '91 CB 750 Nighthawk   tcox@netcom.netcom.com
Yeah, I have a day job.  They don't believe me any more than you do.
From: tcox@netcom.com (Thomas Cox)
Newsgroups: comp.databases.oracle
Subject: Re: Approach for Windows - SQL*Net
Date: 1 Sep 92 01:21:42 GMT
Organization: Netcom - Online Communication Services (408 241-9760 guest)

byron@sfsuvax1.sfsu.edu (Byron Chun) writes:
>Has anyone used Approach for Windows to "approach" an Oracle server?

>I an having trouble doing this - namely, what's required?  The
>documentation is not clear.  I have a MS-Lan Manager workstation
>with local Oracle 6.0 installed, TCP/IP for MS-DOS 1.1.6 (or something)
>3Com 3C501 and 3C503 boards.  How do I tell the SQLTCP task what my
>IP address is?  Is this necessary?  I have not been able to get SQLPlus
>to talk to another host yet.  What am I missing?            

>Very Frustrated in San Francisco...  :<

The required thing is to get SQL*Net to work.  All Oracle-compatible
products that I know of just plug in to SQL*Net the same way Oracle
brand tools do -- or the way your own Pro*C or OCI programs do.

(The exception is for tools that use DAL or TechGnossis SequeLink, which
bypass SQL*Net.  But you aren't.)

I saw a demo of Approach -- it looked like FileMaker II on the Mac in
terms of its ease of use.  And maybe slightly more powerful.  Definitely
an end-user tool.  

Cheers.
	-- Tom
-- 
Tom Cox      DoD #1776   '91 CB 750 Nighthawk   tcox@netcom.netcom.com
My opinions!  Mine!  Not those of Netcom, or Oracle, or anybody else I know...
Newsgroups: comp.databases.oracle
From: howard@monitor.com (Howard Brenner)
Subject: Whoops! My address was wrong on my last message!
Reply-To: howard@monitor.com (Howard Brenner)
Organization: Monitor Company / IE
Date: Wed, 19 Aug 1992 22:19:40 GMT

Question is:  is it faster to preallocate a large table to hold data or to  
just let oracle do its thing with the default settings?

thanks!
Newsgroups: comp.databases.oracle
From: george@unixg.ubc.ca (George chow)
Subject: Followup to: GRANTing permissions...
Originator: george@unixg.ubc.ca
Organization: University of British Columbia, Vancouver, B.C., Canada
Date: Tue, 25 Aug 1992 20:42:44 GMT

I posted the following article yesterday asking about table references. 

==
Howdy,

Yet some more questions from a rookie about putting together an application. 

I need to grant permissions on the objects that I have created for a specific
application to some users. I know about the GRANT command but it's sorta
cumbersome to have to GRANT permissions to each and every user that needs the
application. Is there a way to have Oracle use Unix-style groups?

Second question: is it really the case that I have to qualify each and every
reference to an object in my application's forms and reports with the creator's
(my) ID? If so, why didn't CASE*Generator do that for me? As such, I ended up
writing a sed script to prepend my ID to each of my objects and manually
wrapped each line of my .inp files at 80 columns. A real bother.
==

I received 3 replies back. The conclusion is:
  o set the TABOWN option in CASE*Generator if I want to have the full 
    reference in the generated forms, reports, et al or
  o use a public and/or private synonym for each user or
  o use V7's "role" feature

V7's "role" feature sounds like what I really want. I.e., group-like
control over access. Can someone who knows a bit more about V7's "roles"
explain if it will allow you to control access to objects in a 
Unix-group-like manner?

George

Newsgroups: comp.databases.oracle
From: ken@cs.UAlberta.CA (Huisman Kenneth M)
Subject: version 7
Keywords: oracle version 7
Organization: University of Alberta, Edmonton, Canada
Date: Sat, 29 Aug 1992 01:20:28 GMT

Does anyone know when exactly oracle version 7 comes out for the PC???

We really need to get some of the .dll's for windows that comes with it,
and we are hoping to have them by january.  Will it be available
before that?

thanks to anyone who knows.

Ken

ken@cs.ualberta.ca
From: sjs@netcom.com (Stephen Schow)
Newsgroups: comp.databases.oracle
Subject: Re: olsqlforms crashes
Date: 27 Aug 92 17:11:51 GMT
Organization: Netcom - Online Communication Services  (408 241-9760 guest)

I am also interested in the ispell program.  If someone has it or knows where I can get it, then let us know.

Thanks in advance
-- 
------------------------------------------------------------------
Steve Schow    | But you don't have to use the claw, if you
sjs@netcom.com | pick the pear with the big paw paw......
               | Have I given you a clue......?
               |                       - Baloo the Bear
------------------------------------------------------------------
Newsgroups: comp.databases.oracle
From: kjou@oracle.com (Kathy Jou)
Subject: Re: Name of trace file currently being written.
Organization: Oracle Corporation
Date: Fri, 4 Sep 1992 00:42:03 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 <BtwpHz.59J@nntp-sc.Intel.COM> kortikar@mipos2.intel.com () writes:
>Hi 
>
>I would like to find out name of trace file currently being written.
>
>set sql_trace true;
>explain plan .......
>set sql_trace false;
>
>I currenlty use "ls -lt /oracle/rdbms/log/*trc | head -1" to find this out.
>I need it for automating tkprof.
>
>Thanks a lot in advance.   
>
>Aniruddha Kortikar  (kortikar@mipos2.intel.com)

The UNIX pid of the process running the explain plan will be a part of the
trace file name.  The naming convention is <ORACLE pid>_<UNIX pid>.trc dumped
in the USER_DUMP_DEST directory.


-- Kathy Jou
-- Oracle Corp
-- Disclaimer: only my opinion.
From: nakkala@cs.tamu.edu (Venkatesh Nakkala)
Newsgroups: comp.databases.oracle
Subject: Doubt regarding granting OPS$ user ids.......
Date: 4 Sep 92 19:24:05 GMT
Article-I.D.: tamsun.1992Sep4.192405.19392
Organization: Computer Science Department, Texas A&M University


   Howdy,
   
	I have been using ORACLE using only one account (the oracle
	account used for installing) till now.Now when trying to
	assign users using the ops$user_name, I am getting the
	following error (on doing sqlplus from the ops user's account)..
  
  Enter user-name:
  ERROR: ORA-01034: ORACLE not available
  ORA-07318: smsget: open error when opening sgadef.dbf file.
  SunOS Error: 13: Permission denied

  The database has been opened in shared mode and the shared
  memory segment has  "rw" permissions only for oracle.
  Also I've set the env. variables ORACLE_HOME and ORACLE_SID and other
  variables 
  appropriately.

  Thanks in advance,

  Venkatesh Nakkala

--
-----------------------------------------------------------------------------
		     Venkatesh  Nakkala    nakkala@neuron.tamu.edu 
 Off : (409)845-5481                       Res : (409)268-7404
 Dept. Of Comp Sci.,Texas A & M Univ.      Fax : (409)847-8578 
Newsgroups: comp.databases.oracle
From: GO.MSB@isumvs.iastate.edu 
Subject: Re: SQL*plus -- limiting maximum number of returned rows?
Organization: Iowa State University, Ames IA
Distribution: usa
Date: Mon, 31 Aug 1992 20:49:47 GMT

In article <BtuK40.8By@ef2007.efhd.ford.com>,
wwm@ef2007.efhd.ford.com (William Meahan) writes:
>In SQL*Plus (not embedded SQL!) is there any way of limiting the number
>of rows returned by a query?
>
>I am working on a report that is supposed to find the "top 5" items in
>a catagory.  The query returns 0 or more rows based on the selection
>criteria, sorted in the appropriate order.  Some queries return a dozen
>or more rows, but I'm only interested in the first 5.
>
>If I were using embedded SQL in a C program (or a perl script using
>oraperl) the solution would be trivial.  For internal reasons, however,
>I'm stuck with using SQL*Plus.
>
>Any ideas?
>--
>Bill Meahan                     |EFHD Information Systems Staff
>Technical Consultant            |Ford Motor Company
>wwm@ef2007.efhd.ford.com        | +1 313 487 6122
>...!fmsrl7!ef2007!wwm           |I'm not paid to speak for Ford!
---------------------------------
  try   WHERE ROWNUM < 6

ALthough this works, I hate it.  If the query returns 2000 rows, it still
does and you wait for it to do so.  It then hands you the first 5 or whatever
you request.  ROWNUM is a pseudo-column and doesn't exist until some rows are
returned.

Marvin Beck    Iowa State University
Newsgroups: comp.databases
From: comm117@unixg.ubc.ca (Chin)
Subject: Foxpro 2.0 Compiler
Organization: University of British Columbia, Vancouver, B.C., Canada
Date: Fri, 4 Sep 1992 06:40:32 GMT

I am new to this newsgroup so please excuse me if this is a FAQ (or
better yet, refer me to a site which contains a FAQ for this group.

I have been told that there is a separate package for Fox that turns
your .APP files into .EXE files.  What I want to know is the following:

	(1) What performance improvements are there?  My project
	    performs a lot of windowing.  This seems to really slow
            down the program.  Would the compiler package help?

	(2) Any known bugs?

	(3) What size are the resulting .EXE files as compared to the
	    .APP files?

Please email your responses to GAVIN@phdlab.commerce.ubc.ca,
NOT to the above address as it is about to be disabled.

Thanks,
Gavin Chin
 
Xref: sparky comp.databases:6342 comp.databases.theory:398 comp.databases.oracle:1381
From:  (Bill Winett)
Newsgroups: comp.databases,comp.databases.theory,comp.databases.oracle
Subject: Re: Is this a bug or a limitation of the SQL language
Date: 25 Aug 92 18:52:29 GMT
Organization: Apple

In article <1992Aug23.074048.16681@prism.poly.edu>, sjha@prism.poly.edu (Salil Kumar Jha) writes:
> 
> I tried to do this query in Oracle and DB2 and both failed. I know its
> not allowed but why not?
> 
> Assume the use of the classic oracle emp table
> 
> select * from emp 
> where salary between
> (select salary from emp where ename = 'Larry')
> and
> (select salary from emp where ename = 'John')
> 
> Isnt this the best way of finding all people whose salaries lie between those
> of Larry and John (without knowing whose is larger)
> 
> sjha@prism.poly.edu
> 
No, it isn't the best way.  Here's how you can do what you want:

select * from emp
where salary in (select salary from emp where ename between 'John' and 'Larry');
From: ivang@cup.portal.com (Ivan - Godard)
Newsgroups: comp.databases
Subject: Re: Info on large, slow storage wanted (jukeboxes, etc.)
Date: Tue,  1 Sep 92 19:32:15 PDT
Organization: The Portal System (TM)
  <1992Aug31.043738.19685@psg.com> <22302@venera.isi.edu>

>vhs@rhein-main.de (Volker Herminghaus-Shirai) writes:
>
>> I need to design a retrieval system for ~15TB of data, of which ~5TB are
>> retrieved with a high frequency (25 requests/second) and an access time
>> of avg. 30 seconds (max. 120 seconds). Retrieval lacks any locality, so the
>> 5TB are real random-access. The rest of the data is still accessed at a
>> rate of 5 requests/second.


After you get the hardware solved, you are still going to have to have the
software to access it. Suggest you look into the Kala persistence
server at these sizes - they are at kala@world.std.com.
Newsgroups: comp.databases
From: joet@dcatlas.dot.gov (Joe Trott)
Subject: Re: paradox: example elements in an OR expression
Organization: U.S Dept. of Transportation
Distribution: usa
Date: Fri, 28 Aug 1992 14:15:11 GMT

gulati@access.digex.com (Raj K. Gulati) writes:

>I recently posted a JOB/CANDIDATE application problem, where the goal
>of the query is to match a job with candidates, where the fields in
>either could be matching, or blank.

>This would be easy if it were not for the restriction that paradox
>does not allow example elements to be combined in an OR expression,
>for example:  ~123 or BLANK, which then could be placed in all the
>fields of both ask tables.

>Anyone have any ideas on how to either Query, or PAL program around
>this? Help.

This may be grisly, but you could try it.  Run two separate queries (or
as many as you need), then after each case append the resulting Answer table to
your results table with Tools|More|Add.  If, for example, you have a results
table for which you design reports and/or forms for use after the matching
process, then your script would first empty it, then run the queries, then
make it available for display/edit/reporting.  You probably _would_ want to
do this; in your Jobs table you could have some fields that describe current
status.  Included in your Matches table, these fields would let you maintain
the status with regard to any particular candidate.

-JTT

Newsgroups: comp.databases
From: schli@cs.tu-berlin.de (Wolfram Schlickenrieder)
Subject: clipper: Network / Index Question...
Organization: Techn. University of Berlin, Germany
Date: Thu, 27 Aug 1992 09:55:15 GMT



	Hi there...

	I have two (probably simple?) question about indexes:

	- How can I determine wether an index file is still "up to
	  date" / "valid" for a data base or not? E.g., two users use
	  the same dbase & index through the net, user A appends a
	  record and has *not* *yet* issued a reindex command. How
	  does user B know that the index is not up to date?

	- (Same situation as abov. If onuser A eventually *does* issue
	  a "reindex", and thus updating an index which is used by
	  user B as well, is B's index still valid after the
	  "reindex"?

	Any help is greatly appreciated...

	...Wolfram


Newsgroups: comp.databases