HDTenEightyP/NetNews huggingface dataset:
From: DTodd@massey.ac.nz (D.M. Todd)
Subject: Re: Revelation paint -- Define Page
Keywords: Revelation Paint
Organization: Massey University, Palmerston North, New Zealand
X-Reader: NETNEWS/PC Version 2c
Date: Thu, 28 Jan 93 23:19:26 GMT

Scott,

The options generally work very well, though it's a nuisance to have
to remove labels from the select to define page (I did realize you
only have to "de-select them" not move them on the screen!).  Also is
there a way to tell where you page definitions are within paint,
rather than having to run the screen?

David
Newsgroups: comp.databases.oracle
From: aaj@cmutual.com.au (Tony Jambu)
Subject: Re: Error reading database files
Organization: Colonial Mutual Group
Date: Tue, 26 Jan 1993 01:19:05 GMT



To be able to help you, you need to supply _MUCH_ more information like

1.  What version of the DBMS are you using?
2.  Was it a hot or cold backup?
3.  Do you have archive logging?
4.  Do you have an export and was it carried out in DBA mode?
5.  Which file failed the verification check?
6.  Did you lose ALL the control files?
7.  Did you restore an OLD Control file?
8.  Has the database structure changed since you last carried out the backup?
9.  How long ago did you last carried out the backup?

and a whole lot more information if you are to get correct answers.


-- 
 _____       ________ / ____ |Tony Jambu, Database Administrator
  /_  __       /_ __ /       |Colonial Mutual Invest Mgmt Aust (ACN 004021809)
 /(_)/ ((_/ \_/(///(/_)/_(   |EMAIL:  TJambu@cmutual.com.au
 \_______/                   |PHONE:  +61-3-6418448       FAX:  +61-3-6076198
Newsgroups: comp.databases.oracle
Subject: Re: Windows and Oracle access.
From: tumidity@netlink.cts.com (Joel Garry)
Date: Fri, 22 Jan 93 17:02:43 PST
Organization: NetLink Online Communications, San Diego CA

kmajkut@netcom.com (Keith Majkut) writes:
> >
> >I just saw a demo of Reportwriter 2.0.  It was really cool.  I think they 
> >said it should be out by May.  The neat thing is, you can use the 
> >executables on any machine.  Apparantly they use some sort of virtual 
> >machine.  I can't imagine that it would be the most efficient on all 
> >machines, but that's portability for you.  It's like a combination of 
> >.inp and .frm files.  
> 
> I'm not sure if you meant to say 'executable' above. I can say for sure that
> none of the Oracle executables is designed in that fashion. What you meant to
> say was that the files produced by SRW are portable across platforms. You
> can simply transfer a file between UNIX/PC/MAC and it will load/run without
> any modification. Also, you could save it to the RDBMS and retrieve it from
> another version of SRW on another platform(I have done both of these myself
> so I know it works).
> SRW will have 3 file formats(.rdf-binary format w/source, .rex-ascii format
> w/source and .rep-binary format w/runtime only).

Sorry!  I was foaming at the mouth excited about it, and got sloppy!  Do 
you run it as a virtual machine in the executable, or are you guys 
actually rewriting the executable for every machine?

--                    
INTERNET:  tumidity@netlink.cts.com (Joel Garry)
UUCP:   ...!ryptyde!netlink!tumidity
NetLink Online Communications * Public Access in San Diego, CA (619) 453-1115
From: jsc@sequent.com (J. Scott Carr)
Newsgroups: comp.databases.oracle
Subject: Re: Is there a SYBASE newsgroup ?
Date: 27 Jan 93 16:24:34 GMT
Article-I.D.: sequent.1993Jan27.162434.1655
Organization: Sequent Computer Systems, Inc.

umgeary0@ccu.umanitoba.ca writes:

Yep - comp.databases.sybase.


>I'm not sure where else to ask this questions (no flames please),
>but .. Is there a SYBASE newsgroup out there similiar to this
>group? If not how do I go about starting such a group?
>Please e-mail.
>Thanks
>Peter

-- jsc
----------
J. Scott Carr                    voice: (503) 578-3495
Technical Marketing              email: jsc@sequent.com  <or>
Sequent Computer Systems                ...!uunet!sequent!jsc
From: graeme@pyra.co.uk (Graeme Sargent)
Newsgroups: comp.databases.oracle
Subject: Re: Spool & Trailing Blanks
Date: 26 Jan 93 11:21:59 GMT
Reply-To: graeme@pyramid.com (Graeme Sargent)
Organization: Pyramid Technology Ltd.

In <1993Jan25.133239.1@ntc02.tele.nokia.fi> kuismin@ntc02.tele.nokia.fi writes:

>    This is what I get now:

>        line1 line1                      <LF>
>        line2 line2 line2 line2          <LF>
>        line3 line3 line3                <LF>

>    This is what I want to have:

>        line1 line1<CR><LF>
>        line2 line2 line2 line2<CR><LF>
>        line3 line3 line3<CR><LF>

It's easy to do with UNIX:

sed -e "s/ *$//" file1 > file2

will replace all trailing blanks in "file1" with a single <CR> (^M)
in "file2".

NB. to embed the <CR> in your sed command you type <CTRL>-V,<CTRL>-M

graeme
--
Disclaimer:	The author's opinions are his own, and not necessarily
		those of Pyramid Technology Ltd. or Pyramid Technology Inc.
--------------------------------------------------------------------------------
      -m------- Graeme Sargent                 Voice: +44 (0)252 373035
    ---mmm----- Senior Database Consultant     Fax  : +44 (0)252 373135
  -----mmmmm--- Pyramid Technology Ltd.        Telex: Tell who???
-------mmmmmmm- Farnborough, Hants  GU14 7PL   Email: graeme@pyra.co.uk
--------------------------------------------------------------------------------
    We have the technology.  The tricky bit is learning how to use it.
-- 
graeme
--
Disclaimer:	The author's opinions are his own, and not necessarily
		those of Pyramid Technology Ltd. or Pyramid Technology Inc.
From: alanb@vnet.ibm.com (Alan Beal)
Date: Fri, 22 Jan 93 09:15:26 EST
Newsgroups: comp.databases.oracle
Subject: checking for full tablespaces
Organization: Federal Systems Company (IBM)

Is there a simple query one may run to see if a tablespace is
full or almost full?  I am using Oracle V6 on AIX 3.2.

Alan Beal         alanb@owgvm0.vnet.ibm.com
                  (607)751-2026
From: epeas@abds7.aberdeen.chevron.com (John Peach)
Newsgroups: comp.databases.oracle
Subject: Re: Oracle CASE training question
Keywords: CASE training
Date: 21 Jan 93 08:36:56 GMT
Reply-To: epeas@aberdeen.chevron.com
Organization: Chevron (UK) Ltd.
Disclaimer: The opinions expressed are mine; _not_ those of        
            the company I work for.

In article <1993Jan20.170412.21433@Arco.COM>, kmelcher@rafael.Arco.COM (Kenneth Melcher) writes:
|> We are considering sending some DBA's to training for Oracle CASE.  I have 
|> seen the current Oracle training schedule,  which lists several CASE classes.
|> I am wondering whether it is really necessary to have taken any of the CASE methods 
|> courses listed as prerequisites before taking "Implement Systems Analysis and Design 
|> Using CASE Tools",  which appears to be the first course in the series in which you
|> actually lay your hands on the CASE tools.
|> 
|> Has anyone out there been through the CASE training series,  and if so,  can you offer some advice on the bare minimum training required to use the tools.
|> 

In common with any other CASE tool, you would be wasting your (and your
company's) time and money by attempting to learn about the tools without
first knowing the methodology.

|> Thanks in advance,
|> 
|> KM

-- 
                               John Peach
                           Chevron (UK) Ltd.
   Ninian House, Crawpeel Road, Altens, Aberdeen, AB1 4LG, Scotland.
   Internet: epeas@aberdeen.chevron.com       Phone: +44 224 242637
Newsgroups: comp.databases.oracle
From: v045100@otis1.stortek.com (Jennifer Farnham)
Subject: Re: ORACLE/SAS Interface
Reply-To: v045100@otis1.UUCP (Jennifer Farnham)
Organization: Storage Technology Corp.
Distribution: usa
Date: Tue, 26 Jan 1993 19:20:19 GMT


StorageTek in Boulder, Colorado uses SAS
and Oracle together. I believe they
use SAS/CONNECT within the SAS program
and it can read from our Oracle Tables,
etc. They currently use this on DEC VAX/
VMS platform, but we are porting all this
to Unix in the upcoming year.  If you need
someone's name, please contact thru email
to Michael Renella at:

v042731@query.stortek.com

and I'd appreciate it , if you leave my
name out of it, in case he gets a lot
of mail, he won't come back and get me! :-)

Michael uses SAS and Oracle.

Newsgroups: comp.databases.oracle
From: sethg@dcatlas.dot.gov (Seth Grimes)
Subject: Re: ORACLE/SAS Interface
Organization: U.S Dept. of Transportation
Date: Mon, 25 Jan 1993 12:59:59 GMT

Mark Esswein <messwein@nimbus.worldbank.org> writes:

>Does anyone know of a product ( other than OS**T/ST**O, ) for moving
>files between SAS
>and Oracle?  We have users who do a lot of statistical analysis in SAS
>using data that 
>we keep in an Oracle database.  Candidate products must easily shift data
>both ways.

Well yes, SAS/Access from SAS.  Call your sales rep for info.

			Seth, grimes@oecd.fr 
Newsgroups: comp.databases.oracle
From: mgic <mgic@mixcom.mixcom.com>
Subject: SQL forms key mapping and Exceed (X for DOS)
Organization: Milwaukee Internet Xchange BBS, Milwaukee, WI U.S.A.
Distribution: usa
Date: Wed, 27 Jan 1993 20:37:37 GMT


We are trying to evaluate SQL Forms on a Sun using a networked
PC running Vista Exceed's X Window software to access the Sun.  
We cannot find a key mapping that works with Vista Exceed.
In other words, SQL Forms will not run under Vista Exceed
because the keys don't work right.

Anyone else using this combination? Any ideas?
Thank you.

Glen
--
Newsgroups: comp.databases.oracle
Subject: Oracle-Macintosh project in education: advice needed. 
From: Robert L. Blakeley <blakeley@biosci.uq.oz.au>
Date: 24 Jan 93 14:23:23 AEST
Distribution: world
Organization: Department of Biochemistry, Uni of Queensland
X-UserAgent: Nuntius v1.1.1d12X-XXMessage-ID: <A788570A9E04742A@blakeley.biosci.uq.oz.au>X-XXDate: Sun, 24 Jan 93 14:24:10 GMTLines: 34

I am planning a Computer Managed Learning (CML) facility to operate from
a Sun ELC server to be delivered via ethernet to networked Macintosh LC
II computers.  The CML system will deliver an individualized printed quiz
to each student upon application every two weeks (say), and each students
would then have two or three days to key in his or her response.  The CML
system would score the response and respond appropriately, and it would
keep a record of individual student interaction with the system.  

The choice of printed quiz rather than interactive use of the computer is
partly economic and partly educational.  Economic because we can run a
lot of students through a limited number of machines at the average rate
of some 15 minutes per student per quiz.  Educational because the whole
exercise is designed to encourage students to do regular work, and to
give the student immediate feedback on his results.  

The CML system would initially use text and simple graphics, but should
be capable of eventual extension to deliver pictures in 16-bit color as
well as digital video (e.g., Apple's Quicktime).  Authoring should use
simple desktop publishing techniques.  I am not aware of any extant CML
systems with these specifications, and hence we are designing our own.

It is proposed to build this system around Oracle, but I am a biochemist
and I need advice from people who have experience with related systems. 
Is Oracle as good as any other data base for this job?  Is Oracle-Card
for the Macintosh a suitable front end?  Are there alternative databases
and front ends that I should consider?  Does anybody have such a system
already going, and, if so, are you interested in collaborating, or in
selling your experience?
.
Robert L. Blakeley
Department of Biochemistry		TEL 61-7 365 4612
University of Queensland		FAX 61-7 365 4699
Brisbane, Queensland 4072
AUSTRALIA
Newsgroups: comp.databases.oracle
From: umgeary0@ccu.umanitoba.ca ()
Subject: Sybase Newsgroup
Organization: University of Manitoba, Winnipeg, Canada
Date: Mon, 25 Jan 1993 05:47:35 GMT


Thanks to all those who responded (including those who could not
resist taking some shots). There is no comp.databases.sybase in my
newsrc. Will investigate.
Peter

Newsgroups: comp.databases.oracle
From: nstern@cass.ma02.bull.com (Neil Stern)
Subject: Re: "Oracle News" The Indepent Newspaper ... Available???
Organization: Bull World Wide Information Systems Inc.
Distribution: usa
Date: Wed, 27 Jan 1993 18:49:56 GMT

hyu@eng.umd.edu (Henry K. Yu) writes:

>A collague showed me a copy of Oracle News "The independent Newspaper
>for ORACLE Users"  Vol.1, No.3, December, 1990.

>Does anyone know if this publication still exist?  And if so, how to 
>subscribe?

>Thanks,
>hyu

Hi,

I subscribed to Oracle News in mid-1992 and finally I received the
September/October 1992 issue of "Oracle World" which sated, on the front
page, that it is the new name and new look of Oracle News. The subscription
was $45.  Note that I haven't received an issue since than, and I need to give
them a call to see what's up.

They are at the following address/phone:

P.O.  Box 399, Cedar Park, Texas 78613-9987
Phone: 512-250-9023, Fax: 512-331-3900

The publisher is Publications & Communications, Inc. of Austin, Texas.

Hope this helps!

Regards,

Neil Stern

-- 
Neil Stern, U.S. Marketing, Technical Sales Support, Open Systems 
Bull HN Worldwide Information Systems
Billerica, Massachusetts USA
Phone: (508)-294-3029   Fax:   (508)-294-5328   Email: N.Stern@ma02.bull.com
Newsgroups: comp.databases.oracle
From: Mark Esswein <messwein@nimbus.worldbank.org>
Subject: Thanks for the Info
X-Xxmessage-Id: <A78AEFB12E012652@markesswein-233469.worldbank.org>
X-Xxdate: Tue, 26 Jan 93 18:40:01 GMT
Organization: The World Bank
X-Useragent: Nuntius v1.1.1d11
Date: Tue, 26 Jan 1993 18:43:06 GMT

Thanks for all the responses.  It looks as if SAS/Access is the method of
choice.

Mark Esswein - messwein@nimbus.worldbank.org
---------
The opinions expressed herein are entirely my own and not to be confused
with those of my employer...
Newsgroups: comp.databases.oracle
From: smj@jbecpor.demon.co.uk (Martin Jarvis)
Subject: Embedded SQL
Organization: John Brown E&C Ltd
X-Newsreader: Tin 1.1 PL4
Apparently-To: mail2news@news.demon.co.uk
Date: Mon, 25 Jan 1993 17:20:08 +0000

I have used the Pro languages on Vax's before, but I don't recall any support
for Pro*Basic...
From: bartho@cc.und.ac.za (Ray Bartho)
Newsgroups: comp.databases.oracle
Subject: Does Oracle installation require C compiler
Date: 28 Jan 93 14:44:00 GMT
Organization: University Of Natal (Durban)
NNTP-Posting-Host: pc15.cc.und.ac.za

Can Oracle be installed on a Unix system that does not have the C 
Development kit ? I seem to remember that it asks whether Oracle should be 
reconfigured during the installation process, especially when installing 
the TPO option.

We have previously installed on systems with the C compiler and libraries, 
but are considering an HP 725 system with no C compiler for Oracle / SQL 
teaching purposes.

----------------------------------------------------------------------
Ray Bartho                              Phone    : (031) 816-2468
I.T. Consultant                         FAX      : (031) 816-2125
University of Natal                     Internet : bartho@cc.und.ac.za
Durban
Rep of South Africa
Newsgroups: comp.databases.oracle
From: asjohans@aut.abb.se (Anders S Johansson)
Subject: Structured datatypes in Oracle ?
Date: Mon, 25 Jan 1993 13:50:51 GMT
Organization: ABB Automation AB, Vasteras, Sweden

I have ran into a problem which cannot be handled automatically by 
the Oracle Data Base.

The problem I have is that I want to store user defined data types
in Oracle tables.
The data types can be arrays, unions or structs.
The compination of the data types can be unlimited.

Example (C'ish-style):

typedef struct S1
{
  NUMBER a;
  CHAR b
}

typedef Array A1 of S1[100]

typedef S2
{
  S1 aa;
  A1 bb;
  NUMBER cc;
}

Attributes with the data type S2 shall be stored in Oracle in some way.

The immediate solution I have is to split the data type in several tables
with references between them.

Has anyone been dealing with similar problems, please contact me.

/Anders Johansson
 Lulea, Sweden.
 asjohans%abbaut@mail.swip.net
Newsgroups: comp.databases.oracle
From: jhs@n8ppd001.nt.com (jhs)
Subject: Re: Spool & Trailing Blanks
Date: Tue, 26 Jan 1993 12:23:58 GMT
Reply-To: cmjxs04@nt.com (jhs)
Organization: Northern Telecom,  RTP NC



In response to your questions:

1) I run spool files through sed to remove the trailing blanks:
        sed 's/ *$//' <spool.blank >spool.noblank

2) Your file transfer from UNIX to DOS should take care of the
   text record separators.  If you use FTP (ASCII mode) this is
   done automatically.

john
From: mfriedma@uucp (Michael Friedman)
Newsgroups: comp.databases.oracle
Subject: Re: Oracle CASE training question
Keywords: CASE training
Date: 21 Jan 93 17:42:50 GMT
Organization: Oracle Corporation
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 <1993Jan20.170412.21433@Arco.COM> kmelcher@rafael.Arco.COM writes:
>We are considering sending some DBA's to training for Oracle CASE.  I have 
>seen the current Oracle training schedule,  which lists several CASE classes.
>I am wondering whether it is really necessary to have taken any of the CASE methods 
>courses listed as prerequisites before taking "Implement Systems Analysis and Design 
>Using CASE Tools",  which appears to be the first course in the series in which you
>actually lay your hands on the CASE tools.

>Has anyone out there been through the CASE training series,  and if so,  can you offer some advice on the bare minimum training required to use the tools.

>Thanks in advance,

The bare minimum training is 0.  The manual is decent once you learn
your way arround it and the forms are pretty self explanatory.

The question you have to ask yourself, however, is whether you are
willing to have people with the bare minimum of training making design
decisions about a system that you will probably have to live with for
several years, at least.

My own personal opinion is that if you want the bare minimum, send
your people to the high level CASE courses and let them pick up the
tool on their own.  Setting up functions and entities and drawing ER
diagrams is something you can figure out how to do even without the
course.  The tough part is figuring out which entities and functions
to create.  That's what the high level courses teach.


-- 
-------------------------------------------------------------------------------
I am not an official Oracle spokesman.  I speak for myself and no one else.
From: shamel@mais.hydro.qc.ca (Stephane Hamel)
Newsgroups: comp.databases.oracle
Subject: Re: Q: How to convert *.msg to *.msb
Date: 25 Jan 93 16:50:00 GMT
Organization: Hydro-Quebec (DSB)

adn@kaija.spb.su (ADN communication group) writes:

>I have Oracle 6 but message files was distributed in source form
>as *.msg file.
>Does anyone know how to convert these files to Oracle MSB binary
>format?
>--
>Nick Maximov
>St. Petersburg, Russia

I had a similar problem a couple of months ago. I wanted to translate into
french only a couple of messages without using the complete French message
file. I modified the iapus.msg file, but to "compile" it into iapus.msb, you
need the program called "lmsgen"... wich is not part of the distribution...

I asked Oracle about that program and finally put an hand on it... The
lmsgen program was distributed with previous versions of Oracle, but not
anymore (I seriously wonder why).

Hope this help...
--
 Stephane Hamel (SHamel@Mais.Hydro.Qc.Ca) | AutoControl Inc.
 Senior Programmer-Analyst                | Montreal, Quebec, Canada
From: sharmp@hhcs.gov.au
Newsgroups: comp.databases.oracle
Subject: Re: Oracle Dynamic Performance views questions
Date: 27 Jan 93 12:03:57 +1100
Organization: Aust. Dept. Health, Housing and Community Services

In article <1993Jan20.222718.3562@cmutual.com.au>, btc@cmutual.com.au (Tony Cook) writes:
> Does anyone know what the values for the column 'command' in the view
> v$session actually mean ?
> 
> Sqldba shows UPDATE and SELECT when you are looking at the table access screen
> but I would like to know what are all the valid values and what they mean.
>
Stuff deleted
> 
> I would appreciate any help you may be able to give.
> 
> Thanks,
> Tony
> 
> -- 
> Tony Cook                                    Email: TCook@cmutual.com.au
> Systems Analyst/Programmer                   Phone: +61-3-6418449
> Colonial Mutual Investment Management        Fax  : +61-3-6076198
--
Can't help you with the lock information, but we had to find out what the
values in the COMMAND column meant as well.  All the values are actually in
CATALOG.SQL as a series of inserts into the AUDIT_ACTION table.  Let me know if
you don't have this script, and I'll put up the values for you.

Regards

Peter
 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Peter Sharman                                                 SHARMP@HHCS.GOV.AU
Aust. Dept Health, Housing and Community Services             06-289 7661
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Newsgroups: comp.databases.oracle
From: twod@socrates.demon.co.uk (Ian A Parkin)
Subject: Bug tracking
Distribution: world
Organization: Realizing Relentlessly
X-Mailer: Simple NEWS 1.90 (ka9q DIS 1.19)
Date: Sun, 24 Jan 1993 17:05:40 +0000

Does anyone know of any public domain bug/observation-report/problem-report/
call-it-what-you-will tracking systems that are implemented on ORACLE V6, 
Forms V3 ?

The type of thing that would be useful is a form that enables a user to enter
the details of a bug, areas for discussion about what the bug actually is, 
methods of assigning the problem to a fixer, area in which the fix is
eplained, and areas for acceptance of fix.

I realise that any one company will have different requiremnets from such a 
tool, but do any exist in the public domain that are sufficiently generic for
'normal' use ?

If there are any I can ftp, or accept email.

Thanks in advance

IAP

-- 
-------------------------------------------------------------------------------
			It's not real you know
-------------------------------------------------------------------------------
Newsgroups: comp.databases.oracle
From: adn@kaija.spb.su (ADN communication group)
Subject: Q: How to convert *.msg to *.msb
Organization: KAIJA-SOFT LTD., St. Petersburg, Russia
Date: Mon, 25 Jan 1993 10:22:48 GMT
X-Newsreader: Tin 1.1 PL4

I have Oracle 6 but message files was distributed in source form
as *.msg file.
Does anyone know how to convert these files to Oracle MSB binary
format?
--
Nick Maximov
St. Petersburg, Russia
Newsgroups: comp.databases.oracle
From: tssmith@netcom.com (Tim Smith)
Subject: Re: Oracle Dynamic Performance views questions
Organization: Netcom Online Communications Services (408-241-9760 login: guest)
Date: Sat, 23 Jan 1993 05:44:10 GMT

In article <C17stM.M5r@inews.Intel.COM> kortikar@mipos2.intel.com (Aniruddha Kortikar) writes:
>In article <562@cmutual.com.au> btc@cmutual.com.au (Tony Cook) writes:
>>Does anyone know what the values for the column 'command' in the view
>>v$session actually mean ?
>	This is what I could get by actually typing commands and querying 
>	somebody might want to add to this list other commands and post them
>
>	1	: create table
>	3 	: Insert
>	6 	: Update
> 	7 	: delete
>	9	: create index
>	10	: drop index           
[...]

The command codes are documented in Chapter 2 of the Programmer's Guide to
the OCIs, Table 2-1.

--Tim (tssmith@netcom.com)