HDTenEightyP/NetNews huggingface dataset:
From: sjs@netcom.com (Stephen Schow)
Newsgroups: comp.databases.oracle
Subject: HELP with complex view?
Date: 9 Nov 92 23:27:31 GMT
Article-I.D.: netcom.1992Nov9.232731.3618
Organization: Netcom - Online Communication Services  (408 241-9760 guest)

I am trying to do something in a view that I can't figure out.

I have a table with a column of type CHAR(25) and need it to appear in the
view as CHAR(255).  It would normally be easy to just use RPAD() to pad
the column out to 255 characters, but I don't want any trailing blanks
in the data retrieved from the view.

I thought of using this:

RPAD(column,255,NULL) to pad it out with the NULL value.  It did indeed 
return a column with a length of 255, but ALL of the data was gone.

HELP   HELP    HELP
-- 
------------------------------------------------------------------
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
------------------------------------------------------------------
From: pauck@mcshh.Hanse.DE (Marco Pauck)
Newsgroups: comp.databases.oracle
Subject: Recovering ORACLE V5.1 DB with corrupt BI file??
Date: 12 Nov 92 21:08:51 GMT
Organization: Point of Presence & MCS Hamburg

One of our old ORACLE V5.1 DBs crashed because of a system failure.
When I try to bring ORACLE up again it attempts to recover but the
before image file seems to be corrupt.

Is there a way to bring ORACLE up WITHOUT the recovery procedure,
ignoring the old BI file, and supplying a new one?

The system is an IBM RT/PC under AIX 2.2.1.

	Marco
-- 
Marco Pauck
WMD GmbH, Hamburg, Germany
email: pauck@mcshh.hanse.de
phone: +49-40-580111
Newsgroups: comp.databases.oracle
From: rec@indetech.com ()
Subject: SNMP/SMP MIB for Oracle from Oracle?
Organization: Independence Technologies, Inc. Fremont, CA
Date: Thu, 12 Nov 1992 02:20:01 GMT


I've heard a glimmer of a rumor that Oracle may have made available
an SNMP or SMP Management Information Base for Oracle databases.

1. Is there such a beast?

2. What sort of proxy-agent technology does it require?

3. Is this a "real" Oracle product, a "consulting" Oracle product,
   or a "future" Oracle product?

Yes, I'll call my sales rep as well, but he won't be open till
9:00 AM ;-)
-- 
--
____*_  Rick Cobb		   	rec@indetech.com 
\  / /  Independence Technologies, Inc 	{sun,pacbell,uunet}!indetech!rec
 \  /   42705 Lawrence Place	   	Fax:   (US) 510 438 2034
From: dtb@otto (David Bath)
Newsgroups: comp.databases.oracle
Subject: Re: Oracle delta
Date: 6 Nov 92 07:14:38 GMT
Organization: RMIT Computer Centre
NNTP-Posting-Host: otto.bf.rmit.oz.au

sstephen@us.oracle.com writes:

>In article <1992Oct28.172223.11805@aio.jsc.nasa.gov>, russell@gothamcity.uucp (Russell Sellers [GHG]) writes:
>> 
>> I have a question about the way oracle keeps track of the transactions
>> that occurr during the day. I know that if I do a transaction then I can roll
>> it back as long as a commit wasn't performed. Is there something like this
>> that would allow me to rollback everything that occured during a say.
>> What I am trying to find out is there some way to keep track of database
>> delta's for each day. If there is can this file be parsed by a different
>> program to produce some type of summary report.
>-- 
>What you would need to do this is a "redo log/archive file parser".  Such a
>utility is not avaialable to the public, (although I'm sure the developers
>should have written one).  Since the information in those files would reveal a
>lot about Oracle's internal secrets as well as invalidate all database
>security, I doubt such a utility will ever exist in the near future.

Well folks, I know that Ingres had a similar facility that listed transaction
numbers, times, table, rowid (called a tid in ingres) and even before and
after values !

This was using Ingres v5 under VMS back in late 1987.

This let you then decide to roll back to a specific time or transaction number.

What about it, Oracle ?

-- 
David T. Bath
email: 	dtb@otto.bf.rmit.oz.au
Work: 	Global Technology Corporation, Carlton, Vic, OZ  (03) 3477511
#include <disclaimer.h>
From: dave@ema.rockwell.com (Dr. Dave)
Newsgroups: comp.databases.oracle
Subject: Oracle SQL*Net and Public Domain TCP/IP Drivers
Date: 12 Nov 92 22:08:27 GMT
Organization: Rockwell International

Does SQL*Net v1 support any Public Domain TCP/IP Drivers?
(e.g. Clarkston)   


-- 
-------------------------------------------------------------------------
Dave Emde
Rockwell Intl. (Space Systems Div.)
Downey, Ca.
dave.emde@rockwell.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Bush, Clinton, Perot .... I'll just vote for my Sun.
-------------------------------------------------------------------------
From: mereddy@thumper.tmc.edu (Praveen K. Mereddy)
Newsgroups: comp.databases.oracle
Subject: SQLForms30 - generating sequence number
Date: 6 Nov 92 07:24:49 GMT
Article-I.D.: ra.1992Nov6.072449.10345
Organization: Mississippi State Univ.


Hi, I am working on sqlforms30.  I have some proble in generating a
default sequence number.  I am not able to generate numbers in sequence,
though i could generate unique numbers.

I have following code in my sqlplus shema
CREATE SEQUENCE ITEMID
INCREMENT BY 1
START WITH 10000
NOCACHE;

and I have given following code for the field as default value in
field definition form

:SEQUENCE.fieldname.NEXTVAL

note: here field name is the name of the field for which I am
generating sequence number

This sequence number generating some times only EVEN numbers in
sequence or ODD numbers.

Is it better to write a trigger instead of selecting value.

Conveying my THANKS in advance,

Mereddy

mereddy@walt.cs.msstate.edu
From: frampton@vicuna.ocunix.on.ca (Steve Frampton)
Newsgroups: comp.databases.oracle
Subject: How to disable '$' DCL shell?
Keywords: vax vms oracle sqlplus
Date: 5 Nov 92 16:19:40 GMT
Reply-To: frampton@vicuna.ocunix.on.ca
Organization: Vicuna Systems, Kingston, ON (613) 547-5066
Content-Type: text

Hi everyone:

I would like to find out how to disable the '$' shell to DCL from SQLPLUS
for the comp. services dept. @ my place of employment.  This seems to be
somewhat of a security hole and if there is a simple way to disable users
from accessing it how is it done?

Oh, this pertains to Oracle SQL*Plus running under VAX VMS, by the way.

Please respond via e-mail to preserve bandwidth, I shall be more than
happy to follow-up with a summary.

Thanks in advance.

----------------------------------------------------
Steve Frampton  <frampton@vicuna.ocunix.on.ca>
Vicuna Systems BBS - 613/547-5066 [9600 v.32/.42bis]
Newsgroups: comp.databases.oracle
From: tssmith@netcom.com (Tim Smith)
Subject: Re: Dynamic SQL - PREPARE
Organization: Netcom - Online Communication Services  (408 241-9760 guest) 
Date: Thu, 12 Nov 1992 03:45:41 GMT

In article <1992Nov11.191651.1@vax1.tcd.ie> nafallon@vax1.tcd.ie writes:
>Hi, anybody like to help a struggling Oracler?.
>One of our tables has a column listing the other tables to be accessed. 
>I want to read a table name into a variable and then query that table for some
> more data, therefore I have to use Dynamic SQL, but I cannot seem to get past
> the PREPARE stage.
>
>The statement: EXEC SQL PREPARE subcat_stmt FROM :select_stmt;
>
>gives the error: ORA-00911: invalid character
>
>select_stmt is created as follows..
>
>EXEC SQL BEGIN DECLARE SECTION;
>        VARCHAR select_stmt[200];
>EXEC SQL END DECLARE SECTION;
>
>sprintf(select_stmt.arr,"SELECT song FROM rush WHERE album = 'Presto'");
>
>I have tried all sorts of combinations of VARCHARs and char's as well as using
> variables for column names but the same error always results.
>Any pointers as to why this is happening would be greatly appreciated.
>
>Niall Fallon

Looks like you're not setting the length component of the VARCHAR.  Your
sprintf should be:

select_stmt.len = sprintf(select_stmt.arr, "SELECT ....

--Tim (tssmith@netcom.com)

Xref: sparky comp.databases.oracle:2147 comp.software-eng:4195 comp.sys.mac.hypercard:4119 comp.sw.components:163 comp.sys.mac.apps:16915
From: javier@cs.utexas.edu (Javier H. Seen)
Newsgroups: comp.databases.oracle,comp.software-eng,comp.sys.mac.hypercard,comp.sw.components,comp.sys.mac.apps
Subject: *** WANTED: Testing Tools for HyperCard/ORACLE Environment ***
Date: 8 Nov 1992 01:25:10 -0600
Organization: U Texas Dept of Computer Sciences, Austin TX
Distribution: world
NNTP-Posting-Host: im4u.cs.utexas.edu
Summary: Automated Test tools for interface and SQL commands
Keywords: HyperTalk, ORACLE Access, SQL


Hi, World Netters:

My Testing and Evaluation team is planning to do some serious testing on
the following software design and implementation products:

	* Design and functional specifications
	* HyperCard high-level interface script code
	* ORACLE Access database command code (on ORACLE v2.0)
	  (this is a new replacement of Hyper*SQL on ORACLE v1.1.1)

For those still unfamiliar with the kind of programming environment in which 
we are working, we are writing a database application on ORACLE for the
Macintosh, using the HyperTalk script language as the interface to ORACLE
Access, an internal interface language between HyperTalk and SQL (most likely
invoked using the "execsql" command, if I'm not wrong).

I wonder if there are any particular commercial testing tools suitable for
our needs, or otherwise simple, ftp'able shareware tools.  Some of the
automated products we'd like to try to aid us in our excruciating tasks are:

	* capture/replay tool (something better than MacroMaker?)
	* automatic flowgraph generator and analyzer
	  (to check control- and data-flow diagrams)	
	* automatic/random data generator
	* coverage certifier/monitor
 	* finite state machine (FSM) test tool
	* any test design automation tool, functional generator, etc.
	* general report generator
	  (though we can live with FileMaker Pro to produce, say, bug reports)

Notice that the tools above must be compatible with the programming 
environment described above.  I have also heard of integrated testing
tools out there in the market, which is perfectly acceptable.

I appreciate any references or direct contacts to order some of the
tools desribed above.  At least the quality of such tools have to be
"decent" by software standards.

Please reply to me via e-mail.  Thanks again for any feedback.

--Javier H. Seen
  javier@cs.utexas.edu
-- 
----------------------------------------------------------------------------
Javier H. Seen, TA,   CS Dept, UT-Austin, TX 78712    <javier@cs.utexas.edu>
(O)471-9709, (H)473-2361     | "I wanna be like Mike" (Mike Burton, that is)
Office: PAI 5.68, M-S 18h-5h | "Why do .signature files hafta be SO short?"
Newsgroups: comp.databases.oracle
From: ddruker@agsm.ucla.edu (Daniel Druker)
Subject: Re: Oracle delta
Organization: Anderson Graduate School of Management, UCLA
Date: 6 Nov 92 10:32:53 PST

In article <dtb.721034078@otto> dtb@otto (David Bath) writes:
>sstephen@us.oracle.com writes:
>
>>In article <1992Oct28.172223.11805@aio.jsc.nasa.gov>, russell@gothamcity.uucp (Russell Sellers [GHG]) writes:
>>> 
>>> I have a question about the way oracle keeps track of the transactions
>>> that occurr during the day. I know that if I do a transaction then I can roll
>>> it back as long as a commit wasn't performed. Is there something like this
>>> that would allow me to rollback everything that occured during a say.
>>> What I am trying to find out is there some way to keep track of database
>>> delta's for each day. If there is can this file be parsed by a different
>>> program to produce some type of summary report.

V7 includes a Snapshot facility that does this. It keeps track of 
changes to tables (inserts, updates, deletes) and stores this  
in a log for each snapshot. You could use this information in whatever 
fashion you like. Snapshots are supposed to be for asynchronous database
replication, but I don't see why you couldn't use them for what you want.

In any case, you can use post-insert, update, and delete triggers to 
log changes including pre and post values quite easily , if snapshots don't
automatically give you everything you need.

Hope this helps, 

- Dan

Daniel Druker
Anderson Graduate School of Management at UCLA
                   

----------------------------------------------------------------------------
| Dan Druker                                                               |
| agsm mail 	: ddruker                                                  |
| internet 	: ddruker@agsm.ucla.edu                                    |
| oracle*mail	: unix:ddruker@agsm.ucla.edu                               |
----------------------------------------------------------------------------

Disclaimer:  None. I'm a student now and I don't care what you think. 





Newsgroups: comp.databases.oracle
From: pkm1@Ra.MsState.Edu (Praveen Mereddy)
Subject: HELP! How to run SQLReport on SUN unix, vt100 
Organization: Mississippi State University
Date: Fri, 6 Nov 1992 23:09:34 GMT

Hi netters,

I want to work on SQLReprts on SUN, Vt100 I have an account on it. Even I worked
on the tutorial a month ago.  But now I am not able to create a new report.
 I am using the following command to envoke SQLReports.

              sqlrep term=swr_sun 
ERROR:
     When I tried to create a new report selecting the option 'New' under
     'ACTION', then it is giving the following error mesage..

     Unanticipated error - Table or View doesn't exist.

I don't think it needs a table to just create a report at that point
of action.  I have all my tables in the same directory though.

One of my friend who is working on SQLReorts on the same MACHINE is
using the following command.
 
                sqlrep term=swr_term 
                                -----
He is able to create a newreport and able to do Querying etc...

pkm1% sqlrep term=swr_term
--------------------------

SQL*ReportWriter: Version 1.1.12.0.1 - Production on Fri Nov  6 13:00:11 1992

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

Error opening terminal description file: 
/usr/local/oracle/sqlreport/admin/terminal/swr_term

-------------------------------------------------------------------------

I appreciate your help in advance.

Thanks

Praveen
Newsgroups: comp.databases.oracle
From: dojt@picasso.lab (Jonathan T. Do)
Subject: Re: Which Cobol's work with Pro-cobol?
Reply-To: dojt@picasso.lab
Organization: Sun Microsystems, Inc.
Date: Tue, 10 Nov 1992 22:06:58 GMT

Try Microfocus pro-cobol
From: white@titan.tsd.arlut.utexas.edu (Eric White)
Newsgroups: comp.databases.oracle
Subject: Archive getting stuck...
Date: 12 Nov 92 00:13:35 GMT
Article-I.D.: macaw.WHITE.92Nov11181335
Distribution: comp
Organization: /home/hyperion/white/.organization

What causes the Archiver to get stuck?

I'm aware of the obvious reason -- running out of disk space, but
that's not my problem.  I've got over 2G free disk space, but
the Archiver regularly gets stuck..

I'd really like to use this v6 feature because of the recovery
granularity, but not at the expense of the database halting every
other day...

--

==
            "... big dogs landing on my face ..."
				   -- Robin Williams, 'Good Morning, Vietnam'

Eric White		Internet: white@titan.tsd.arlut.utexas.edu
Applied Research	Phone:	  (512) 835-3621   FAX: (512) 835-3416/3259
  Laboratories		Fedex:	  10000 Burnet Road, Austin, Texas 78758-4423
University of Texas	Postal:	  P.O. Box 8029, Austin, Texas 78713-8029
==
From: bamon@ocvaxc.cc.oberlin.edu
Newsgroups: comp.databases.oracle
Subject: Re: How to enhance the forms?
Date: 4 Nov 92 14:10:17 GMT
Organization: Oberlin College

In article <s897336.720452325@minyos.xx.rmit.OZ.AU>, s897336@minyos.xx.rmit.oz.au (Lip Meng Soh) writes:
> 
> Is there any possible way to make the blocks in the form transparent to users?
> That's user dont need to keep track of which block he/she is presently
> in and to press 'KP--' to move to next block. 

Certainly - Just create appropriate key triggers to make the navigation
transparent to the user, e.g. KEY-NXTFLD from the last field in a block
goes to the first field in the next block.

_____________________________________________________________________
Jennifer R. Amon     FREENET: aa1190@freenet.lorain.oberlin.edu
Oberlin College      FREENET: cc312@cleveland.freenet.edu
Oberlin, OH 44074   *INTERNET: bamon@ocvaxc.cc.oberlin.edu
PH: (216) 775-6987   BITNET: bamon%ocvaxc.cc.oberlin.edu@ocvaxc.bitnet
FAX: (216) 775-8573  *use the internet address if possible        
_____________________________________________________________________
Newsgroups: comp.databases.oracle
From: un@gdstech.grumman.com (Un Fu)
Subject: Thanks for the solution : ) to "extent allocation?" & "Help! Oracle problem or my problem?"!
Organization: Grumman Data Systems-Woodbury
Date: Mon, 2 Nov 1992 19:15:06 GMT

I would like to thanks all the responsers to my posting of
the following two qestions on the net:

     "extent allocations"?
     "Help! Oracle problem or my problem?"

Andy Finkenstadt, Scott Stephens => Thanks for the dummy table solution!
				    I am so glad there is a way to get around
				    the problem.  I would never figure it out
				    myself.

To the responsers that told me there is no way out, here is the work
around:

					         	 # of bytes
                                                            |
CREATE TABLE BIG_TEMP (PARAM1 CHAR(10)) STORAGE (INITIAL 1000000 MINEXTENTS 1);
DROP TABLE BIG_TEMP; 

As Scott and Andy stated to me, Oracle first looks for exact fit, then best
fit, and then coalesce of smaller, CONTIGUOUS, extents when it allocates
extents for object creation.  The DUMMY table creation above will force
the coalesce of smaller, contiguous, extents into one large extent.  
I tried the solution and it worked, awesome!  You might have to coalesce
the small extents in several passes if you have many.  I ran into an
insufficient row_cache_enqueues error when I tried to coalesce 5000 blocks
at once.
-- 
****************************************************************************
Un Un Fu                                    Internet: un@gdstech.grumman.com
Disclaimer: I am solely responsible for what I am saying here!
****************************************************************************
Newsgroups: comp.databases.oracle
From: IMAGING.CLUB@OFFICE.WANG.COM ("Imaging Club")
Subject: Re: Wang "Technetron '92 storms Boston"
Organization: Mail to News Gateway at Wang Labs
Date: Fri, 6 Nov 1992 22:01:54 GMT

Regarding the interest in attending this RDBMS seminar, I called
up the organizers of the half-day seminar sponsored by the
Americas PACE special interest group.  (Tel. 708-652-3888)
They indicate that for people attending the full $995 conference,
this seminar is $200 and for other people it is $350.  It
starts at 1:30 PM and goes through 5:00.  The events are taking
place at the Sheraton Boston Hotel & Towers.

                       Wang in the News...
         The Independent Newspaper for WANG Computer Users

                 Technetron '92 storms Boston

RELATIONAL DBMS,
open systems
key topics

An in-depth three-hour exploration of relational database
theory and practice by the relational model guru, Chris Date,
headlines Technetron/Pace '92 in Boston Nov. 9-12, but that's
not the only hot topic.  The keynote address by Wang CEO Rick
Miller may eclipse the database presentation in importance for IS
managers....

Michael.Willett@OFFICE.Wang.com
From: kverruyt@nl.oracle.com (Kees Verruyt)
Newsgroups: comp.databases.oracle
Subject: Re: Oracle 7.0.9.3, XA, and Encina
Date: 5 Nov 92 08:14:22 GMT
Organization: Oracle Europe

Alan Beal writes:
> Has anyone been successful using Oracle 7.0.9.3 with Transarc Encina
> 1.0.1a using the XA interface?  Using embedded SQL, we get data
> retrieved on the first Encina transaction and then get invalid
> cursor after that (sqlcode = 1001).  Oracle Support will not help
> because it is not a production product.  Any ideas?
>
> Alan Beal         alanb@owgvm0.vnet.ibm.com
 
Alan, 

I struggled with this myself -- just compile your Pro*C program with

EXEC ORACLE OPTION (RELEASE_CURSOR=YES);

Otherwise the Pro*C cursor cache gets in the way: Even if you CLOSE a cursor,
Pro*C tries to keep it open.

It should work fine after that.

Note: Since this is ORACLE7, closing a cursor in the front-end isn't so bad since
      the parsed SQL is kept around in the ORACLE7 server SGA.


-- 
/*
EXEC SQL INCLUDE ORA_DISCLAIMER;
*/
-- This posting reflects the views of myself, not Oracle Corporation.
------------------------------------------------------------------------
Kees Verruijt                           Rijnzathe 6
Software Engineer Gateway development   3454 PV  DE MEERN
Oracle Europe                           The Netherlands
Email: kverruyt@nl.oracle.com           Tel: +31 3406 94886
   or: kverruyt@oracle.nl               Fax: +31 3406 65603
From: antoine@Apple.COM (Antoine Duong)
Newsgroups: comp.databases.oracle
Subject: Oracle Personal License?
Date: 12 Nov 92 00:45:48 GMT
Organization: Apple Computer Inc., Cupertino, CA


Does anyone know if Oracle has personal license like DEC's?
With Rdb I can buy just two user license and it does not 
matter how large a VAX I have. I was told that Oracle has
a minimum 8 user-license. This is a bit much for me who
only needs to test my software with 1 or 2 connections.
Thanks,
elroy.jpl.nasa.gov!ames!nsisrv!eosdev1.gsfc.nasa.gov!joefw
From: joefw@eosdev1.gsfc.nasa.gov (Joe Fulson-Woytek)
Newsgroups: comp.databases.oracle
Subject: Getting out of Monitor
Date: 6 Nov 92 05:55:05 GMT

Organization: NASA/GSFC, Code 902.2
Distribution: usa
Date: Fri, 6 Nov 1992 17:59:11 GMT

I have recently installed oracle v6 on an SGI (4D/35).  I am logged onto the
SGI from a SUN Sparcstation 2.  The default crt type is set to vt100.  I enter
the sqldba command, connect to the database and type in "monitor".  The initial
menu comes up fine and I am able to select what I want to monitor.  THe monitor
display comes up and is refreshed every 5 seconds.  The problem is that I can't
get out of the monitor display.  Is there a special exit sequence, or do I need
to set an exit sequence somewhere?


Thanks.
Joe Fulson-Woytek
Code 902/Goddard DAAC
NASA/Goddard Space Flight Center
joefw@eosdev1.gsfc.nasa.gov
From: sstasuke@ncrsoph.Sophia.NCR.COM (Steve Stasukewicz)
Newsgroups: comp.databases.oracle
Subject: Need help with Forms 2.3
Date: 5 Nov 92 14:56:15 GMT
Reply-To: sstasuke@ncrsoph.Sophia.NCR.COM (Steve Stasukewicz)
Organization: NCR European Development Center


I'm using Forms 2.3 with Oracle V6 and have the following problem:

I'm trying to create a multi-row block that contains 3 columns of data.
Each column on the form comes from a different table in the database.
I have the block defined to have 10 rows.  If the query retrieves more than
10 rows I would like to be able to scroll downwards when I reach the last
row on the screen.  My first problem is how to populate the block.
Currently I have something like this that doesn't work at all.

select table1.field1, table2.field2, table3.field3
into   block1.f1, block1.f2, block1.f3
from   table1, table2, table3
where  ( join condition to join 3 tables )

This will retrieve a single row and put it into the correct fields on the
form, but it will not populate rows 2 thru 9 in the block.   ( I know there
is more than 1 record that meets the criteria.)  What am I doing wrong?
If it's not already obvious, I'm new to Forms.  Please HELP!

Thanks in advance.

Steve 


---------
Steve.Stasukewicz@sophia.NCR.FR     
NCR Europe Group ISS/ECS
Espaces De Sophia
25 Route de Lucioles                   Tel. (33) 92.94.45.12
06560 Valbonne FRANCE                  Fax. (33) 92.94.45.45
--