HDTenEightyP/NetNews huggingface dataset:
From: gheim@eng.auburn.edu (Greg Heim)
Subject: Re: Any UNIFY users?
Organization: Alabama Department of Tourism (NOT!)
Date: Fri, 11 Sep 1992 18:06:59 GMT

I (Greg Heim) wrote:
=> We just started using ACCELL/SQL 1.3 on our development machine.  It
=> turns out you can only run one manager at a time with 1.3 because of a
=> non-unique error file (called "/tmp/err") created.  So much for high
=> speed development work!  To top it off you still have to manually
=> remove the file when done with the manager in order to start one up on
=> another database.  Our techie there is supposed to call and tell us how
=> to run everything from the command line to get around the bug ... gee
=> thanks dude.
=> 
=> Anyone else had this problem and/or know a workaround?

Oh, yeah, I forgot to mention...We tried patching the [C]AMGR binaries
(and finally all the others too) everywhere it had "err" in it.  We
figured we would just rename the error file and run several different 
versions.  But it was to no avail. 

Greg
Newsgroups: comp.databases
From: blackman@math.tau.ac.il (Blackman Uri)
Subject: Re: Yet Another Simple (?) Question on Paradox
Organization: School of Math & CS - Tel Aviv University , Tel Aviv , ISRAEL.
X-Newsreader: Tin 1.1 PL5
Distribution: na
Date: Tue, 8 Sep 1992 11:32:29 GMT

Using CoEdit instead of Edit won't allow you to open a blank record.

--
Uri Blackman
blackman@Math.Tau.Ac.IL
blackman@Taurus.BITNET
Newsgroups: comp.databases,bit.listserv.dbase-l
From: durai@ORTTA (Appadurai V.)
Subject: Re: Clipper: Backup/Restore routines for BIG files...
Organization: U of Mn
Date: Wed, 9 Sep 1992 17:13:43 GMT

What about zipping those files ?
Newsgroups: comp.databases,comp.databases.theory,comp.databases.oracle
From: ramirez@IASTATE.EDU (Richard G Ramirez)
Subject: Re: Objects and Oracle?
Reply-To: ramirez@IASTATE.EDU (Richard G Ramirez)
Organization: Iowa State University
Date: Tue, 8 Sep 1992 15:50:35 GMT

About Oracle and Windows.  I have been an Oracle user
since Version 4. I tried to run it from Windows and
finally gave up.  As you said the documentation and
their help is vague at least.  Worse, when I called 
them their attitude was that Microsoft should change
their memory manager to fit Oracle's.

I moved to Quadbase/SQL for Windows and I have used
it from Visual Basic.  I am in the process of
writing Actor code to interface with Quadbase.

As far as I can tell, Quadbase is a robust package
that should do what you need.

We also plan to buy Toolbook soon. I will be glad
to hear of any Toolbook-relational interfaces.
From: arthur@otto.bf.rmit.oz.au (Arthur Adamopoulos)
Newsgroups: comp.databases
Subject: Re: data dictionaries
Summary: PICK dictionaries
Date: 15 Sep 92 15:40:12 GMT
Organization: RMIT Computer Centre
NNTP-Posting-Host: otto.bf.rmit.oz.au

In article <BuM69C.ny@cs.vu.nl>, jfmburg@cs.vu.nl (JFM Burg) writes:
> A few weeks ago their was a discussion going on about a data-dictionary
> standard. Somebody replied the question "What should a DD contain anyway".

  I mostly work with PICK like systems.
  Pick has no real data definition language, all the DDL stuff is done
  inside the PICK dictionaries.

  These can define:
    Usual Field Number, Column Heading, Length and Type.
    Output format - ie. all formats for dates, money values, times etc.
    Input checks  - patterns, lengths, ranges etc etc
    Correlatives  - Calculation fields.
                  - This is the power of pick.  You can define almost
                    any calculation on fields in the current file and get
                    data from other files(tables).
    Program Code  - Some versions of pick allow full code in the dicts
                    (for calculations, input checks etc).

  In my limited use of Oracle I have seen some similar features but then
  I haven't fully explored it yet.....

-----------------------------------------------------------------------
Arthur Adamopoulos         ACSnet:  arthur@otto.bf.rmit.oz
Business Info Systems    Internet:  arthur@rmit.edu.au
RMIT
411 Swanston st.              Tel:  +61 03 660 3501
Melbourne        3000        ICBM:  37 48 S / 147 58 E
-----------------------------------------------------------------------
From: aaj@cmutual.com.au (Tony Jambu)
Newsgroups: comp.databases.oracle
Subject: Re: how to compress database and move indexes to different tablespace
Date: 8 Sep 92 02:31:45 GMT
Organization: Colonial Mutual Life Australia
From: kpalm@athena.qualcomm.com (Kent Palm)
Newsgroups: comp.databases.oracle
Subject: Re: Import into a new table space is BROKEN!
Date: 15 Sep 92 16:40:11 GMT
Organization: Qualcomm, Inc., San Diego, CA

I've wrestled with this one before, too.  After a while, I had success.

Not that this matters, but before I created my original export for
migration, I revoked global resource and all specific resource
privileges for that user.  This was a precaution in case import carried over
any grants from the export (e.g., GRANT RESOURCE).

Before importing, I did the following:  1) Altered user's default tablespace
to point to the one I wanted to import into, 2) Granted resource on that
tablespace for that user, 3) revoked resource on all other tablespaces
from that user, 4) revoked global resource from that user.

I believe an interactive import always tried to put it in the wrong tablespace.
It wasn't until I used the command line version that I experienced success.
It may have been the FROMUSER or TOUSER qualifiers that did the trick
(i.e., got the tables into the right tablespace).  See if that works.
Newsgroups: comp.databases.oracle
From: mkay@sequent.com (Mary Kay Petersen)
Subject: Re: Doubt regarding granting OPS$ user ids.......
Organization: Sequent Computer Systems, Inc.
Distribution: na
Date: Fri, 4 Sep 92 21:01:21 GMT

nakkala@cs.tamu.edu (Venkatesh Nakkala) writes:


>   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 


Check to make sure the oracle binary is owned by 'oracle' and
set uid (chmod 4751).  Otherwise, no one but the owner, 'oracle',
can access the database.
---
  /_ _   /		sequent computer system, inc.	+-----+
 / / /  /__/ __		15450 sw koll parkway		|   # |
/ / /  / \__(_/_/_/	beaverton, or  97006-6063	|     |
mary kay petersen/	mkay@sequent.com 		+-----+
(503)578-5817 __/
From: pvelasq@uswnvg.com (Patrica Velasquez)
Newsgroups: comp.databases.oracle
Subject: CASE*Generator -- Call for Product References
Date: 8 Sep 92 23:22:25 GMT
Organization: U S WEST NewVector Group, Inc.
X-Newsreader: Tin 1.1 PL5

I am in the process of gathering product references for the CASE*Generator.  We
have the product on location and it will soon be installed on a Sequent PTX 1.3,
UNIX.  

My objectives are as follows:
        *  To see if the tool can increase productivity with automated support
        across the system life cycle, including detailed design and automated
        generation of code;

        *  To see if the tool can store specifications in one location, in order
        to support analysis, development and maintenance activities for 
        SQL*Forms based systems (PRO*C if it does it?);

        *  To support a consistent, repeatable process for developing and 
        maintaining applications; and

        *  To communicate to the technical staff the benefits of using the 
        product.

In addition , to ensure that there is an understanding of the product's 
capabilities, the internal support requirements and critical implementation 
issues.

COMMENTS ANYONE:

I am also including in my documentations as many as I can of PRODUCT REFERENCES.
I tried calling ORACLE for some but they did not want to give anyones name out?
If you have the time please fill out the appropriate information below.  

Thank you!  Patty
*******************************************************************************
PRODUCT REFERENCES FORM

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Name:
Title:

Address:
City:
State:
Zip:

Phone:
Can I call you? (Y/N):

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Products Used:



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
TOPIC                                    RATING [ P=POOR A=ADEQUATE G=GOOD ]
===============================================================================
General Effectiveness:
Ease of Use:
Completeness:
Level of Documentation / Training:
System Accuracy:
Reliability:
Vendor Responsiveness:
Product Installation:
Product Operation (Over all):

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Summary:
(Identify concerns, limitations, restrictions and recommendations.)



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Thank you. Patty



Newsgroups: comp.databases.oracle
From: howard@monitor.com (Howard Brenner)
Subject: Data loss
Reply-To: howard@monitor.com (Howard Brenner)
Organization: Monitor Company / IE
Date: Tue, 8 Sep 1992 22:12:22 GMT

As a preface I am working on a NeXT machine with version 6 of oracle and  
2.2 of the OS.

Has anyone ever encountered the following problem?  I had left for the  
weekend and when I returned I had noticed that the data in my tables had  
been changed to values I had in the system about a week before.  When I  
questioned my database administrator as to whether or not he had restored  
the database from a backup he had said he had not.  All he he did was  
change the IP address of the NetInfo server and added a control file to  
the init.ora, shutdown and restart the database.

Before contacting technical support I had tried a database recover (it  
said it the database was not corrupted) and an export and import of the  
tables in question.  When this did not cure the problem I contacted the  
oracle tech support and the supporter said to restore the database to a  
previous version (the version I had when I left on friday) and recover the  
database.

Needless to say this answer does not quiet the fear that this might happen  
again.

Thanks for the help!
   Howard
From: cooper@seismo.CSS.GOV (Dale Cooper)
Newsgroups: comp.databases.oracle
Subject: ATTN: Solbourne/Sequent Server Info Request
Date: 15 Sep 92 18:20:51 GMT


Fellow Oracle (Ab)users:

We are considering acquiring a new database server and would like to hear 
from those of you running production Oracle on Solbourne (5E/70X) and Sequent 
(S2000/250) servers.  If you could spare a few minutes and describe some of 
your feelings with regard to performance, value, likes, dislikes...I would be 
very happy to entertain them.  Please email your responses.  I would be more 
than happy to exchange information with the respondees to this request...

PS.  Vendors need not reply.

Thanks in advance...

Dale Cooper, DBA				"No sir, I don't like it."
Center for Seismic Studies			(703)276-7900
Arlington, VA					cooper@seismo.css.gov
Newsgroups: comp.databases.oracle
From: hm@odin.fna.no (Herold Myrland)
Subject: Transaction accounting for Oracle
Keywords: system accounting, client/server
Organization: FUNN-Narvik as (Norwegian R&D Network, Narvik)
Date: Tue, 15 Sep 1992 06:42:41 GMT

Are there any who know how to map the machine resources consumed
by the Oracle processes (different deamons) onto the Oracle user
which initiated the command?

Whenever an application (SQL*Forms, SQL*Plus, others...) connects
to a DB this is done in the name of a certain Oracle user. However
the Unix system resources consumed by the DB deamons are logged
onto Unix user 'root' or 'ora' (depending on which users that runs
them).

I am looking for a possibility to log the Oracle deamon activities
caused by each Oracle users's transactions (SELECT, FETCH, UPDATE,
INSERT, DELETE, ...) .

Does anybody out there know of such a beastie.

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

E-mail: hm@fna.no

Newsgroups: comp.databases.oracle
From: bill@chaos.cs.umn.edu ()
Subject: Re: Approach for Windows - SQL*Net
Organization: University of Minnesota
Date: Tue, 8 Sep 1992 19:26:00 GMT

In <1992Aug29.000555.26641@csus.edu> 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?            

does your init.ora have the line , oh whats that line ?? i ('m trying to
recall from memory) task = 'sqlnet' something. darn i can't remember it.
but it should be in the book (sqlnet) this is for setting the default as to
some place other than the local machine. otherwise
use the startup parameters:

see the sqlplus users guide ch 23 (the old book), or the sql lang ref 
(new book) pg 5-50, 6-20,6-21; or 2-6. see also the sqlnet (tcpip) 2-4
sqlplus scott/tiger@mach_name:sid

bill 'my brain is so full my head is empty' pociengel
--
bill@chaos.cs.umn.edu
Newsgroups: comp.databases.oracle,comp.edu,misc.jobs.contract
From: edc@openage.openage.com (Ed Cooley)
Subject: NEED ORACLE TRAINER, D.C. AREA
Organization: Open Age, Inc.
Date: Mon, 14 Sep 1992 20:01:47 GMT

OPEN AGE, INC. of the Washington, D.C. region has a client who is in need
of an Oracle trainer.  The opportunity is immediate, and the job will
consist of two 5-day classes at the customer site instructing the client's
staff in the use of the Oracle RDBMS.  Each class will have approximately
12 students, and all equipment and facilities will be customer-furnished.
It is essential to the customer that potential instructors have some sort 
of "canned" curriculum, since their willingness to pay for quality
education is expected to deliver a well structured class.

If you are interested, please contact Ed Cooley or Paul Fischer at our
corporate offices (301) 948-6422 or (800) 220-OPEN.
Newsgroups: comp.databases.oracle
From: drt@brolga.cc.uq.oz.au (David Taylor)
Subject: Import into a new table space is BROKEN!
Organization: Prentice Centre, University of Queensland
Date: Tue, 15 Sep 1992 07:33:22 GMT


I am having a problem with some undocumented features of import.

The export file came from version 6somethingorother on a VAX. It was
a straight user export.
I want to import the tables under a different username on a DOS box
also running version 6somethingorother.

I created a special tablespace for the data (~200M) on a new disk.
I created a user and granted resource access to the table space.
I made the new table space the default for this user.

When I run import it appears to work, but it creates
the tables in the SYSTEM table space, and falls over eventually
because there isn't enough space there. The manual clearly states
that it should load into the default table space for this user.
It even gives an example of how to use this feature to transfer
stuff between table spaces.

As a test I created a table from sqlplus and it went in the new
tablespace just fine, by default.

OK. I'll fix it. Lets revoke all access to the system table space for
this user and try again. Didn't work. Fills the system table space again.

Tricky little feature that one. Lets try creating a table in the
system table space for this user and fill it with junk. Works fine.
Hmmm. Drop that table. Grant 1k of quota space in system to the user.
Create table. Fill it with 3k of stuff. Commit. Interesting...

The dba_ts_quotas view shows some strange numbers. The manual says NULL
means unlimited quota but we actually have -1024 bytes. Doesn't seem
to matter anyway, 'cause if we grant 0 bytes it still lets us have
as much as we want.

Oh well, so quotas are meaningless. Lets get back to the import problem.

Run import again _interactively_ as the new user, and load the tables 
from the old user. Again, fills the system table space.

Run it using _command line_ parameters, as the new user, and load the
tables from the old user:
ERROR: must be dba to import objects to another user's account.
Huh?!?? I just did it _interactively_ and I wasn't dba.

Run it as dba. Again fills the system table space.

My observations:
I immediatly suspect that I set up the table space/username incorrectly,
but from sqlplus everything works as it should.

So maybe import has some features. SOmeone must have found them by now.
Is there a way around it?

The strange ignorance of quotas is disturbing. If the work around
involves giving the user a 0 quota on SYSTEM then I'm stuck, because
it appears to be meaningless.

Can anyone shed some light?
From: jnw@cs.strath.ac.uk (John Wilson)
Newsgroups: comp.databases.oracle
Subject: Re: Name of trace file currently being written.
Date: 10 Sep 92 11:34:27 GMT
Organization: Comp. Sci. Dept., Strathclyde Univ., Glasgow, Scotland.

In article <1992Sep8.043503.6466@cmutual.com.au> aaj@cmutual.com.au (Tony Jambu) writes:
>
> stuff deleted
>
>It is not possible to carry this out on UNIX.  I hope someone out there can
>tell me otherwise.
>
I too have experienced problems with identifying trace files. The
best solution I could find was to use the monitor to discover the
Oracle process number and use that to narrow down the possibilities.
It seems to me that it should be possible to discover the Oracle
process number more directly but I could not find out how to do that.
From: jean@seismo.CSS.GOV (Jean Anderson)
Newsgroups: comp.databases.oracle
Subject: ORACLE license policies
Keywords: client/server, named users
Date: 9 Sep 92 22:53:07 GMT
Organization: SAIC Open Systems Division


Does everybody understand Oracle client/server and named user licensing
policies? 

So far they have struck me as very inconsistent. I get different stories 
depending on who I talk to and depending on the platform, operating system,
and network protocol.

If you are interested in comparing notes, answer the questions below. I'll
summarize all responses back to the net (and will remove names/affiliations
for anybody who wishes to remain anonymous).

1) Did you have difficulty understanding Oracle's client/server policy?

2) Did you have difficulty understanding Oracle's named user policy?

3) Did you request a copy of the published policy? If so,
      - Which policy did you request? 
      - Did you have any trouble obtaining it?
      - How long did it take to receive it?

4) Have you purchased a client/server license in the last year? If so,
      - What platform/operating system was it for?
      - What was the network protocol?
      - Did you additionally license each client separately or were clients 
        included in the server license?

5) Have you encountered any negative sales tactics such as threats of license
   violations regarding either the client/server or named user policy?

My thanks to any who take the time to respond.  Again, please send responses
directly to me. I will summarize in a week or two.

  -jean

+-----------------------------------------------------------------------+
| Jean Anderson, DBA                       email:  jean@seismo.css.gov  |
| SAIC Open Systems Division, MS A2-F         or:  jean@esosun.css.gov  |
| 10210 Campus Point Drive                 phone:  (619)458-2727        |
| San Diego, CA  92121                       fax:  (619)458-4993        |
+-----------------------------------------------------------------------+
|        execute disclaimer(opinion => 'mine');                         |
+-----------------------------------------------------------------------+
From: brooksj@cpva.saic.com (James Brooks)
Newsgroups: comp.databases.oracle
Subject: help ... SQL*Connect for DB2
Date: 6 Sep 92 10:09:31 PST
Organization: Science Applications Int'l Corp./San Diego

I would greatly appreciate any info on the use of the SQL* Connect for DB2
product. Does it really support read/write capabilities ?? What is the
performance like ??? 

Thanks in advance 


-- 
Jim Brooks, DBA				email: CPMAIL@BROOKSJ
SAIC EUTG Transportation Systems	phone: (619) 546-6462
10260 Campus Point Drive MS-G2		  fax: (619) 458-2621
San Diego, CA 92121
Xref: sparky comp.databases.oracle:1554 comp.sys.sequent:545 comp.sys.hp:10274 comp.sys.ncr:429 comp.sys.sun.apps:1894
From: aaj@cmutual.com.au (Tony Jambu)
Newsgroups: comp.databases.oracle,comp.database,comp.sys.sequent,comp.sy,s.pyramid,comp.sys.hp,comp.sys.ncr,comp.sys.sun.apps
Subject: Life Insurance Package
Date: 10 Sep 92 23:40:21 GMT
Organization: Colonial Mutual Life Australia

Dear Netters and Vendors,

I am posting this article on behalf of a fellow staff who does not have direct
access to the Net.  

If you have any information about the following package or even ANY Life
Insurance package, please reply directly to DMika@cmutual.com.au.


======================== START OF MESSAGE =====================================

I am interested to hear from any sites using a Life Insurance Administration
package called "FDP/CLAS", I believe it is an Oracle package and developed
by a company called Financial Data Planning based in Miami, FL.
I would like to know:
        - what hardware is it running on
        - how long have you been using it
        - what types of products (eg traditional life, etc)
        - number of policies being administered (order of magnitude)
        
If you are unable to answer any of these questions but know of someone else, I
would appreciate if you could forward the post to them.

Debra Mika
Colonial mutual

======================== END OF MESSAGE =====================================
-- 
-----------------------------------------------------------------------------
 _____       ________ / ____ |Tony Jambu, Database Administrator
  /_  __       /_ __ /       |Colonial Mutual Life Australia. (ACN 004021809)
 /(_)/ ((_/ \_/(///(/_)/_(   |EMAIL:  TJambu@cmutual.com.au
Newsgroups: comp.databases.oracle