HDTenEightyP/NetNews huggingface dataset:
From: jhs@n8ppd001.nt.com (jhs)
Subject: Re: Pro*c and SVR4
Date: Tue, 26 Jan 1993 12:35:54 GMT
Reply-To: cmjxs04@nt.com (jhs)
Organization: Northern Telecom,  RTP NC
Keywords: varchar warnings


|>
|>
|>We were looking for a precompiler option but there doesn't seem to be one
|>that would resolve this problem.  Does anyone out there have any simplier
|>ideas on how to solve this?
|>
|>We are using oracle version V6.0.33.1.2 and oracle precompiler
|>version 1.3.18.1.2
|>

Unfortunately there is no option to fix the unsigned char problem.

We are using the version 1.4 and 1.5 precompilers.  They correct
several other deficiencies, but they still have the same type 'error'.
The problem is even worse when you try to embed SQL in C++.  The type
mismatch with standard string functions cause a lot of problems.

Some people run a filter on the output of pcc/proc before running cc
to clean up the varchar declarations.

john

Newsgroups: comp.databases.oracle
From: smj@jbecpor.demon.co.uk (Martin Jarvis)
Subject: Re: Q: Duplicate records
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:42:48 +0000

Oracle's Technical Bulletin, March 1992

DELETE FROM tablename
 WHERE ROWID NOT IN 
     ( SELECT MAX(ROWID) FROM tablename
        GROUP BY keycolumn1, keycolumn2, etc )
From: bmarjan@pluto.csee.lehigh.edu (bmarjan)
Newsgroups: comp.databases.oracle
Subject: VT320 Terminfo definitions
Date: 21 Jan 93 20:15:04 GMT
Distribution: comp.databases.oracle
Organization: Electrical Engineering and Computer Science, Lehigh University

I would appreciate any help on the following:
I have connected DEC VT-320 terminals to a Sun SPARC IPX using an Sbus
board and am running various ORACLE applications (SQL*Forms, SQL*Menu,etc.)
on the VT320. However, in the /etc/termcap database and /usr/share/lib/terminfo/v directory there is no definition for the VT320. Hence, when I runthe
applications, the required special characters do not show up (replaced by
other characters). What I would need are the definitions for the VT320
to place in the ttytab file.

Thanks in advance.

Bijan Marjan
Technology Systems Corporation
bmarjan@lion.eecs.lehigh.edu
From: holowczk@rwja.umdnj.edu (Richard Holowczak)
Newsgroups: comp.databases.oracle
Subject: Re: Windows and Oracle access.
Date: 26 Jan 93 21:06:23 GMT
Organization: Robert Wood Johnson Medical School, Piscataway NJ

skanga@us.oracle.com (Shiraz Kanga) writes:

>In article <1856@rwja.umdnj.edu> holowczk@rwja.umdnj.edu (Richard Holowczak) writes:

>That is correct. Just wanted to clarify that on the PC (DOS and OS/2) there
>are forms designers as well as runform available. There is also runform and
>runmenu for windows. All these are available NOW as part of the 6.0A tools.
                                                ^^^^^^^^^^^^^^^^^^^^^^^^^^^
>shiraz

       If I have a copy of 6.0 Tools, Can I get the Windows Goodies? How
       much will this cost?

Rich H.
Rutgers U.
From: rdutc@sarek.xerox (Ray Dutcher)
Newsgroups: comp.databases.oracle
Subject: Re: Export/Import to tape?
Date: 22 Jan 93 20:00:37 GMT
Reply-To: rdutc@sarek.xerox
Organization: Sun Microsystems, Inc.

Compressing the export through a named pipe worked great and I did the reverse fine without any loss of data.  I also did this with success on data files (ie. a physical backup).  Thanks for the info.  Just to check I called Oracle Support to see if they were familiar with this technique and they said that they know of customers who do this but they know that some customers have experienced a loss of data when using the UNIX compress/uncompress command and that Oracle will not support this technique.  I've



 also used compress in the past on exports to transfer a database to another machine over my network and also had zero problems.

Before I put this technique into a production system I would like to know if anyone has experienced the "data loss" that Oracle Support mentioned? and if so please state your Oracle version and OS when replying.

FYI, here's the technique I'm referring to:
(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).

Thank you for any responses.
From: mahmoud@icts01.kodak.com (Ahmed Mahmoud)
Newsgroups: comp.databases.oracle
Subject: Pro*C and gnu C on SUN
Keywords: proc gnu sun
Date: 21 Jan 93 12:03:40 GMT
Organization: Eastman Kodak
Originator: mahmoud@icts01

We are planning on using gnu C with pro*c with oracle version 7 on a SUN 670
running sunos 4.1.2. Does anybody out there have any idea why this should not
work...has anyone out there tried this combination....has anyone used gnu	with oracle????   thanks for any info on this matter....Ahmed Mahmoud	


please reply to mahmoud@kodak.com
From: dtb@otto (David Bath)
Newsgroups: comp.databases.oracle
Subject: Re: Database files
Date: 21 Jan 93 18:09:11 GMT
Organization: RMIT Computer Centre
NNTP-Posting-Host: otto.bf.rmit.oz.au

jbaker@moby.micro.umn.edu (Jeffrey J Baker) writes:

>The company I work for has been thinking about moving their Oracle development
>system from a RISC platform to one running OS/2.  I know that there will be no
>problem reloading the existing forms, but what I am wondering about is whether
>or not the existing database files (dbs*.dbf) can be copied directly over to
>the new system.  Has anyone had experience with this procedure?  Are there other
>problems with doing this that I am not taking into consideration?
>Any suggestions would be much appreciated.


Use the Oracle EXPORT/IMPORT Utility.  You cannot copy *dbf files.
>Jeff
>jbaker@cs.umn.edu
-- 
David T. Bath	Email:dtb@otto.bf.rmit.oz.au	Phone:+61-3-3477511
Global Technology Corporation, 179 Grattan St, CARLTON, VIC, 3153, AUSTRALIA
"Failure to emulate is the best revenge" - Marcus Aurelius
From: dlm@hermes.dlogics.com
Newsgroups: comp.databases.oracle
Subject: Re: Windows and Oracle access.
Date: 20 Jan 93 15:44:16 CST
Followup-To: comp.databases.oracle
Organization: Datalogics, Inc., Chicago, IL

holowczk@rwja.umdnj.edu (Richard Holowczak) writes:
> patrick@casbs.Stanford.EDU (Patrick Goebel) writes:
>     ... As for Windows, I believe the Windows versions of
>     RUNFORM and the Menu thingy are in development or Beta at this time.

The oracle tools package version 6 comes with a sqlforms which you
can run in windows mode, but it occupies a character-cell
window which is not a bit-mapped or gui version of your form.
--
Dave Mausner, Senior Consultant / Datalogics Inc / Chicago IL / 312-266-4450
dlm@dlogics.com                                 Motto: Just show me the code

Newsgroups: comp.databases.oracle
From: jan@kowari.cpsg.com.au (Jian Cai)
Subject: SQL*NET: a server serves multiple ORACLE_HOME/ORACLE_SID?
Organization: Computer Power Software Group Pty Ltd
Date: Mon, 25 Jan 1993 00:20:29 GMT

Q: Does an ORACLE server serves requests from different ORACLE_HOME
   and/or ORACLE_SID?
   Assume on host A there are multiple sets of ORACLE_HOME/ORACLE_SID
   and on host B there is one orasrv running. Will the server on B serves
   clients on A? If not, how to get it work?
From: philv@atlastele.com (Philip Vassar)
Subject: Re: Export/Import to tape?
Keywords: Export, Import 
Organization: Atlas Telecom Inc.
Date: Sun, 24 Jan 1993 05:20:05 GMT

In article <bogreen.726774727@unixg.ubc.ca> 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?

You can export to a named pipe and compress the output (assuming 'nix).
I would identify all user objects in the tablespace first and export each
table by itself.

After all user objects have been exported drop the tables. (Don't bother
to export the indexes). After all user tables are dropped you can then do
a full export (talking system tables at this point). You now have seperate
images of each table and the system. Drop the tablespace at this point.
Recreate the tablespace(s) and execute your schema generation scripts.
Be sure and adjust the storage clauses so that the entire table will fit
in a single extent. I keep my index creation scripts seperate from my
table creation scripts this will allow me to import the data and not create
indexes during import (can slow things down a great deal). After the import
you can run your index creation scripts, once again adjust the storage
clauses so that all index extents will compress into one.
>
> 2) If I use "COMMIT=Y" on an Import, will that solve the problem of a 
> lack of enough rollback space for a large table?

Most definately.
Feel free to call me at (503)228-1400 ext 650 if you need more help.
From: cjackso@uswnvg.com (Clay Jackson)
Newsgroups: comp.databases.oracle
Subject: Re: SQL*NET: a server serves multiple ORACLE_HOME/ORACLE_SID?
Date: 25 Jan 93 22:11:00 GMT
Organization: U S WEST NewVector Group, Inc.
X-Newsreader: Tin 1.1 PL5

Jian Cai (jan@kowari.cpsg.com.au) wrote:
: Q: Does an ORACLE server serves requests from different ORACLE_HOME
:    and/or ORACLE_SID?
:    Assume on host A there are multiple sets of ORACLE_HOME/ORACLE_SID
:    and on host B there is one orasrv running. Will the server on B serves
:    clients on A? If not, how to get it work?

Your example is a bit different from (what I infer is) your question.  I'm not
sure how to answer your example, but, if your question was:
	Server(Host) A has two Oracle instances running (but one orasrv)
	Client B wants to access one of those instances 
Then the answer is a qualified "yes".   The ORACLE_SID from the client
determines which SID/ORACLE_HOME gets used (orasrv looks in /etc/oratab
(on Unix systems) to find the correct combination).  We do this all the 
time.   The caveat is that if you're gonna use only ONE orasrv, then
BOTH Oracle instances MUST be running THE SAME VERSION of the RDBMS
kernel, and must have been linked with the "correct" (ie the same)
SQL*NET drivers.  In such a case, there's really no point in having
two separate ORACLE_HOMEs, since all of the executables have to be
at the same rev anyway.

If you want to get REALLY wierd, it is possible to run more than one
version of the RDBMS (actually, it's not the kernel that gets you, it's
the versions of the SQL*NET drivers that are linked with the kernel, but
you should get the idea).  Here's what you need to do (all of this
assumes you're on a Unix box):
	1)  In /etc/services, you'll find a line that looks something like
	    orasrv          1525/tcp        tcp             # oracle
	    This specifies the PORT number that orasrv is going to use.
	    Add another line with a new port number, ala:
	    mysrv           1526/tcp        tcp             # new server
	    You may also have to hack your tcp startup files to enable 
	    this port, and your (Unix) kernel to support it.
	2)  Start a the second listener, from the Unix command line, like
	    so (note, this only works if you're using the TLI based
	    server products - the command will probably be a bit
	    different for socket based tcp):
	    TLI_SERVER=mysrv; export TLI_SERVER
	    tcptlictl start
	    This will start a second listener, on the port you specified
	    above.
	3)  To connect to the second listener, put the name of the server
	    in the connect string, like so:
	    connect scott/tiger@T:<hostname>,mysrv:<sid>
If you're unsure about any of this, you may want to contact Oracle
Support and/or your SysAdmins for further assistance.  As always, your
mileage may vary.

Good luck!


--
Clay Jackson - N7QNM
US WEST NewVector Group Inc
Bellevue, WA
cjackso@uswnvg.com
From: bartho@cc.und.ac.za (Ray Bartho)
Newsgroups: comp.databases.oracle
Subject: Oracle and Floating Point Processors
Date: 28 Jan 93 14:37:54 GMT
Organization: University Of Natal (Durban)
NNTP-Posting-Host: pc15.cc.und.ac.za

Many unix systems have the option of purchasing a Floating Point processor 
as an add-on to the normal processor board e.g. HP PA-RISC, 386 based 
systems, etc.

1. Does Oracle perform floating point calculations internally ?

2. Is Oracle designed to make use of floating point processors if they exist 
on the system ?

3. To what extent will this increase the performance of Oracle ?

----------------------------------------------------------------------
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: cj10@cus.cam.ac.uk (C.J. Jardine)
Subject: oraperl on Sun4
Organization: U of Cambridge, England
Date: Fri, 22 Jan 1993 10:48:30 GMT

I recently posted a query about building oraperl on a Sun4.

I rapidly received a helpful reply from tha author of oraperl
(Kevin Stock) which I can summarise as:

   1. Upgrade your perl
   2. Build a system V version of perl

I am stuck on (2). All attempts to build a perl using the
/usr/5... libraries result in a perl which memory faults very early
in the tests. I must have something obvious wrong with my configuration
but I can't see what it is.

I would be very grateful if anyone who has opaperl working on a 
Sun 4 could e-mail me a copy of the config.sh which was used
to build the uperl.o which was used to build oraperl.

"There's a hole in my bucket ..."
Newsgroups: comp.databases.oracle
From: kattner@cbnewsj.cb.att.com (sonja.kattner)
Subject: Pro*c and SVR4
Organization: AT&T
Date: Mon, 25 Jan 1993 22:12:24 GMT
Keywords: varchar warnings


I have a Pro*c question I'm hoping some one could help me with.

My group is in the process of moving off of our 3b2 (SVR 3.2) and onto a
Starserver-E (SVR4).   One difference (aside from speed) is that the
starserver complains about a lot of code that the 3b2 did not care about.

It seems that the Pro*c precomplier declares the array part of a varchar
as an unsigned char, but all the string functions expect a signed char.
So, the compiler puts out a warning message every time a string function
is used on the varchar.

It does compile and run, but we really don't want to have these messages
appear every time we compile.  Of course we could go back and cast all the
varchar arrays to signed char, but it's a lot of code to go through.

We were looking for a precompiler option but there doesn't seem to be one
that would resolve this problem.  Does anyone out there have any simplier
ideas on how to solve this?

We are using oracle version V6.0.33.1.2 and oracle precompiler
version 1.3.18.1.2

Thanks,

        --Sonja Kattner
From: sbchanin@ai.mit.edu (Steve Chanin)
Newsgroups: comp.databases.oracle
Subject: State of tools for Oracle7
Date: 21 Jan 93 10:15:53
Organization: MIT Artificial Intelligence Laboratory
Distribution: world
Reply-To: sbchanin@ai.mit.edu
NNTP-Posting-Host: raisin-nut.ai.mit.edu

To run oracle 7 on hp or sun, will I need new versions of Pro*C, OCI,
or ReportWriter?  I would think that Pro*C 1.4 and ReportWriter would
be capable of connecting to either an Oracle 6 or an Oracle 7
database, but I'm not sure.

Thanks for any info,
Steve
--
===============================================================================
DOMAIN: sbchanin@ai.mit.edu                                       Steven Chanin
Newsgroups: comp.databases.oracle
From: adn@kaija.spb.su (ADN communication group)
Subject: Q: Duplicate records
Organization: KAIJA-SOFT LTD., St. Petersburg, Russia
Date: Sat, 23 Jan 1993 12:45:13 GMT
X-Newsreader: Tin 1.1 PL4

Does anyone know how to remove duplicated records from existing
Oracle table? Records may not be duplicated in all fields.
--
Nick Maximov
St. Petersburg, Russia
Newsgroups: comp.databases.oracle
From: kuismin@ntc02.tele.nokia.fi
Subject: Spool & Trailing Blanks
Organization: Nokia Telecommunications.
Date: Mon, 25 Jan 1993 11:32:39 GMT


    My environment:
        * SunOS Release 4.1.3
        * Oracle SQL*Plus v.3.0.12.2.1
        * Oracle RDBMS    v.6.0.36.4.1
        * Oracle PL/SQL   v.1.0.35.1.1

    What is done?
        I'm spooling my query into a file with SQL*Plus's SPOOL command.

    What is the problem?
        1) Trailing blanks

        SQL*Plus uses LINESIZE setting and puts trailing blanks in the
        end of each line it spools.  I need to remove all these blanks!

        Can this be done by SQL*Plus?
        What unix commands could be used to do this?  I'm novice with unix.

        2) Unix to Dos convertion

        My final aim is to convert the spooled file, which in UNIX
        format, into DOS format.  That is, I need to put <CR><LF>
        instead of <LF> in the end of each line.

        Can this be done by SQL*Plus?
        What unix command could be used to do this? I'm novice with unix.

    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>

    Any help is appreciated!

    -Mikko Kuismin
From: fgreene@hayes.com
Newsgroups: comp.databases.oracle
Subject: Re: Q: Duplicate records
Date: 25 Jan 93 06:45:23 EDT
Organization: Hayes Microcomputer Products, Norcross, GA

In article <1993Jan23.124513.26942@kaija.spb.su>, adn@kaija.spb.su (ADN communication group) writes:
> Does anyone know how to remove duplicated records from existing
> Oracle table? Records may not be duplicated in all fields.
> --
> Nick Maximov
> St. Petersburg, Russia

CREATE TABLE TEMPORARY AS
SELECT DISTINCT * FROM YOUR_TABLE;

DROP TABLE YOUR_TABLE;

RENAME TEMPORARY TO YOUR_TABLE;

 ----------------------------------------------------------------------------
 |      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: ddruker@agsm.ucla.edu (Daniel Druker)
Subject: Re: Database files
Followup-To: sender
Organization: Anderson Graduate School of Management, UCLA
Distribution: usa
Date: 26 Jan 93 23:05:04 PST

In article <1894@rwja.umdnj.edu> holowczk@rwja.umdnj.edu (Richard Holowczak) writes:
>jbaker@moby.micro.umn.edu (Jeffrey J Baker) writes:
>
>>The company I work for has been thinking about moving their Oracle development
>>system from a RISC platform to one running OS/2.  I know that there will be no
>>problem reloading the existing forms, but what I am wondering about is whether
>>or not the existing database files (dbs*.dbf) can be copied directly over to
>>the new system.  Has anyone had experience with this procedure?  Are there other
>>problems with doing this that I am not taking into consideration?
>>Any suggestions would be much appreciated.
>
>>Jeff
>>jbaker@cs.umn.edu

They are definitely NOT compatible. Use export/import, which can create
and read portable files that include database schema and data.  

- 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.
From: rlarson@nswc-wo.nswc.navy.mil (Ruth Larson)
Newsgroups: comp.databases.oracle
Subject: Re: checking for full tablespaces
Date: 22 Jan 93 19:44:27 GMT
Organization: Naval Surface Warfare Center


>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


select sum(blocks),count(blocks), sum(bytes),tablespace_name
    from system.dba_free_space
    group by tablespace_name


This will give you the free space for all tablespaces.  The count(blocks)
will give you some idea of how fragmented it is.
From: taskon@ifi.uio.no (SI/TASKON)
Newsgroups: comp.databases.oracle
Subject: Window Enhanced Mode & Oracle OCI/Pro*C
Date: 21 Jan 93 14:29:33 GMT
Organization: Dept. of Informatics, University of Oslo, Norway
Originator: taskon@holmenkollen.ifi.uio.no

All OCI-calls seems to be working  when running Enhanced-Mode Windows, except

orlon and olon. I personally think this limits my access to the database.

Q: Which versions of Oracle OCIs works 100% in Enhanced Mode?

(The errors in the OCI-calls manifests itselves by overwriting callees
adress-space)

Oystein Gulbrandsen
TASKON A/S
oysteing@taskon.no
Newsgroups: comp.databases.oracle
Subject: Help needed with SQL*Menu5
From: ajmex@brt.deakin.edu.au
Date: 25 Jan 93 23:14:14 EST
Organization: Deakin University, Melbourne

I want to set a menu system using SQL*Menu V5, in which certain
forms can be called either normally or in query only mode. How is this
done? I can't seem to find an equivalent of "CALLQRY".

E-mail prefered; thanks in advance, Alister Miller.
Newsgroups: comp.databases.oracle
From: GO.MSB@isumvs.iastate.edu 
Subject: Re: ORACLE/SAS Interface
Organization: Iowa State University, Ames IA
Distribution: usa
Date: Fri, 22 Jan 1993 16:22:59 GMT

In article <1993Jan21.215151.21021@worldbank.org>,
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.
>
>Mark Esswein - messwein@nimbus.worldbank.org
>---------
>The opinions expressed herein are entirely my own and not to be confused
>with those of my employer...
----------------------------------------------------
SAS was supposedly working on an ORACLE interface.  It may be available;
not sure what your OS**T/ST**O is, but I think there primary platform
was VAX/VMS.  We were pushing for an MVS interface a few years back
and were told it didn't have a high enough priority.  Check with SAS
for your platform.

Marvin Beck    Iowa State University
From: rklute@enchanter.tymnet.com (Robert Klute)
Newsgroups: comp.databases.oracle
Subject: SQL Loader Question
Summary: How do you combine input fields?
Date: 22 Jan 93 17:50:37 GMT
Organization: BTNA

I am new to oracle.  I am trying to load a data base with
several LARGE flat files (> 200meg each).  Each record is
date and time stamped, but the date and time are disjoint.
  
  ... YYMMDD .... SSSSS ....

The records are fixed length, and the fields are fixed.  
There is data in between the two fields, that I need.

Any ideas on how to get these together into a single
database column? If need be I can hack a perl script to
do it, but I was hoping there was a way to do it inside
SQL Load.

Thanks.


They came for the 4th amendment, I said nothing for I wasn't a drug dealer. 
Then they came for the 2nd amendment, but I said nothing, I wasn't a gun owner.
Then they came for the 6th amendment, but I kept quiet, I knew I wasn't guilty.
Finally they came for the 1st amendment, and it was too late to say anything.