HDTenEightyP/NetNews huggingface dataset:
From: joefw@eosdev1.gsfc.nasa.gov (Joe Fulson-Woytek)
Subject: Getting out of Monitor
 
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: ALANB@OWGVM0.VNET.IBM.COM (Alan Beal)
Date: Thu, 12 Nov 92 07:21:32 EST
Newsgroups: comp.databases.oracle
Subject: Using char pointers with Pro*C
Organization: Federal Systems Company (IBM)

We are trying to use char * in SELECT INTO statements with Pro*C
(version 7.0.9) on an RS/6000.  We are getting segmentation faults
when we try to SELECT INTO more than one char *.  Are there any
gotchas that one must watch out for?  Also, the columns being
SELECTed are VARCHAR2 NOT NULL.  Does anyone have any examples
that work?  Is there a general rule of thumb on using CHAR arrays
with VARCHAR2 columns?  Thanks.

Alan Beal         alanb@owgvm0.vnet.ibm.com
                  (607)751-2026
From: sbrenner@cbnewsb.cb.att.com (scott.d.brenner)
Newsgroups: comp.databases.oracle
Subject: Can I Filter ORACLE Errors During Execution of SQL*Form (3.0)?
Date: 9 Nov 92 15:39:44 GMT
Organization: AT&T

I'm running SQL*Forms 3.0.16.4.1.  I'm creating applications for 
end-users who don't know anything about databases, let alone Oracle
specifically, or such things as "duplicate key in index" errors.
Does anyone know if there's a way I can "filter" Oracle system errors
during the running of a form?  What I'd like to do is capture an error
such as a duplicate key in index problem and present the user with a 
more friendly and meaningful message than 

	"FRM-40508: ORACLE error -- unable to INSERT record."

Even if the user could handle [Display Error], I don't think that

	"ORA-00001: duplicate key in index"

would mean much to them.

If anyone has any clue as to how I could do this, I'd really like to 
hear it.  Thanks in advance for your help.  Please respond via e-mail
to sbrenner@attmail.com; I'll post a summary of responses in a few days.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Scott D. Brenner
AT&T Consumer Communications Services
Basking Ridge, NJ
sbrenner@attmail.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Newsgroups: comp.databases.oracle
From: oliver@delphi (George Oliver)
Subject: Re: Running sqlforms30 in the openlook environment
Organization: San Diego State University, College of Sciences
X-Newsreader: TIN [version 1.1 PL6]
Distribution: usa
Date: Thu, 5 Nov 1992 17:26:04 GMT

VINAY GIDWANI (vkg1@Ra.MsState.Edu) wrote:
: I am using sqlforms30 on a Sun, using the command sqlforms30 -c sun:sun.
: Apparently I can also run sqlforms30 on the openlook environment and I 
: tried the following command
: 
: olsqlforms30 -c sun:sun.
: 
: forms30  did fire up, but the display at the bottom was kind of cut.
: I can access the menu, but when I open a form it is not visible.
: Again, the menu is visible and works fine. When I did a exit from the
: menu it worked fine. 
: 
: Is the command I am using correct, or is there a problem with oracle.
: 
: Vinay.
: 
: --
: 
: Vinay Gidwani
: email vkg1@ra.msstate.edu

You don't need the '-c sun:sun' specification.  That may be the problem.

Geo.
From: a2824cd@cd1.LRZ-Muenchen.DE
Newsgroups: comp.databases.oracle
Subject: Use of variables in "SELECT" Statements ???
Date: 10 Nov 92 11:13:22 GMT
Organization: Leibniz-Rechenzentrum, Muenchen (Germany)

Maybe somebody can help us with our problem...

We are two students, trying to create a sqlform30 application 
(also using SQL, PL/SQL and the other products that come with 
oracle V.6).  

We try to use variables in SELECT Statements like :

SELECT var1 INTO var2 FROM table WHERE ... 

var1 should be a variable for a column name, var2 should be just 
a variable, containing the result of the SELECT statement and table
should be a table name.

Our problem is now to get the value of var1.

What happens is, that the "name" and not the "value" of var1 is 
stored into var2.

Thanks for all your efforts..

Peggy and Peter.   
Newsgroups: comp.databases.oracle
From: andy@homebase.vistachrome.com (Andy Finkenstadt)
Subject: Re: View questions...
Reply-To: andy@homebase.vistachrome.com
Organization: Vista-Chrome Incorporated
Date: Fri, 6 Nov 1992 17:32:51 GMT

Views do not occupy database blocks and therefore do not occupy
extents or segments.  The resulting R-table (SELECTed rows and
internal queries) can occupy TEMPorary space in the database.

Temporary tablespace is allocated on a USER level, not a VIEW level.
You can change a user's temporary tablespace as thus:

   SQL> ALTER USER andy 
	 2> TEMPORARY TABLESPACE temp
     3> DEFAULT TABLESPACE largeone
     4> /

   User altered.
   
   SQL>

I do not recall if the user has to initiate a new connection for the
new settings to take place.  I am inclined to GUESS yes.  So, just
have them log out and back in.

If you know that you will be executing a LONG running query that
requires a good deal of ROLLBACK space in addition to TEMP space
(I don't remember the conditions under which temp doesn't use up
rollback entries), you can have a LARGE rollback segment in a
ROLL tablespace (hint hint) and then use this in version of Oracle
beyond 6.0.33 (pretty sure that's 33)

   SQL> commit;  /* end transaction which may have been in process */
   SQL> SET TRANSACTION USE ROLLBACK SEGMENT LARGE_RBS;
   SQL> select * from large_view ;
   SQL> commit;  /* release rollback */

Hope that helps.

-Andy

un@gdstech.GRUMMAN.COM (Un Fu) writes:
>How can I get the block usage of a view I created?  Looked
>into "user_extents" and it only displays block usages of tables.
>
>Also how do I direct the creation of a view or several views to use
>a temporary, TEMP_TS, tablespace.  I see one can specify which
>tablespace to create a table at, but not on the 'CREATE VIEW' command.
>
>I have been asking lots of question lately and this newsgroup has been
>tremendously responsive.  THANK YOU ALL, FOLKS!

-- 
Andrew Finkenstadt, Vista-Chrome, Inc., Homes & Land Publishing Corporation
GEnie Unix RoundTable Manager, andy@vistachrome.com, andy@genie.geis.com.
  Send mail to ora-request@vistachrome.com to join Unix, CASE, and 
  Desktop Oracle RDBMS Database discussions.
Organization: University Of Toronto Computing Services.
Date: Monday, 9 Nov 1992 18:52:41 EST
From: Mark Acfield <AC@vm.utcs.utoronto.ca>
Newsgroups: comp.databases.oracle
Subject: textual query

We are interested in building a database application using Oracle if
possible.  The application may in fact consist of only a single table
but the tricky part is that some of the fields will consist of
freeform text (as much as 10 pages) amd we wish to be able to
query the database to find all records that contain some particular
word, phrase or perhaps combination of words.  We were wondering
if anyone sells a oracle based add-on package that does this sort
of thing.  We have just heard of SQL*TextRetrieval from Oracle
but don't yet know too much about it.  Has anyone had any experience
with this sort of problem?  Any suggestions?  Thanks in advance.

Mark Acfield - ac@vm.utcs.utoronto.ca
University of Toronto Computing and Communications
Technology Support
Newsgroups: comp.databases.oracle
From: pkm1@Ra.MsState.Edu (Praveen Mereddy)
Subject: HELP - SQLReports on SUN
Organization: Mississippi State University
Date: Wed, 11 Nov 1992 08:17:07 GMT

Hi netters,

I am working on SQLReportWriter1.1   on SUN    

I am not able to invoke a report from the command line.  I am using the folowing command.

runrep term=srw_sun report=DIAL_STATE_PROPERTY userid=pkm1/pkm1 paraform=no TYPE='S'

My Query follows......

SELECT ITEM.ITEMID, ITEM.EQUIPID, ITEM.PROJID, ITEM.EMPID, ITEM.CONDITION
 FROM ITEM, ITEM_PROPNUMBER 
WHERE ITEM.ITEMID = ITEM_PROPNUMBER.ITEMID
AND ITEM_PROPNUMBER.PROPTYPE = '&TYPE'
ORDER BY ITEM.ITEMID 



I have created a parameter in the parameter menu as follows

 Parameter Name   | Type | Width | Default Value    | Label Input Format     
 TYPE             | CHAR |  1    |                  | Type 


I am able to create the form with above command line COMMAND but it not doing any
query.


Is my commandline command correct.??

I appreciate ur HELP.

Thanks
Praveen
.
From: fragante@unixg.ubc.ca (Gv Fragante)
Newsgroups: comp.databases.oracle
Subject: Re: SQL*REP - conditional printing of page header
Date: 11 Nov 92 01:08:50 GMT
Organization: The University of British Columbia
NNTP-Posting-Host: unixg.ubc.ca

In <fragante.721088791@unixg.ubc.ca> fragante@unixg.ubc.ca (Gv Fragante) writes:

>How can I make the page header of a report print conditionally ? In my
>application, I have to make a report that does not print the page number on
>the first page, but does so on all succeeding pages (ie. pages > 1).

>Thanks.

I got a reply from a fellow and he came up with a very workable solution.

In essence, you have to define a field and assign it as it's source:

   &SQL Select decode(&Page,1,NULL,&Page) Into :Page_No From Dual

The decode function provides the conditional test whether it is the first page
or not.

Hope this helps others.
From: kverruyt@nl.oracle.com (Kees Verruyt)
Newsgroups: comp.databases.oracle
Subject: Re: View questions...
Date: 6 Nov 92 09:31:02 GMT
Organization: Oracle Europe

In article <UN.92Nov5120254@gdstech.GRUMMAN.COM>, un@gdstech.GRUMMAN.COM (Un Fu) writes:
|> How can I get the block usage of a view I created?  Looked
|> into "user_extents" and it only displays block usages of tables.

As their name implies, VIEWs don't use space. They retrieve their data from the
underlying table.

|> 
|> Also how do I direct the creation of a view or several views to use
|> a temporary, TEMP_TS, tablespace.  I see one can specify which
|> tablespace to create a table at, but not on the 'CREATE VIEW' command.

Again, selecting from a view is just the same as selecting from the underlying
tables. The data is only stored in the tables.

The only thing that I can think of is that your view-definition joins tables which
do not have indexes. In that case the server will have to do a sort-merge scan
which can result in temporary tables. These are assigned to the TEMPORARY
TABLESPACE for that user. If you haven't defined that for the user, that will
be SYSTEM.

So it's very wise to create a separate tablespace (fi. TEMP) and then execute
for every user in your system:

ALTER USER ... TEMPORARY TABLESPACE TEMP;

(This will prevent repeated allocation & deallocation of small extents in
 your 'data-tablespaces'. In the temporary tablespace that cannot do harm since
 all temporary tables are deallocated when they are no longer needed, thus
 ensuring that the free extents are contiguous and can be coalesced into larger
 ones.)

|> 
|> I have been asking lots of question lately and this newsgroup has been
|> tremendously responsive.  THANK YOU ALL, FOLKS!
|> --
|> ****************************************************************************
|> Un Un Fu                                    Internet: un@gdstech.grumman.com
|> Disclaimer: I am solely responsible for what I am saying here!
|> ****************************************************************************
|> -- 
|> ****************************************************************************
|> Un Un Fu                                    Internet: un@gdstech.grumman.com
|> Disclaimer: I am solely responsible for what I am saying here!
|> ****************************************************************************

You're welcome.

-- 
EXEC SQL INCLUDE STD_DISCLAIMER; -- My views, not Oracle's.
------------------------------------------------------------------------
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
Newsgroups: comp.databases.oracle
From: mmwang@adobe.com (Michael Wang)
Subject: Re: HELP! - Corrupted EXPort file
Organization: Adobe Systems Incorporated
Date: Mon, 9 Nov 1992 20:13:34 GMT

In article <17204@mindlink.bc.ca> Bruce_MacDonald@mindlink.bc.ca (Bruce MacDonald) writes:
>
>I have just run into a problem that Oracle support has been unable to help
>me resolve:
>
>An export file was created using RDBMS 5.1.22, and subsequently copied
>to tape.  Now when we try to import the file, we get a "Required
>character set conversion not supported" immediately after specifying the
>filename.
>
>I tried importing into a V. 6 database with the same result (IMP-00016 is
>the error message).
>
>The system is VAX/VMS 5.4-3.  The structure of the dump file is fixed format,
>4096 byte records which is as it should be.
>
>Needless to say, we would REALLY like to get this data back.  Any suggestions
>would be greatly appreciated!

Well, it has been a while, but if I recall correctly, this message
will come up if the "end of record" marker gets corrupted or sometimes
if there is a version number mismatch (very rare). The end of record
marker is a 0D, I believe, and sometimes what happens is that it gets
converted to something else during the transfer process. Typically
this happens when you transfer the export file to another platform and
don't specify a binary file transfer. I'm not sure what tools there
are under VMS for viewing the hex contents of a file, but what you
should do is create a new export file and take a look at it. If your
viewer can display hex and the ASCII equivalent side by side, you
should be able to tell very quickly what the end of record marker
should be. Then view the corrupted file and see if it is different. If
so, then you are going to have to convert them back somehow.

-- 
Michael Wang
mmwang@mv.us.adobe.com
From: russa@carson.u.washington.edu (E.Russell Alexander)
Newsgroups: comp.databases.oracle
Subject: Oracle Developer Position
Date: 10 Nov 92 16:14:25 GMT
Article-I.D.: u.1992Nov10.161425.26143
Distribution: pnw
Organization: University of Washington, Seattle

Full-time position available for database pro with experience in administering Oracle (or related SQL) DBMS and in producing 3GL/4GL end-user interfaces.  Salary $3,000-$3,400 per month DOE. Experience in health care settings a plus.

Letter and resume (ASAP, closes 11/16) to:

	Dr. Ward Hinds
	Snohomish Health District 
	3020 Rucker Ave, Suite 300
	Everett, WA 98201
Newsgroups: comp.databases.oracle
From: sieh@csn.org (David Sieh)
Subject: Case Studies of Distributed Databases in Oracle
Organization: University of Colorado, Boulder
Date: Thu, 12 Nov 1992 03:49:00 GMT


We are starting a project in which we must make a set of databases
available to users over a wide area network...
We are looking for help/advice in designs/implementations of
similar database systems...We are especially interested in case studies.

We are curious about designs/implementations of different architectures
such as:
1. Centralized database servers that users log into to run their
   applications...
2. Truly distributed databases...i.e. data distributed amoung several
   database severs with no redundant data....has the appearance of
   a single database....
3. Distributed databases with redundant data stored at some sites...
   ...strategies for keeping databases consistent and strategies
   for updating each db...
4. Other????

To give a few more specific characteristics of the system we are
working with:

* We will probably be using Oracle
* A wide area network is already installed 
* All machines over the network "talk" TCP/IP
* There is a near real-time data collection/distribution component
   (i.e. data collected about once an hour needs to be made 
    available to users over the network)
* Most of the data queries need to be through interactive
  data communications...i.e. not batch transfer of files or
  media transfer...

Responses sent directly to me would be greatly appreciated...
(unless you feel this would be of interest to other readers in
this news group)

Thanks -

David Sieh
sieh@cadswes.colorado.edu

Newsgroups: comp.databases.oracle
From: sbrenner@cbnewsb.cb.att.com (scott.d.brenner)
Subject: Anyone Else Having Major Problems with SQL*Menu Core Dumping?
Organization: AT&T
Date: Thu, 5 Nov 1992 16:56:35 GMT

I'm running SQL*Menu 5.0.11.3.1 on a 386 box with Interactive UNIX
System 5, Release 4.0, Version 3.0.  My RDBMS is 6.0.33.1.2.  I'm
having a lot of problems with sql*menu core dumping.  The main problem
is that runmenu50 core dumps when I hit the [Exit] key (I'm running
a vt100 emulation and have no problems with SQL*Forms).  It also dumps
if I hit the [Application Menu] key.

The technical support people seem to be clueless.  They just keep 
chanting their mantra "you should upgrade."  I'm getting a little
tired of this attitude of dealing with buggy versions of their products
by telling their customers just to upgrade.  It's often inconvenient,
difficult, or impossible for us to upgrade.  Many times installing a
newer version of something to solve one problem introduces five new
problems.

Has anyone else run into difficulties with SQL*Menu?  If so, do you
have any hints or tips that would be useful?  

While I'm waiting (over a day, now) for Oracle technical support to
figure out what's wrong, I'm turning to the net for help.  People here
often seem to know their products and problems better than Oracle
does.

a T d H v A a N n K c S e

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Scott D. Brenner
AT&T Consumer Communications Services
Basking Ridge, NJ
sbrenner@attmail.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: normi@hugo.uucp (Norman Dutton)
Subject: Sybase to Oracle v7 conversion tools wanted
Organization: D&M Associates, Annandale
Distribution: na
Date: Thu, 12 Nov 1992 16:12:01 GMT

I have a client that needs to port a large number of Sybase stored
procedures, triggers, table definitions, and other Sybase specific
stuff to Oracle. I understand that version 7 has some of these 
facilities.  Does anyone know of any tools that can help in the
conversion?

Thanks in advance for any assistance you can give in this area.
-- 
Norman Dutton;                  | uucp:    uunet!hugo!normi
D & M Associates                | Internet: hugo!normi@uunet.uu.net
4208 Evergreen Lane, Suite 213  | Voice: 1.703.941.7526 or 1.703.777.5677
Annandale, VA 22003             |
From: prg4752@hertz.njit.edu (Padmanabha R. Guddeti)
Newsgroups: comp.databases.oracle
Subject: Can anybody mail me the Oracle 7 features..
Date: 11 Nov 92 15:31:25 GMT
Organization: New Jersey Institute of Technology, Newark, N.J.
Originator: prg4752@hertz.njit.edu

Hi There,

	Will anybody mail me the oracle7 features over oracle6.
		
	Thanks in advance.

Padmanabha R. Guddeti

EMail : prg4752@hertz.njit.edu
-- 
Padmanabha R. Guddeti   		|  WITH BEST COMPLIMENTS
381 Broad Street APT#703A		| EMail: prg4752@hertz.njit.edu
Newark  NJ07104				| TEL# (201) 483-1186
------------------------------------------------------------------------------
Newsgroups: comp.databases.oracle
From: leh@harvey.lrs.e-technik.uni-erlangen.de (Gunther Lehmann)
Subject: How to avoid confirming error messages in Forms under Motif????
Keywords: Oracle sqlforms Motif
Organization: LRS
Date: Thu, 12 Nov 1992 17:29:07 GMT

Hi,

I am running an Oracle-Forms (sqlforms30) application on an Ultrix-DEC-station.
When I use the character-mode display, all error messages are written out to
the bottom line of the window, but need no confirmation.
Compared to this, using the bitmap-display (Motif, msqlforms30), every
error message is displayed in an extra window and has to be confirmed.
My question is:
    Is it possible to avoid the confirmation of each error message
    in the bitmap environment?
    I like to have an simple information equal to the character mode.
Suppressing the error messages with a filter function, provided by Forms,
doesn't work because most of the messages are of the highest severity level.
This level can't be supressed.

Thanks in advance for your kind advices

G. Lehmann

e-mail: leh@lrs.e-technik.uni-erlangen.de


Newsgroups: comp.databases.oracle
From: andy@homebase.vistachrome.com (Andy Finkenstadt)
Subject: Re: Anyone Else Having Major Problems with SQL*Menu Core Dumping?
Reply-To: andy@homebase.vistachrome.com
Organization: Vista-Chrome Incorporated
Date: Fri, 6 Nov 1992 17:11:05 GMT

Known problem if only you talk to the UNIX people, not the TOOLS
people.  Go into the makefile for sqlmenu5 ($ORACLE_HOME/menu5/lib)

-rw-r--r--   1 oracle   dba        10196 Oct 30 14:14 sqlmenu5.mk

and find the line that contains "-lmalloc".  REMOVE just the "-lmalloc"
part leaving behind the remainder of the libraries specified.  Now 
relink and install Sql*Menu 5.0 by running (as user oracle) "update install"
  $ cd $ORACLE_HOME/install
  $ oracle.install menu5

Have everyone quit from sqlmenu50/runmenu50 before this, though,
and make sure you have about 15 megabytes free where /usr/oracle lives.

-andy


sbrenner@cbnewsb.cb.att.com (scott.d.brenner) writes:
>I'm running SQL*Menu 5.0.11.3.1 on a 386 box with Interactive UNIX
>System 5, Release 4.0, Version 3.0.  My RDBMS is 6.0.33.1.2.  I'm
>having a lot of problems with sql*menu core dumping.  The main problem
>is that runmenu50 core dumps when I hit the [Exit] key (I'm running
>a vt100 emulation and have no problems with SQL*Forms).  It also dumps
>if I hit the [Application Menu] key.
>
>The technical support people seem to be clueless.  They just keep 
>chanting their mantra "you should upgrade."  I'm getting a little
>tired of this attitude of dealing with buggy versions of their products
>by telling their customers just to upgrade.  It's often inconvenient,
>difficult, or impossible for us to upgrade.  Many times installing a
>newer version of something to solve one problem introduces five new
>problems.
>
>Has anyone else run into difficulties with SQL*Menu?  If so, do you
>have any hints or tips that would be useful?  
>
>While I'm waiting (over a day, now) for Oracle technical support to
>figure out what's wrong, I'm turning to the net for help.  People here
>often seem to know their products and problems better than Oracle
>does.
>
-- 
Andrew Finkenstadt, Vista-Chrome, Inc., Homes & Land Publishing Corporation
GEnie Unix RoundTable Manager, andy@vistachrome.com, andy@genie.geis.com.
  Send mail to ora-request@vistachrome.com to join Unix, CASE, and 
  Desktop Oracle RDBMS Database discussions.
Newsgroups: comp.databases.oracle
From: sjs@netcom.com (Stephen Schow)
Subject: Re: How to enhance the forms?
Organization: Netcom - Online Communication Services  (408 241-9760 guest) 
Date: Thu, 5 Nov 1992 18:39:40 GMT

Better yet, use the ON-NEW-FIELD-INSTANCE.  When you move to 4.0 and/or
GUI environments, the KEY-nxtfld trigger is not desireable.
-- 
------------------------------------------------------------------
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
------------------------------------------------------------------