HDTenEightyP/NetNews huggingface dataset:
Newsgroups: comp.databases.oracle
From: dcriswel@oracle.uucp (David Criswell)
Subject: Re: Oracle V6.0 and Borland C++ 3.0 ???
Organization: Oracle Corporation, Redwood Shores CA
Distribution: usa
Date: Fri, 24 Jul 1992 20:23:41 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 <1992Jul23.133752.4755@news.weeg.uiowa.edu>,
pkoch@news.weeg.uiowa.edu (Peter F Koch) writes:
>I bought Borland C++ V3.0 recently.  I will soon be getting Oracle V6.0
>for MS-DOS and want to develop Windows database applications. Does Oracle
>support Borland C++ or do I have to use Microsoft's compiler?
>
>===========================================================================
>Peter Koch                                              Phone: 708-534-5200
>Weston Gulf Coast Labs                     email:pkoch@umaxc.weeg.uiowa.edu
>2417 Bond St.
>University Park, IL 60466
>===========================================================================
---------------------------
If anyone's keeping a FAQ for this group, this one's a biggie ...

This is not documented nor supported by Oracle, however, Borland C++ will 
work to create Windows applications. It will NOT work for either protected 
or real mode MSDOS applications. Precompile and compile your application in
the normal way and then at link time, add the SQL13WIN import library to 
the link step. For Windows OCI programs, add ORA6WIN.LIB at link time.

I don't speak for my employer, obviously.
Newsgroups: comp.databases.oracle
From: kjou@us.oracle.com (Kathy Jou)
Subject: Re: Oracle Backup
Organization: Oracle Corporation, Redwood Shores CA 94065
Date: Wed, 22 Jul 1992 18:27:10 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 <45406@shamash.cdc.com> ldh@svl.cdc.com (Lawrence D. Hare) writes:
>Given that most of us live on the edge of total neurosis due to the
>pressures of backup, I have been elected to look into the problems of
>database backup and Oracle in particular. To this end I have a few
>questions:
>
>1) How do you back up Oracle databases today?
>
>2) What can be done to make it better?
>
>3) What is the ideal solution?
>
>All help is appreciated.
>--
>Lawrence D. Hare       Control Data - Silicon Valley Operations
>Consultant             Voice: (408) 496 4339 - C/N [234] 4339
>ldh@svl.cdc.com        Mail: SVLa60  FAX: (408) 496-4106

Chapter 15, Backup and Recovery, of the DBA Guide will introduce you to 
different types of backups: export, cold backup (database shutdown), and hot
backup (database running, tablespace in backup mode).  The type of backup to
use depends on the availability of the database.  If this is a 24 hour shop,
then hot backups make the most sense.  If the database is not used at night,
then nightly exports or cold backups are reasonable.  A cold or hot backup 
involves physically copying the Oracle datafiles (control and log files also) 
to another location (tape or spare disk).  On UNIX systems, DBAs often tar or
cpio the files to tape.  Other systems have utilities that may be used to
backup files on the machine to tape or another directory.

Backup strategies should be very carefully thought out and thoroughly tested
because it could make life much easier when a database recovery must be 
performed.  There is no ideal solution to backups.  You will need to determine 
a solution/stategy that will be the most beneficial to your company.


Kathy Jou
Oracle Corporation

Newsgroups: comp.databases.oracle
From: Devan F. Dewey <dewey@centerline.com>
Subject: Re: Referencing a SEQUENCE from a trigger...
Organization: CenterLine Software
X-Useragent: Nuntius v1.1a2
Date: Tue, 21 Jul 1992 12:12:27 GMT



>I've got a situation where I need to insert rows into a table in a 
>ON-VALIDATE-FIELD trigger. For these rows, I need a serial no which I'm
>getting from a SEQUENCE. However, I can't seem to reference the SEQUENCE.
>I'm doing something like:
>
>  new_ref := :SEQUENCE.V_REF_NO_SEQ.NEXTVAL;
>
>which gets me the error messages:
>
>  PL/SQL error 49 at line 10, column 16:
>     bad bind variable 'sequence.v_ref_no_seq'

Form V3 I hope.

To reference a sequence, you must use select into:

select SEQUENCE.V_REF_NO_SEQ.NEXTVAL into new_ref from dual;

Hope this helps.

-Devan
Newsgroups: comp.databases.oracle
From:  "Nick Maximov" <nick@spbgtw.pczz.msk.su>
Distribution: world
Subject: Auto startup Oracle in /etc/rc.d/ problems...
Organization: Lentechno
Date: Sat, 18 Jul 92 19:46:56 GMT
Reply-To: nick@spbgtw.pczz.msk.su


	Hi, fellows!

	Does know anyone what should I do to install starter and killer
in /etc/rc.d/? When Unix is coming up, starter tries to start Oracle
up by issuring "dbstart". It step is failed. SQLDBA put out:

	"Error recursive SQL level 1"
	"sfofi: file size limit was exceeded"
 
I try to increase ULIMIT, but there is no changes I have been got.

					Thanks in advance.
--
Nick Maximov
St.-Petersburg, Russia.
Newsgroups: comp.databases.oracle
From: lwv26@cas.org (Larry W. Virden)
Subject: FAQ?  Defining a query page against multiple field/multiple table
Reply-To: lvirden@cas.org (Larry W. Virden)
Organization: Nedriv Software and Shoe Shiners, Uninc.
Date: Tue, 28 Jul 1992 13:19:34 GMT


1. I have never seen a comprehensive FAQ posted to this group - is one
available?

2. Assume a situation like this (not my specific, but this hopefully
will serve to illustrate):

Application - Sql Forms 3.0 based time card entry.

Page consists of 3 blocks, each against a different table.

Block 1:	
	Name	Employee number
	Department	(Current Date - a non-table field)

Block 2:
	Multiple occurances of:

	Activity description	Number of hours this week.

Block 3:
	A column of total hours to date for each of the above activities.

Goal, not only to permit entry of the above information, but to allow
the user to query against any combination of Name, Employee number, 
Activity description and total hours. 

Where does one start to permit the above query?  The problem is that I do NOT
want to say things like "search for either what the user keyed or %" for
each of the fields.  The reason is that it just takes too long for the
query to work.

I would also rather not, if I can find a way around it, write 
a series of 24 if statements based on each possible combination of fields
being filled in.

Any good ideas?
-- 
Larry W. Virden			UUCP: osu-cis!chemabs!lvirden
Same Mbox: BITNET: lvirden@cas  INET: lvirden@cas.org
Personal: 674 Falls Place,   Reynoldsburg, OH 43068-1614
America Online: lvirden@aol.com
Newsgroups: comp.databases.oracle
From: kuppswmy@grouper5.Berkeley.EDU (Rajesh Kuppuswamy)
Subject: Re: Oracle Backup
Reply-To: kuppswmy@grouper5.Berkeley.EDU (Rajesh Kuppuswamy)
Organization: Motorola Inc., Cellular Infrastructure Group
Date: Tue, 21 Jul 1992 14:34:51 GMT

In article <45406@shamash.cdc.com>, ldh@svl.cdc.com (Lawrence D. Hare) writes:
|> Given that most of us live on the edge of total neurosis due to the
|> pressures of backup, I have been elected to look into the problems of
|> database backup and Oracle in particular. To this end I have a few
|> questions:
|> 
|> 1) How do you back up Oracle databases today?
Oracle backups are usually done using using exports of the database.
you could also take copies of the database file using the operating system.
which will basically be a fast backup.

 
|> 3) What is the ideal solution?
 We can have a background process in oracle which will moniter the state of the database and take backups automatiocally based on laod parameters which one could feed in.

|> All help is appreciated.
|> --
|> Lawrence D. Hare       Control Data - Silicon Valley Operations
|> Consultant             Voice: (408) 496 4339 - C/N [234] 4339
|> ldh@svl.cdc.com        Mail: SVLa60  FAX: (408) 496-4106goose [7]%





--Rajesh


Rajesh Kuppuswamy                        | Phone:  +1 708-632-5284
Software Engineering Group (SEG)         | Fax:    +1 708-632-3113
Mail Drop:  IL27-3227 AR                 | userid: kuppswmy

Rajesh Kuppuswamy                        
University of Arizona, Dept of Computer  Science 
userid: krajesh@cs.arizona.edu 

---------------------------------------------------------
If you love something,set it free.
If it comes back, it is yours.
If it does not,it never was. 
---------------------------------------------------------


 
Newsgroups: comp.databases.oracle
From: fragante@unixg.ubc.ca (Gv Fragante)
Subject: SQL*Reportwriter last page eject
Organization: University of British Columbia, Vancouver, B.C., Canada
Date: Mon, 27 Jul 1992 19:04:52 GMT

Our SQL*Report always prints a blank last page on every report. How can we
get rid of this ?

Thanks.
From: kortikar@mipos2.intel.com
Newsgroups: comp.databases.oracle
Subject: Problems in numeric fields. Possible SQL*FORMS 3.0 bug ?
Date: 30 Jul 92 21:16:27 GMT
Reply-To: kortikar@mipos2.intel.com ()
Organization: Microprocessor Component Group, Intel Corp., Santa Clara, CA

I am using SQL*FORMS 3.0.16.8.1 on AT&T unix. consider a default form 

If in a field of num(6,2) I enter value of 0.343434  and press commmit key.
then I change any field in the record again then forms will give the message
'Record changed by another user.' message.

If I enter value with precision with 2 digits then everything works OK.
the reason for bug appears to be -forms compares the value in its
temporary workspace with value in database and since they do not tally 
(becuaes temporary workspace has entire number and database image has rounded
number ) gives the message that 'record changed by another user' Would some 
Oracle personnel clarify this.

Aniruddha Kortikar (kortikar@mipos2.intel.com)
Newsgroups: comp.databases.oracle
From: vkg2@Flute.CC.MsState.Edu (Vinay Khushi Gidwani)
Subject: openwindows
Keywords: oracle under openwindows
Organization: Mississippi State University
Distribution: usa
Date: Wed, 22 Jul 1992 03:49:01 GMT

my email address is vkg2@ra.msstate.edu
 


Newsgroups: comp.databases.oracle
From:  "Nick Maximov" <nick@spbgtw.pczz.msk.su>
Subject: Re: CREATE TABLE not acting the way I think it should
Organization: Lentechno
Date: Tue, 14 Jul 1992 09:28:52
Distribution: world
Reply-To: nick@spbgtw.pczz.msk.su


	In article <ebd@fang.att.com> writes:

>I am using Oracle 6.0.33.1.2 on SVR4 on a 386 PC. What I want to is to create
>a table specifying 'user.tablename'. I have tried this as SYS & SYSTEM and
>other DBA accounts and it tells me 'no resource permission'. Can you create a
>table to be owned by another user, or am I missing something. I have been
>unable to glean any clues from the manual. Any ideas appreciated!
>
>EBD
>-- 
	Howdy,

	I have not troubles with creating tables using foreign accounts
when I have DBA rights. Therefore, I need more detailed information to
help you. 
	Please pass following and send me direct result letter:
1. Perform the query
	   SELECT USER#, NAME, CONNECT$, DBA$, RESOURCE$
	   FROM SYS.USER$
	   WHERE NAME = 'SYS' OR NAME = 'SYSTEM';
2. Look at CONNECT$, DBA$ and RESOURCE$ columns that must contain
   value 1 (num).
3. If not so, regratee the sys and system users by 
		REVOKE CONNECT, RESOURCE, DBA FROM SYS;
		GRANT CONNECT, RESOURCE, DBA ON SYS IDENTIFIED BY <passwd>;
	and so on for system if need.
4. If couldn't create table yet, please select DATATS# and TEMPTS# and
   look at number tablespeces to define proper rights.

	When you pass these steps and trouble not solved, send a
	direct letter.
				Regards, Nick - Oracle system admin.

--
Nick Maximov, St. Petersburg, Russia.
Newsgroups: comp.databases.oracle
From: dewey@centerline.com (Devan F. Dewey)
Subject: Re: SQL*Reportwriter last page eject
Followup-To: comp.databases.oracle
Organization: CenterLine Software, Inc.
Date: Mon, 27 Jul 1992 19:55:48 GMT

In article <fragante.712263892@unixg.ubc.ca>, fragante@unixg.ubc.ca (Gv
Fragante) wrote:
> 
> Our SQL*Report always prints a blank last page on every report. How can we
> get rid of this ?
> 
> Thanks.

Make SURE this answer gets to the net!!! I feel like we kill about 18 trees
a day due to this little gremlin.



                             
               Devan F. Dewey | Senior Systems Analyst
          CenterLine Software | dewey@centerline.com
            10 Fawcett Street | "Leme esplain - no dere is
          Cambridge, MA 02138 | too much. Leme sum up."
                                       -Inigo Montoya
From: fams09@v7.vitro.com
Newsgroups: comp.databases.oracle
Subject: Re: Forms3 ERR - unable to INSERT record
Date: 23 Jul 92 08:13:36 -0500
Followup-To: comp.databases.oracle
Keywords: forms 3.0
Organization: Vitro Corporation

In article <dewey-220792114200@sebastian.centerline.com>, dewey@centerline.com (Devan F. Dewey) writes:
> In article <1992Jul22.105329.244@falcon.navsses.navy.mil>,
> huynh@falcon.navsses.navy.mil wrote:
>> 
>> For every execution, after hitting the commit key, I keep getting the error:
>> FRM 40508 : ORACLE ERROR -- unable to INSERT record
>>
>> Any suggestions would be appreciated.  Many thanks.
> 
> You cannot use Forms to insert or update data in a view. Forms acutally
> uses the rowid field when performing these tasks and there is no rowid
> field for a view. Views are only useful for query only blocks.
> 
> You are going to have to break up the blocks so that the block you which to
> insert from has a base table which is a true table, not a view.

or use the on-insert/on-update triggers to accomplish the same.  refer
to the Oracle document "Advanced SQL*Forms Techniques Version 3.0".  Chapter 6
has a section titled "Committing Data through a Join View"  -- sounds exactly
like what you want to do.  Bon chance.

Woody Chin
UVa.
From: grant@reg.triumf.ca (Peter A. Grant)
Newsgroups: comp.databases.oracle
Subject: When if ORACLE V7 really going to come out?
Date: 22 Jul 92 18:49:00 GMT
Organization: TRIUMF: Tri-University Meson Facility
News-Software: VAX/VMS VNEWS 1.41

When if ORACLE V7 really going to come out?  I saw the announcement about
the developers' version being released, and had previously heard that V7
would come out in July.  

We were just checking into V7 courses with our local Oracle office and they
said that these would run once it was really out - late September or early
October.

Guess it means I won't buy support for a couple more months as there is 
nothing to upgrade to, yet.

Perhaps they're just going to wait until IOUW - maybe they'll hand out 
CDs with it on them to save all of those shipping costs ;-).

Peter Grant
1992 Chairperson
Vancouver Oracle Users Group 
grant@reg.triumf.ca
From: littlec1@jaguar.uofs.edu (Chris Little)
Newsgroups: comp.databases.oracle
Subject: Re: DB file not in DBA_DATA_FILES - problem
Date: 24 Jul 92 19:40:17 GMT
Followup-To: kjou@oracle.com
Organization: University of Scranton

> I would venture to guess that something is inconsistent in the data dictionary.
> If it is at all possible, then the safest action is to recreate the tablespace 
> from an export of the objects that currently reside in it.  Does the control 
> file still recognize this datafile?

No.  I did a dump of the control file to determine that.

> How did you determine that DBWR is 
> accessing that datafile which was not successfully added?

On VMS I did a $ SHOW DEVICE/FILE {device-name}, 
where {device-name} is the name of the disk on which the database files reside.
This command tells what files are being accesses and by what processes.

> Did you perform
> the add datafile operation again, using the same datafile name?

Yes, but I got an error saying that that filename already was being used
by the database.

>If the 
> control file and dba_data_files match, then things should be OK.

This indeed is the case.  I shut down the instance and brought it back up again.
This eliminated the DBWR process that was accessing the file, so I was then
able to delete the file.  I wonder what would have happened if I just killed
that process at the VMS level, without shutting down the instance.

> Kathy Jou
> Oracle Corporation
-- 

Thank you, Kathy.

--
Chris Little, Programmer/DBA
                                                University Computing Systems
                                                University of Scranton
  LITTLEC1@JAGUAR.UOFS.EDU                      Scranton, PA 18510
From: pat@cs.uow.edu.au (Pattarasinee Bhattarakosol)
Newsgroups: comp.databases.oracle
Subject: update_time
Summary: How to get the updated time of a table in oracle DB.?
Keywords: update
Date: 30 Jul 92 01:45:19 GMT
Organization: Dept of Computer Science, Wollongong University, Australia

Hello anybody out there,
I am a student in Wollongong and I have a question that I don't know.
I would like to know that How can I get the updated time of a table 
in the Oracle database(version 6..?).  The porblem is that this DB is
not belong to the user but the program of this user has to know the 
last updated time of the used table.

Please mail the answer to me by pat@cs.uow.edu.au., because I don't 
come to read network news everyday.
Thank you for your advice.


pat
Newsgroups: comp.databases
From: thompson@titan.trl.OZ.AU (David Thompson)
Subject: Re: Q&A
Organization: Telecom Research Labs, Melbourne, Australia
Date: Wed, 22 Jul 1992 03:06:35 GMT

Jim_Sollows@mindlink.bc.ca (Jim Sollows) writes:

>Has anybody used Q&A by Symantic. I hear it is quite powerful but very easy to
>use. I have been using dBase for many years but need to find a simpler system
>for a small business. How does it compare to dBase IV? Any comments?

Go to Clipper 5 similar to dbase3 and 4 , hasn't got some of the fancy
functions of db4 but heaps of libraries( 2nd source) around, its also
compiled and faster than dbase. 

Dave T.
From: fscll@acad3.alaska.edu (Christopher Lee Lott -- One foot in the grave and the other slipping)
Newsgroups: comp.databases
Subject: FoxPro questions, 2 easy, 1 harder.. : )
Date: 25 Jul 92 23:43:12 GMT
Organization: University of Alaska Fairbanks

I am just learning to program with FoxPro 2.0  (never done anything with
databases before) and I had a couple of questions:

1) Is there anyway to check for duplicate records using asingle field as the
key that is as easy as marking the field a key when you create it (I am told
you can do this in paradox)? I am trying to avoid having to scan the whole
database as I enter each record...

2) Is there any way to avoid blank lines when doing mailing labels and having
an empty field sometimes?

3) Is there a way to transfer a data set from Quattro (as SDF is fine) into
FoxPro, and then have go through the database and add up the occurrences of
the same name? I have a large database of orders with the structure:

Order Number    Name               etc..
124234234       Doe, John
1334534         Doe, Jane
12354345        Doe, John

and I want to count up how many orders each person has... I figured some way
of sorting the database, finding the first occurrence, counting, finding next,
etc. I want to be able to do this without having to manually key in each name,
so when new customers come in they automatically get added... 
(this one may not be so easy, but any and all help is appreciated)

chris
Xref: sparky comp.databases:5823 comp.databases.theory:298
From: mis@daimi.aau.dk (Michael I. Schwartzbach)
Newsgroups: comp.databases,comp.databases.theory
Subject: WANTED: interesting example relations...
Date: 27 Jul 92 11:20:07 GMT
Organization: DAIMI: Computer Science Department, Aarhus University, Denmark


   Does anyone have a collection of semi-realistic, interesting
   relations that could be used as example material in an
   introductory course on relational algebra? Preferably they
   should have an ``international'' flavor, i.e., NFL statistics
   would not be appropriate. The material should not be huge,
   but reasonably large (a few hundred tuples, perhaps).

   Please respond by email, either with the relations themselves
   or with information about ftp access.

   If sufficient response is generated I will post a summary.

                 Thanks in advance,

                        Michael I Schwartzbach


--
Michael I. Schwartzbach                          Email: mis@daimi.aau.dk
Computer Science Department, Aarhus University   Phone: +45 8612 7188
Ny Munkegade, Building 540                       Fax:   +45 8613 5725
8000 Aarhus C, DENMARK                           Home:  +45 8625 4127
From: dent@DIALix.oz.au (Andrew Dent)
Newsgroups: comp.databases
Subject: Fox/Mac DOUBLE-CLICK BROWSE FIX!
Summary: It's here!
Keywords: FoxBase/Mac BROWSE
Date: 30 Jul 92 15:24:20 GMT
Organization: DIALix Services, Perth, Western Australia

If you've ever sworn at the lack of double-clicking to edit a record
in the FoxBase/Mac browse then your troubles are over!

On request, a shareware XFCN will be mailed to you that enables you
to trap double-clicks, return, tab and/or enter keystrokes and generate
a command-keystroke of your choice.
(Anyone who wants to upload it to any ftp sites is welcome).

A separate XFCN for true scrolling list dialogs, with fast-loading arrays
not limited by Fox memory space is due out in August.

These are the result of frustration in waiting for FoxPro/mac to be 
released RSN (for the last two years, dammit!).

If there's enough demand for any other ideas (eg: graphing) then they will
be considered - I've spent enough midnights over the last two weeks programming
this stuff I think I could do anything (but that's probably just the adrenalin/
fatigue toxins talking).

Andy Dent (A.D. Software - Mac & VAX programming)
94 Bermuda Dve, BALLAJURA  Western Australia  6066
Phone/Fax: 09 249 2719 (local)  +619 249 2719 (International)
       Internet: dent@DIALix.oz.au    Compuserve: 100033,3241
From: gt2768b@prism.gatech.EDU (JENGLUNG LIN)
Newsgroups: comp.databases
Subject: How to stop 'set filter' in Clipper?
Date: 21 Jul 92 14:53:47 GMT
Distribution: usa
Organization: Georgia Institute of Technology

Hi,
set filter in Clipper is a very poor design. No matter you have index or not,
it is still sequentially processed.

My question is: Is there a way to stop 'set filter' process especially when
dealing with 2MB or more files? or there are better ways to do.

Thanks in advance.
-- 
LIN,JENGLUNG
Georgia Institute of Technology, Atlanta Georgia, 30332
uucp: ...!{allegra,amd,hplabs,seismo,ut-ngp}!gatech!prism!gt2768b
ARPA: gt2768b@prism.gatech.edu
From: jcberger@grasp1.univ-lyon1.fr (Jean-Claude Berger)
Newsgroups: comp.databases
Subject: Re: Upgrading Paradox
Date: 29 Jul 1992 19:37:21 +0200
Organization: INSA Informatique, Lyon, France
NNTP-Posting-Host: grasp1.univ-lyon1.fr

In article <id.8URR.IUH@ferranti.com> neuwirth@ferranti.com (howard neuwirth-hirsch) writes:
>In article <Jul.22.17.44.33.1992.5398@dimacs.rutgers.edu>, magarell@dimacs.rutgers.edu (Christopher Magarelli) writes:
>> 
>>      Could somebody tell me what, if any, conversion of files is
>> necessary when upgrading from Paradox 3.01a to 3.5?     I'd appreciate
>> any help.
>> 
>>           Chris Magarelli
>
>No conversion is needed.
>
>H.
>
>-- 
>Howard Neuwirth-Hirsch

Sorry Howard but some conversions ARE needed. Because of rounding
problems, all tables with N or $ type fields should be exported to
ASCII then restructured under Pdox 3.5 and re-imported. This is 
mentioned in the readme files I had and you do need to do it. I had
a lot of rounding errors before converting the tables.

And of course, one should reorganize every tables to fully benefit
of the speed of version 3.5. A query in version 3.5
with version 3.0x tables is slightly faster than in version 3.0. After
a reorg, you have a 50% improvement.


 ----------------------------------------------------------------------------
 Jean-Claude Berger, JCBerger Developpement Formation (Free Lance Consultant)
 (+33) 78.24.75.78     E-Mail : jcberger@grasp1.univ-lyon1.fr - BIX, jcberger