HDTenEightyP/NetNews huggingface dataset:
From: esc@netcom.com (Steve Etchelecu)
Subject: maxdatafiles -- inquiry/update
Date: Thu, 27 Aug 92 05:13:16 GMT
Organization: Netcom - Online Communication Services
Followup-To: comp.databases.oracle
Distribution: usa
Keywords: maxdatafiles


I am looking for a method to inquire on the current value for
the MAXDATAFILES parameter which was set when a database is created.

More importantly, I am looking for a method to increase this value
without having to recreate the database.

Any help would be greatly appreciated.

Thanks,
Steve Etchelecu
esc@netcom.netcom.com
Newsgroups: comp.databases.oracle
From: colten@cbnewsb.cb.att.com (marc.colten)
Subject: Problems in olsqlforms30 and OCI (in C)
Keywords: FORMS, ORACLE, C, OCI
Organization: AT&T
Date: Thu, 3 Sep 1992 16:35:21 GMT


Well here I am again.  I've been using olsqlform30 to create forms
and the OCI (in "C" language) to insert and extract information.
I've been hitting some problems and would appreciate some advice.
Please e-mail and responses and I will summarize and post.

thanks in advance,

marc colten


1)  I created a table with a LONG field for comments.  I can
    add and edit that field just fine (I have a 
    ON-NEW-FIELD-INSTANCE trigger with EDIT_FIELD in it).
    However, my C program will not extract that field in any
    way.

    Some code is :

     struct {
            ...
            ...
            ...
            ...
            ...
	    char TROUBLE[65535];
	    } attr[3];


     odefin(C0,5,attr[1].TROUBLE,(int) strlen(attr[1].TROUBLE),LONG,
                   -1,dum,NULL,-1,-1,&dum2,&dum3);

    
   When I fetch the data, everything else comes up okay, but
   I get a message that the field has been truncated.  I
   print it out character by character (assuming it was not
   NULL terminated) and it's empty.  I have tried putting the
   field length directly into the odefin, and the field length
   in the structure has been anywhere from 100 to 67000.   I have
   used LONG and STRCHR as identifiers.  Nothing.


2) I have used structures with no array:

     struct {
            ...
            ...
            ...
            ...
            ...
	    } attr;


and it does not work.  If I use attr[3], I can't get the
data into attr[0].  But if I use a number > 1 and assign
the output to attr[1].<field>, it always works.  Can anyone
explain this?

3)  Can you do a query on a detail block and have the relevant
    information come up in the master block?  It works fine
    the other way.  I do a query in a master block and it brings
    up two records in the detail (which it should).  I've tried
    doing the reverse and it won't work.  I set up a KEY-ENTQRY
    trigger on the detail block with various commands:

         go_block('<master>');
         :<master>.field := <detail>.field;
         execute_query;
    
    But no luck.  execute_query wipes out the master block
    before it does anything. What I wind up with is the
    detail block shows the information what I wanted, while
    the master block shows the data you'd get from a blank field.
    
    What I want to do is:
        enter the query in the detail block.
        execute the query.
        The master block queries it's table to come up
          with the appropriate information based on the data
          placed in the detail.
        The master executes a query so the master and the detail
          (two records now) show the matching data.

    Is this possible?


4)  Can you do a LOV on a block, or failing that on a non-enterable
    field?  I just want a list relevant to the data I've queried
    as an alternative to a second page, which is not really necessary
    and really slows things down.



Thanks
Newsgroups: comp.databases.oracle
From: kjou@us.oracle.com (Kathy Jou)
Subject: Re: PL/SQL, V$ problem
Keywords: workaround reserved
Organization: Oracle Corporation, Redwood Shores CA 94065
Date: Wed, 2 Sep 1992 17:05:35 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 <1992Sep1.155256.336@hhcs.gov.au> sharmp@hhcs.gov.au writes:
[stuff deleted...]
>	INSERT INTO dbu.drs_snapshot_v$lock
>	     SELECT d.db_started,
>		    d.db_closed,
>		    v.addr,
>		    v.pid,
>		    v.type,
>		    v.id1,
>		    v.id2,
>		    v.lmode,
>		    v.request
>	       FROM v$lock v, dbu.drs_driver d
>fails because TYPE is a PL/SQL reserved word.  Sure, we could create the insert
>statement as select * from, or rename the column, but is there a way to get
>PL/SQL to accept a reserved word as a column name (how come ORACLE uses
>reserved words anyway?! :^)).

Upper case the reserved words and put double quotes around them, i.e. use
v."TYPE".  This is a rough workaround since the restriction is clearly 
documented.  All *programming* languages have reserved words (can't declare a
variable called if in C).  I guess we just have to live with it.


-- Kathy Jou
-- Oracle Corporation
-- Disclaimer: not an official Oracle spokesperson...

Newsgroups: comp.databases.oracle
From: john@sequent.com (John Vander Borght)
Subject: Re: Other Forms than SQL*FORMS
Organization: Sequent Computer Systems, Inc.
Distribution: sqnt
Date: Thu, 27 Aug 92 22:58:29 GMT

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.  Two of the best I've seen are:

Uniface		This is a good product that also has the benefit of working
		with almost any database, Windows, X (Motif and OpenLook),
		Unix, VMS (yuck :-), Client/Server from Windows to Unix or
		VMS.
PowerBuilder	A good product that only works in the Windows environment
		either with local DBs or Client/Server.
	
Some others include (passed on without comment):
Unify
Focus
Ally
JAM
SQL*Windows

If you are working in an environment of heterogenous presentation devices
or with multiple databases (especially in one application), I think Uniface
would be the best product.

John Vander Borght
john@sequent.com
-- 
"Practice random kindness and senseless acts of beauty!"
John Vander Borght
john@sequent.com
Newsgroups: comp.databases.oracle
From: mlo@cray.com (Mick Oyer)
Subject: Re: ORAPERL
Reply-To: mlo@cray.com
Organization: Cray Research, Inc.
Date: 25 Aug 92 15:53:33 CDT

In article 19480@stortek.com, v045100@otis1.stortek.com (Jennifer Farnham) writes:
>
>Is anyone out there familiar with ORAPERL?
>
>Supposedly its Perl with embedded Oracle....?
>
>Before I build it on our system, I would like
>to hear from people who are somewhat familiar
>with it. 
>

I use oraperl a lot, not so much for ITs usefulness, but because of
the overall usefulness of perl.  It's great to just slurp in a
set of records, process them any 'ol way you want, and use the
formatting options of perl to spit them out.

About the only things lacking are the sqlplus functions (column formatting
for example) although perl's printf usually works as well, if not better.

I believe you'll need access to the Pro*C libraries to build oraperl, but
as with perl itself, the building is relatively painless (don't quote me,
I didn't build it on our system, but have talked to the guy that did).

There's an oraperl man page.  It's the only oraperl documentation I've
ever needed.

---
   | Michael (Mick) Oyer   EMAIL  :  mlo@cherry.cray.com  ||  uunet!cray!mlo   |
   | Sr. Software Analyst  VMAIL  :  work: (612)-683-5855                      |
   | Cray Research, Inc.   USNAIL :  655F Lone Oak Dr., Eagan, MN 55120        |

Newsgroups: comp.databases.oracle
From: geoff@ugc.uucp (Geoff Coleman)
Subject: Re: Customization of SQL*Forms.
Keywords: SQL*Forms, Oracle CASE
Organization: UGC Consulting Ltd.
Date: Wed, 2 Sep 1992 03:52:44 GMT

In article <1992Aug27.200923.26659@oracle.us.oracle.com> wkaufman@us.oracle.com (William Kaufman) writes:



>    I don't know if the .inp files are going away, but, *if* they do,
>they will probably be replaced with Oracle resource files.  Resource
>files can be converted into text files and back again at any time (with
>"resprint" and "resparse", respectively).  If they're using resource
>files now, you can always resprint them, edit them, and resparse them
>back.

	Does this hold true fro OraKit resource files. If so where does one find
	resparse and resprint ?????


	Geoff Coleman
From: mpd@hermes.dlogics.com
Newsgroups: comp.databases.oracle
Subject: Hash clustering vs Indexing in ORACLE7
Date: 27 Aug 92 11:57:53 CST
Organization: Datalogics, Inc., Chicago, IL

Anybody used hash clustering in place of indexing?
Am considering it for a new app, and am wading through zillions of
pros and cons.  Some anecdotal accounts, or just plain opions, would
be most helpful.  

Thanks in advance...
-- 
-----------------------------------------------------------------------------
    MICHAEL DURBIN  mpd@dlogics.com                     
  -----------------------------------       
    DATALOGICS,INC  441 West Huron  Chicago, IL  60657  (312)266-3227
-----------------------------------------------------------------------------
From: boxfield@ibmpcug.co.uk (Paul J Snelling)
Newsgroups: comp.databases.oracle,connect.audit
Subject: Re: version 7
Date: 1 Sep 92 10:38:35 GMT
Organization: The IBM PC User Group, UK.
X-Disclaimer: The views expressed in this article are those of the author
	alone and may not represent the views of the IBM PC User Group.

In article <1992Aug31.071727.332@doc.bmd.trw.com> rthorstr@doc.bmd.trw.com writes:
>In article <1992Aug29.012028.9273@cs.UAlberta.CA>, ken@cs.UAlberta.CA (Huisman Kenneth M) writes:
>> Does anyone know when exactly oracle version 7 comes out for the PC???
>
>ORACLE has announced that version 7 WILL NOT be implemented on the PC.  

Which Oracle told you this (US or UK?) Oracle UK told me that the
plans were to make V7 available on ALL platforms that V6 is available on
at the moment. 

Mind you, this is the same firm that told me that V6 would never, ever be
available on the PC, and that I was completely insane for even thinking
about wanting it.

Come on you guys lets have a coherent story.

Anyone in Oracle prepared to make a statement?


-- 
Paul Snelling,	BoxField Systems Ltd
From: dbenson@us.oracle.com (Daniel Benson)
Newsgroups: comp.databases.oracle
Subject: Re: Old RPT and ORACLE Version 7
Date: 26 Aug 92 16:57:27 GMT
Organization: Oracle Corporation, Redwood Shores CA
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 <1992Aug25.155546.41@bmwf1f.bmwf.gv.at> hatzinger_m@bmwf1f.bmwf.gv.at writes:
>
>Hi,
>
>In a few months we are going to upgrade our oracle-database to version 7. 
>At the time we have a lot of good old RPT-Reports, still working under 
>oracle v6.
>
>But will ORACLE V7 also support old RPT-Reports ?
>
>
>thanks
>
>================================================================================
>                                                                          ^
> Federal Ministry of Science and Research                               B | M
><-------------------------------------------------------------------------+---->
> Computer Center                                                        W | F
>                                                                          |
> Klaus-Michael Hatzinger            mail: hatzinger_m@bmwf1f.bmwf.gv.at   |
> Bankgasse 1/209                   phone: 0043-222-53120/5188             |
> 1014 Vienna, Austria                fax: 0043-222-53120/5155             V
>================================================================================

RPT is supported with ORACLE7
From: tumidity@netlink.cts.com (Joel Garry)
Newsgroups: comp.databases.oracle
Subject: Re: READ ME---READ ME -- - READ ME -- READ ME
Date: 27 Aug 92 17:47:07 GMT
Organization: NetLink Online Communications, San Diego CA

sjs@netcom.com (Stephen Schow) writes:

> I would like to suggest to everyone that is reading this group that they
> try to forward their responses to questions back to the group instead of
> just replying to the individual users.
> 
> Whenever I ask a specific question, I always get 4-5 responses, which are
> very helpful to me, but not to anyone else who is reading the list and may
> also have interest in the topic.
> 
> I know there are many times when I see someone ask a question and I wish
> I could see the responses he got.
> 
> What do ya think?
> -- 
> ------------------------------------------------------------------
> 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
> ------------------------------------------------------------------

I think that the custom should be and is that people respond 
individually to the poster, then the poster gives a summary of
answers.  Then we don't have to wade through zillions of identical
responses of something we don't care about anyway.  So why am I 
posting this when a zillion people will do the same? <grin>

--                    
INTERNET:  tumidity@netlink.cts.com (Joel Garry)
UUCP:   ...!ryptyde!netlink!tumidity
NetLink Online Communications * Public Access in San Diego, CA (619) 453-1115
From: kml@cellar.org (John Galt)
Newsgroups: comp.databases.oracle
Subject: Re: how to compress database and move indexes to different tablespac
Date: 4 Sep 92 11:57:05 GMT
Organization: The Cellar BBS and public access system

suskind@bbs.mdcbbs.com writes:

> 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

The way to do this is to use the "indexfile" option of import.  It creates
the scripts for all tables (rem'd out) and indexes in the export file.
Edit the resulting file; it contains a few syntactical errors: remove the
quotes around the tablespace specifiers (and change them to "index" while
you're at it) and replace the "connect" lines with correct commands
(for running in SQL*Plus).  Then import, using Indexes=N, then run the 
indexfile script.

A final note - INDEX is a reserved word, may want to call the tablespace
INDEXES.

Reply to kml@cellar.org if you need any followup.

Kevin.


       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: hm@fna.no (Herold Myrland)
Subject: Accounting on ORACLE
Keywords: Accounting, ORACLE
Organization: FUNN-Narvik as (Norwegian R&D Network, Narvik)
Date: Wed, 2 Sep 1992 08:07:56 GMT

Hello all you ORACLE wizards out there!

We are a small computer company which serves a heterogenious computing environment
with UNIX and database services.  We would like to know how much *DATABASE LOAD*
each ORACLE user introduce on our server.

Is it possible to measure/log the number of "internal transactions" (select,
insert, delete, update, fetch, ...) or something?

In our case client applications (those applications which uses the ORACEL database)
will run on either the same server as the RDBMS, or on other machines (PC's, WS's,
other servers, ...).  Therefore it is our wish to find a way to measure the RDBMS
load of a ORACLE user, irrespective of from where the client application is run.

Best regards


Herold Myrland
Manager of FUNN-Narvik as (Norwegian R&D Network, Narvik)

e-mail: hm@fna.no
Newsgroups: comp.databases.oracle
From: gerette@cbnewsb.cb.att.com (marianne.g.pittorino)
Subject: Beginner's questions
Keywords: beginner
Organization: AT&T
Distribution: na
Date: Wed, 2 Sep 1992 15:17:00 GMT


Hi Oracle Users!
I am just beginning to learn about Oracle and I have some really basic
questions.  I have just started reading this newsgroup and the little I
have read impresses me greatly.  I would appreciate it if some kind person
would send me some answers (whether in e-mail or another posting is fine --
whatever you think is appropriate).

     1) Is it better to create a small database initially and add tablespaces
	to the database instead of creating a large database initially?

     2) Is it better to have lots of little tablespaces or fewer, larger
	tablespaces?

     3) Are temporary tables and indices easily created/dropped within an
	application using Pro*C?

     4) How do you completely destroy a database (i.e., no more datafiles,
	no more control files, no more anything; I want it to seem as if the
	database NEVER existed!)?  Could I just remove all files associated
	with the database or is there some internal table that would be really
	upset if I did?

     5) I created a tablespace, then dropped it (including contents).  Why
	isn't the datafile removed and why does the row for the tablespace
	(status = INVALID) still exist in dba_tablespaces?

     6) Is there any easy way to rename tables (aside from selecting into the
	new table and dropping the old table)? Likewise, is there any easy way
	to rename columns?  The RDBMS I use now has simple rename commands:
		rename (old_table_name, new_table_name)
		rename_col (table, old_column_name, new_column_name)
	Does anything like this exist in Oracle?

     7) How is fragmentation monitored and how is it repaired?


If an FAQ file exists for this group, please tell me how I can get a copy.  I
don't want to rehash the same old questions over and over.

Thank you,
Marianne G. Pittorino
Newsgroups: comp.databases.oracle
From: louk@research.teleride.on.ca (Lou Kates)
Subject: backward scrolling
Organization: Teleride Sage Ltd., (Waterloo)
Date: Wed, 2 Sep 1992 10:24:34 GMT

We were evaluating Oracle recently (based only on the manual).  One thing
we could not find was a way to get the previous record from the Oracle
Call Interface to C.  However, a recent article in PC Magazine (September
15 issue) mentions that Oracle does have backward scrolling.

Could someone confirm whether we just missed it or is the article wrong?

Lou Kates, louk@research.teleride.on.ca
From: la@datani.dk
Newsgroups: comp.databases.oracle
Subject: Object-Referencing Strategies
Date: 3 Sep 92 15:26:35 GMT
Organization: Datani A/S, Copenhagen, Denmark

Hello Oracle-folks.

Anybody have strategies for using Object-Referencing in
Application-Development using SQLFORMS 3.0.

We have made a datadictionary, so it will be easy to update or distribute 
databases, but how to make it easy to maintain applications with many forms, 
facilities and relations.

Object-Referencing is a way (as far as I can see) to ensure that changes 
will be reflected in the whole system, and as so just what I want.  

But the manual SQLFORMS (Designers Ref.) is very limited with information
around the use.

So I want to know:

	1. When is it a good idea ?. Advantages.
		- library forms???
		- for blocks 
		- for fields 
		- for triggers, procedures. 

	2.  Drawbacks.

	3.  Experiences.




-------------------
Lone Aalekjaer               E-mail:         la@datani.dk
Datani A/S                   
Copenhagen, Denmark
From: ian@tethys.SLAC.Stanford.EDU (Ian A. MacGregor)
Newsgroups: comp.databases.oracle
Subject: Re: Hash clustering vs Indexing in ORACLE7
Date: 1 Sep 92 15:15:19 GMT

In article <z9hn27.tcox@netcom.com>, tcox@netcom.com (Thomas Cox) writes:
|> mpd@hermes.dlogics.com writes:
|> >Anybody used hash clustering in place of indexing?
|> >Am considering it for a new app, and am wading through zillions of
|> >pros and cons.
|> 
|> >Thanks in advance...
|> 
|> Why "in place of" -- I was under the impression you can do both.  Though
|> I have no idea what trade-offs _that_ entails...
|> 
|> 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...

I believe hashing is only available for clusters and not for individual tables.
Hashing is faster for queries with predicates that do not include range scans.
Range scans are more efficiently handled by B-Trees.  Another problem is that
hash functions do not guarnatee uniqueness; thus they are unsuitable for use as
peimary keys in a table.   Oracle does allow you to have both a hash and an
index on your cluster key.  It will  use the hash for "=" queries and the 
B-Tree for range scans.  There have been rumors about Oracle allowing hashing
of individual table keys in the future, but I have heard no official statement
from them.

                          
                          Ian MacGregor
                          Stanford Linear Accelerator Center
                          IAN@SLAC.STANFORD.EDU
                          (415) 926-3528
Newsgroups: comp.databases.oracle
From: tcox@netcom.com (Thomas Cox)
Subject: Re: Customization of SQL*Forms.
Date: Thu, 27 Aug 92 04:08:31 GMT
Organization: Netcom - Online Communication Services (408 241-9760 guest)
Keywords: SQL*Forms, Oracle CASE

	First, an obligatory disclaimer:  I get my salary from Oracle
	(so I'm not impartial) but I'm no spokesman (so my words may
	not mean anything).  With that in mind...

sinha@watson.bms.com (Anil Sinha) writes:
>	Many times there is a need to customize SQL*Forms forms generated by 
>the Oracle CASE tools. 

	This is normal -- I get maybe 80% of my form logic from CASE,
	and do the rest by hand.  I gather that that's normal.  

>Many sites have written awk scripts ( in unix o/s) or 
>other utilities to modify the ".inp" file. These utilities help to automate 
>the customization procedure. 

	Ahah!  The reason you're doing that is because... you modify
	your form (as above), and then for some reason you change some
	aspect of your CASE logical model and thus need to re-gen the
	form.  And in CASE Generator v1 (for Forms) the re-gen stomps
	all over your customization work.  Ouch.

	But using 'awk' should be unneccessary.  Because... CASE
	Generator v2 for Forms no longer stomps on your customization
	work.  It lets you re-generate nondestructively.  

>Now the dreaded word going around is that Oracle
>may get rid of .inp files for SQL*Forms 4.0. (????)

	I have a hard time believing that!

	I *have* heard that "fields" are going away, but .inp files?
	Can anybody confirm this .inp file rumor?  

	(Yeah, "fields" are being replaced with "items", I think, as
	in "radio button item", "checkbox item", etc.  Something like
	that.) 

>Anil Sinha
>internet:sinha@watson.bms.com  

	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.