HDTenEightyP/NetNews huggingface dataset:
From: andy@homebase.vistachrome.com (Andy Finkenstadt)
Subject: Re: shutdown on SGI
Reply-To: andy@homebase.vistachrome.com
Organization: Vista-Chrome Incorporated
Date: Thu, 7 Jan 1993 04:36:08 GMT

joefw@eosdev1.gsfc.nasa.gov (Joe Fulson-Woytek) writes:
>Has anyone else seen and/or have suggestions for avoiding the following 
>problem?:  We are running Oracle on an SGI under IRIX 4.0.  When we try to
>shutdown oracle while a process is running sqlplus, the shutdown 
>procedure halts.  We would prefer the shutdown to continue without caring
>if someone is currently connected.  Any suggestions?
>Thanks.
>Joe Fulson-Woytek
>Code 902/Goddard DAAC
>NASA/Goddard Space Flight Center
>joefw@eosdev1.gsfc.nasa.gov  

The sqldba command option 'immediate' will shut down the oracle
database cleanly immediately.  There is also the 'abort' option,
but I recommend it NOT be used except when the actual database
is stuck open perhaps because SMON or PMON has died back when
Oracle 6 wasn't so stable.

SQLDBA> shutdown immediate
Database unmounted.
Oracle instance shutdown.
SQLDBA> exit

A shutdown abort doesn't unmount the database, forcing instance 
recovery the next time the database is started up.

-Andy


-- 
Andrew Finkenstadt, Vista-Chrome, Inc., Homes & Land Publishing Corporation
GEnie Unix RoundTable Manager, andy@vistachrome.com, andy@genie.geis.com.

"[The author] neither accidentally nor intentionally omits or includes 
anything that could support a preconceived thesis." - C&EN 21-DEC-92 p.72
Newsgroups: comp.databases.oracle
From: maria@aisws5.cern.ch ()
Subject: Print paper forms from ORACLE
Organization: European Organization for Nuclear Research
Date: Tue, 12 Jan 1993 16:40:09 GMT

Hello,
I hope this is not a FAQ.
Anybody has experience in "the best" way to print beautiful
paper forms (like the ones you have to fill in at the customs etc...) picking the data from an ORACLE db ? The platform is UNIX system V (SGI IRIX 4) and
the printers ... let's say postscript printers.
The old solution that we think we should try to replace is to use a 
Xerox soft to define the page in the Xerox printer.
Any hints will be of great use
Thanks

Maria Varela
AS/MI
CERN
Newsgroups: comp.databases.oracle
From: sethg@dcatlas.dot.gov (Seth Grimes)
Subject: Oracle on Unisys A Series (MCP)??
Organization: U.S Dept. of Transportation
Distribution: comp
Date: Fri, 8 Jan 1993 08:19:07 GMT

We have a Unisys A Series mainframe, mcp operating system, where I work.
We have extensive in-house applications written to use Unisys's DMS-II
DBMS that we'd like to modernize to an "open" data management system.
One could run Oracle on the Unisys and on other platforms under other
OSes and gradually migrate DBs off the Unisys elsewhere.  So my question
is, Is anyone out there running Oracle on the Unisys and willing to share
some experiences (from yes, it runs fine to details)?

Thanks,

                        Seth Grimes, grimes@oecd.fr
From: cj10@cus.cam.ac.uk (C.J. Jardine)
Newsgroups: comp.databases.oracle
Subject: oraperl-v2 on Sun4
Keywords: oraperl
Date: 7 Jan 93 14:17:56 GMT
Organization: U of Cambridge, England

Has anyone out there succeeded in building oraperl version 2 on a Sun?

I am trying to build oraperl version 2 patch 3 on top of perl version
4.0.1.4 patch level 10 under SunOS 4.1.2. I have two problems:

 1. I get 
      ld: Undefined symbol 
         _my_setenv 
 

 2. Oracle requires the system V libraries, but if I put /usr/5bin early
    on my path I get
      "/source/perl/build/perl.h", line 414: redeclaration of sprintf
    while compiling oracle.c.

Could anyone who can solve either of these e-mail me please?
Newsgroups: comp.databases.oracle
From: sjs@netcom.com (Stephen Schow)
Subject: How to do audit trail in Oracle 6
Organization: Netcom - Online Communication Services  (408 241-9760 guest) 
Date: Thu, 7 Jan 1993 20:06:17 GMT


Anyone have any insights on the best way to implement an audit trail under
Oracle 6?

Under Oracle7 it will be easy to set up RDBMS level triggers to automatically
add transactions to an audit trail table whenever any transactions are made
against the regular table.  

Absolutely any ideas or insights will be appreciated.

Thanks in advance
-- 
------------------------------------------------------------------
Steve Schow    | But you don't have to use the claw, if you
sjs@netcom.com | pick the pear with the big paw paw......
(415) 354-4908 | Have I given you a clue......?
               |                       - Baloo the Bear
------------------------------------------------------------------
From: fgreene@hayes.com
Newsgroups: comp.databases.oracle
Subject: Re: Double data entry comparisons
Date: 5 Jan 93 09:35:32 EDT
Organization: Hayes Microcomputer Products, Norcross, GA

In article <1993Jan4.154617.11411@macc.wisc.edu>, dly@vms.macc.wisc.edu writes:
> I have a database design question on double data entry comparisons.
> If it matters, we will be using ORACLE 7.0 (we haven't got it yet),
> SQL*FORMS 3.0, on the Sun platform.
> 
> Debbie Yoshihara
> Department of Biostatistics
> DLY@MACC.WISC.EDU

	I have built similar applications for product testing in pharmacy 
systems.  The easiest way is to build a work table, make your original 
entries in it, and then validate and transfer to the final table.  In that 
way you don't have to worry about klutzing up your live data (it makes 
auditors very happy).

	On the input side, you need to build triggers into your entry forms 
to limit you to a maximum of two entries per key field.  include an ENTRY 
field such that if no previous record exists, the value is set to 1.  If a 
single previous record is found then the value is set to 2.  If two previos 
record already exist then there is an error.

	You mentioned that there will be non-validated data, such as 
comment fields.  In my experience, I found that you have the first entry 
clerk input all data, including the comments and the second clerk only the 
validation fields.  Hence, record 1 will always be thetransfer record and 
record 2 the validation record.

	Actual validation is best accomplished using PL/SQL.  Use a cursor
to fetch the records in key-field sequence.  You will need to establish a
control variable to keep track of whether you are looking at record 1 or
record 2 of a set.  If record 1, save the validation fields to local
variables -- if record 2 compare the validation fields to local variables.
If the fields are identical set a transfer flag in both record 1 and record 
2.

	Output all records with the transfer flag set and an entry value of 
1 to the final table.  These are the records that contain the optional 
fields.  Delete all records from the work table where the transfer flag is 
set.  What is left are the records that failed the validation tests.

 ----------------------------------------------------------------------------
 |      Frank Greene                  |          //////  //////             |
 |      DELPHI SYSTEMS, Inc.          |           ////    ////              |
 |      Telephone [615] 458-6032      |          ////    ////  //////       |
 |      Compuserve 74200,427          |         ////    ////    ////        |
 |      324 Ootsima Way               |        ////    ////    ////         |
 |      Loudon, TN 37774              |       //////  //////  //////        |
 ----------------------------------------------------------------------------
 |         Of course, any opinions or suggestions are strictly my own       |
 ----------------------------------------------------------------------------
 

	
Newsgroups: comp.databases.oracle
From: garth@.comm.mot.com (Garth Kennedy)
Subject: Re: Importing files from LOTUS
Organization: Private Trunked Systems Div. Motorola Inc.
Date: Tue, 5 Jan 1993 07:53:36 GMT
Keywords: LOTUS, IMPORT, ORACLE

In article <31379@nntp_server.ems.cdc.com> rsnyder@ems.cdc.com writes:
>We have an application that requires data to be imported to Oracle 
>tables from a LOTUS spreadsheet.  I don't believe there is any
>Oracle utility to do this. However, I would like the benefit of others
>experience as to how to go about this. The following comes to mind:
>
>1) Are there any Oracle utilities to do the import written by 
>   Oracle, LOTUS or others?
>2) If not what is the best approach to import the LOTUS data?
>   a) Write a script in LOTUS to do the import directly.
>   b) Put the LOTUS data into a flat file and then reformat the flat
>      file to an Oracle Import format.
>   c) Some other method.
>
>Any information, ideas, experience will be helpful.
>
> Thanks,
>  
> Richard Snyder
> rsnyder@ems.cdc.com
>
>Empros Systems International division of Ceridian Corp.
>
>(612)553-4327
>
>    

Well how about exporting to a text file and then using SQL*LOADER ??
There are probably better ways, but off the top of my head this should 
work.


My opinions are all mine - for good or for bad - usually for the worst !

+------------------------------------------------------------------+
| Garth Kennedy       garth@comm.mot.com     Voice (708) 576-3786  |
| Private Trunked Systems Div. Motorola Inc.   FAX (708) 576-6028  |  
+------------------------------------------------------------------+
Newsgroups: comp.databases.oracle
From: joefw@eosdev1.gsfc.nasa.gov (Joe Fulson-Woytek)
Subject: Shutting down sqlnet
Keywords: sqlnet
Reply-To: joefw@eosdev1.gsfc.nasa.gov (Joe Fulson-Woytek 
Organization: NASA/GSFC, Code 902
Date: Thu, 7 Jan 1993 17:50:23 GMT

First of all, an apology for my question about shutting down oracle - I did not
RTFM closely enough and missed the shutdown immediate command which I suspect
is all I need.  Thanks to all who responded.

But I have a similar problem with orasrv and the manual does not indicate
any type of shutdown immediate command.  I'm running on an SGI (IRIX 4) and
when doing a tcpctl stop commmand I get back:
	tcputl: 1 subprocesses are active; server will not be stopped

This is listed in the sqlnet user's guide where it says that the action is
to ask remote users to log off Oracle.  The problem is that we are doing the
shutdown in the middle of the night in a batch mode and it is likely that the
user just forgot to log off before going home.  Any work-arounds?  If this
is being done as part of a reboot procedure, will it hurt to ignore this
message and just reboot the system?

Thanks.


Joe Fulson-Woytek
Code 902/Goddard DAAC
NASA/Goddard Space Flight Center
joefw@eosdev1.gsfc.nasa.gov  
Newsgroups: comp.databases.oracle
From: dave@mizar.csis.dit.csiro.au (David Campbell)
Subject: Binding variables with obndrv()
Organization: CSIRO Division of Information Technology
Date: Wed, 13 Jan 1993 01:09:30 GMT

Has anybody successfully bound floating point program variables using the
Oracle PRO*C function calls obndrv() or obndrn() ?

These calls are documented in the Oracle PRO*C manual.

I can successfully bind an integer (ftype 3) value but when I bind a float
(ftype 4) value with progvl set to either sizeof(float) or sizeof(double),
I get a segv inside the oexec().

Is there anything I could possibly be missing?

Your help would be very much appreciated.

Thanks,

-- 
  +--------------------------------------------------+-----------------------+
  | Dave Campbell                                    |            UNIX & C++ |
  | Phone: + 61 6 275 0944      Fax: + 61 6 257 1052 |   _--_|\       PLEASE |
  | CSIRO Division of Information Technology         |  /      \             |
  | Centre for Spatial Information Systems           |  \_.--._/ <- Canberra |
  | PO BOX 664                                       |        v              |
  | CANBERRA ACT 2601       +------------------------+                       |
  | AUSTRALIA               | dave@csis.dit.csiro.au |                       |
  +-------------------------+------------------------+-----------------------+
  |                       Get right.....or get left.                         |
  +--------------------------------------------------------------------------+
Newsgroups: comp.databases.oracle
Subject: Help needed: Simple Forms V3 Qns.
From: ajmex@brt.deakin.edu.au
Date: 11 Jan 93 23:02:48 EST
Organization: Deakin University, Melbourne

I have been away from Oracle for a couple of years, and have a few questions
relating to SQL*Forms V3 .

1. How do you disable key triggers? In V2 you just defined them with
   text of "#EXEMACRO NULL", but I cant find an equivalent in V3 .

2. I want a screen to set off a background process that runs a SQL*Plus
   routine. How do I run this under the same User/Passwd?

3. In PL/SQL, if a SQL statement returns no rows, this is interpreted as an
   error, and the exception handler is invoked. Is there no way to continue
   processing at this point? Not all cases of "No rows found" are errors, in
   my book. Not fatal errors, in any case.

Thanks for any help given. E-mail prefered. Alister Miller.
From: mfriedma@uucp (Michael Friedman)
Newsgroups: comp.databases.oracle
Subject: Re: 40 values in desc order
Date: 9 Jan 93 17:13:38 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 <1993Jan8.200238.534@osnbe.Olivetti.ch> rheiger@renext.eiger.olivetti.ch writes:
>In article <6622.2b485a61@hayes.com> fgreene@hayes.com writes:
>> In article <Bzo2t0.67@lut.fi>, hietanen@lut.fi (Pentti Hietanen) writes:

>> > What kind of sql sentence should we use to get 40 values
>> > from database in descending order?

>> > Pentti Hietanen, student of Lappeenranta University of Technology, Finland.

>> Probably the easiest way is to use the ROWNUM function.  For example,

>> 	SELECT field1, field2, fieldn
>> 	FROM   the_table
>> 	WHERE  ROWNUM < 40;

>This will only limit the output to the first 40 rows. It will not order them in  
>a predictible manner. If you want to order the rows descending you should  
>probably use the "ORDER BY attr1, attr2... DESCENDING" clause. However this  
>will not restrict the select to 40 rows. To do both you could

>select <attribute1>,....
>from tablename
>where key_attr_list in (
>select key_attr_list
>from tablename
>order by order_attr_list descending)
>where rownum < 40;

Sorry, but this will not work either.

To start with, you can't have an order by in a subquery.

Even if you could, since you are looking at the rownum in the outer
query this would be no different than

select <attribute1>,...
from tablename
where rownum < 40

Finally, there is no order by in the outer query.

If the questioner just wants any 40 rows in descending order then

select <attribute1>,...
from tablename
where rownum <= 40
order by key desc

will work.  If the questioner wants the top forty then...

select <attribute1>,...
from tablename t1
where 40 <= (select count(*) from tablename t2 where t2.key >= t1.key)
order by key desc
-- 
-------------------------------------------------------------------------------
I am not an official Oracle spokesman.  I speak for myself and no one else.
Newsgroups: comp.databases.oracle
From: mfriedma@uucp (Michael Friedman)
Subject: Re: 40 values in desc order
Organization: Oracle Corporation
Date: Tue, 5 Jan 1993 20:07:12 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 <6622.2b485a61@hayes.com> fgreene@hayes.com writes:
>In article <Bzo2t0.67@lut.fi>, hietanen@lut.fi (Pentti Hietanen) writes:

>> What kind of sql sentence should we use to get 40 values
>> from database in descending order?

>> Pentti Hietanen, student of Lappeenranta University of Technology, Finland.
>> internet: hietanen%lut.fi

>Probably the easiest way is to use the ROWNUM function.  For example,

>	SELECT field1, field2, fieldn
>	FROM   the_table
>	WHERE  ROWNUM < 40;

First off, you need to do an order by.

Secondly, unless you are satisfied with any 40 this will not work
because rownum is assigned before the order_by.

If you want the top 40 then try

Select fields
From   the_table t1
Where  40 >= (select count(*) from the_table t2 where 
			t2.order_field > t1.order_field)
Order by order_field DESC

Good Luck
	
-- 
-------------------------------------------------------------------------------
I am not an official Oracle spokesman.  I speak for myself and no one else.
From: dtb@otto (David Bath)
Newsgroups: comp.databases.oracle
Subject: Re: Export/Import to tape?
Date: 12 Jan 93 13:54:19 GMT
Organization: RMIT Computer Centre
NNTP-Posting-Host: otto.bf.rmit.oz.au

bogreen@unixg.ubc.ca (Bo Green) writes:


> 1) I need to change the tablespace allocation of a large database I am
> working with, so I thought the best way would be to Export, create
> new tablespaces, and then Import the tables. Unfortunately, I don't
> have enough disk space to Export to disk. I figure out how I can Export
> to exabyte tape in a reasonably efficient way. Any ideas?

Looks like you are UNIX by your address, so here goes
(1) Compressing export to disk
	mknod ora_export.dmp p
	nohup compress < ora_export.dmp > ora_export.dmp.Z &
	exp / ...... file=ora_export.dmp
	
	This lets you compress on the fly without using any disk (well,
	you will use 4 disk blocks or the size of a pipe).

(2) If exabyte takes streaming input could do the following
	change nohup line to not write to ora_export.dmp.Z but use
	dd(1) {sourcing from stdin} and output to tape.

Hope this helps

David T. Bath	Email:dtb@otto.bf.rmit.oz.au	Phone:03-3477511
Global Technology Corporation, 179 Grattan St, CARLTON, VIC, 3153, AUSTRALIA
"Failure to emulate is the best revenge" - Marcus Aurelius
-- 
David T. Bath	Email:dtb@otto.bf.rmit.oz.au	Phone:03-3477511
Global Technology Corporation, 179 Grattan St, CARLTON, VIC, 3153, AUSTRALIA
"Failure to emulate is the best revenge" - Marcus Aurelius
From: adams@tnt.uni-hannover.de (Martin Adams)
Subject: OOP and relational DBMS
Keywords: OOP ORACLE CLOS
Reply-To: adams@tnt.uni-hannover.de
Organization: Universitaet Hannover, Theoretische Nachrichtentechnik
Date: Mon, 11 Jan 1993 10:03:00 GMT

We would like to store Informations on pictures, methods on these pictures 
and so on ( done in CLOS (object-oriented Common-LISP) on a 
Harlequin-LispWorks-Systems on Sun-SPARC ) in a relational database ( ORACLE ).

I'm just a beginner on OOP and relational DBMS, so I'm desperately looking for 
some Informations on a kombination of these topics !!

Please send your requests to my E-Mail, because I'm not frequently subscribing this Newsgroup.

Thanks in advance !!!


Martin Adams          ---  __o          Spinnereistrasse 1A
                   ----  _`\<,_         3000 Hannover 91 (Germany)
 ``Ride bike!''     --- (*)/ (*)        phone: 0511/454328 or 440651

-- -- -- -- --    adams@helios.tnt.uni-hannover.de    -- -- -- -- --
From: roo@ptt-iat.uucp (? Roo)
Newsgroups: comp.databases.oracle
Subject: RECOVERY
Keywords: RECOVERY, RESETLOGS
Date: 6 Jan 93 10:45:48 GMT
Organization: PTT Telecom B.V. I&AT NWDS-DS-OOTA , Groningen The Netherlands

Hello,


After completing manual or point-in-time recovery you have to issue the
command :

SQLDBA> ALTER DATABASE OPEN RESETLOGS

After completing normal recovery you may never issue this command. Can
anyone tell me why ???



Thanks in advance,


Peter de Roo.
From: holowczk@rwja.umdnj.edu (Richard Holowczak)
Newsgroups: comp.databases.oracle
Subject: Re: VISUAL BASIC AND QELIB
Date: 5 Jan 93 22:59:20 GMT
Organization: Robert Wood Johnson Medical School, Piscataway NJ

In <524.204.uupcb@sqlware.uunet.UU.NET> joe.bartling@sqlware.uunet.UU.NET (Joe Bartling)  writes:


>I have been using Visual Basic under MS-Windows and connecting to ORACLE
>using QELib from Pioneer Software which connects to Oracle via SQL*Net.
>The biggest problem is that I can't connect to a local DOS ORACLE
>database (only client-server).  Other than waiting for Pioneer to come
>out supporting local an Oracle DOS database, are there any other
>solutions given my front-end of Visual Basic?  Has anyone heard of
>Microsoft Access?  Will that help?

  The problem is that a local DOS Oracle database uses its own memory
  management scheme (SQLPME) which conflicts with Windws running in Enhanced
  mode.  If you have enough memory, you can load the Oracle database, then
  run Windows and connect using the "S:" connect string.  The "S:" stands
  for single tasking.  I have done this using Oracle Card and MS Excel using
  the Q+E version which comes with Excel 4.0.



Rich Holowczak                       holowcza@andromeda.rutgers.edu
Rutgers University
Ph.D. Computers and Information Systems Program
+---------------------------------------------------+---------------+
|  For best results, squeeze .sig from the bottom   | Ask about the |
|           and flatten as you go up.               | car alarm FAQ |
+---------------------------------------------------+---------------+
Newsgroups: comp.databases.oracle
From: guy@mais.hydro.qc.ca (Guy Harel)
Subject: How to keep version number inside *.frm ?
Organization: Hydro-Quebec (DSB)
Date: Thu, 7 Jan 1993 21:31:10 GMT


We are looking for a way to tag SQL*FORMS objects (.frm) with version
numbers so we can keep track of our many distributions.

We know that with C, on merely as to define:
	
		char sccs_id = "@(#) Version 1.0"

...and than use 'what' on the compiled unit to extract the above info.


I just found out that we can also do the following in a '*.inp'

		TITLE = "@(#) Version 1.0"

...generate and then use 'what' on the '*.frm' to extract the info.

Is there another or better way to acheive that?

P.S: We are planning to use PVCS as a source code manager, and hope the
version number could be automaticaly maintained, even in our '*.inp'.

Thanks for any info.


-- 
 Guy Harel
--
 Guy Harel
From: dtb@otto (David Bath)
Newsgroups: comp.databases.oracle
Subject: Re: How to keep version number inside *.frm ?
Date: 8 Jan 93 03:29:27 GMT
Organization: RMIT Computer Centre
NNTP-Posting-Host: otto.bf.rmit.oz.au

guy@mais.hydro.qc.ca (Guy Harel) writes:


>We are looking for a way to tag SQL*FORMS objects (.frm) with version
>numbers so we can keep track of our many distributions.

>We know that with C, on merely as to define:
>	
>		char sccs_id = "@(#) Version 1.0"

>...and than use 'what' on the compiled unit to extract the above info.


>I just found out that we can also do the following in a '*.inp'

>		TITLE = "@(#) Version 1.0"

>...generate and then use 'what' on the '*.frm' to extract the info.

>Is there another or better way to acheive that?

>P.S: We are planning to use PVCS as a source code manager, and hope the
>version number could be automaticaly maintained, even in our '*.inp'.

>Thanks for any info.


>-- 
> Guy Harel

I use RCS, and it is dead easy.  It also has UNIX and DOS ports.
All you need do is have a variable that is assigned a value when the
form starts up that has the identifier you choose.

David T. Bath	Email:dtb@otto.bf.rmit.oz.au	Phone:03-3477511
Global Technology Corporation, 179 Grattan St, CARLTON, VIC, 3153, AUSTRALIA
"Failure to emulate is the best revenge" - Marcus Aurelius
-- 
David T. Bath	Email:dtb@otto.bf.rmit.oz.au	Phone:03-3477511
Global Technology Corporation, 179 Grattan St, CARLTON, VIC, 3153, AUSTRALIA
"Failure to emulate is the best revenge" - Marcus Aurelius
Newsgroups: comp.databases.oracle