Hello -
I need to build an Oracle DB for my company. I also need to ship the
database to the costumers along with  an instrument. how can we ship
the database to every customer. should we buy for every instrument or
a copy? or a license? or.. donno..
How can I do it so that the customers get the data with the database
when we ship the instrument. I am new to database.

Thanks.

---

Request for Question Clarification by netcrazy-ga on 20 Jun 2002 07:09 PDT

Hi,

What exactly is this "instrument" and do you want to ship the data or
the Oracle  client and server?

Oracle gives various options for licenses and depending on your
clarification, I can tell you precisely what you can do.

Thanks
netcrazy

---

Clarification of Question by edwk-ga on 20 Jun 2002 08:05 PDT

This instrument consists of camera, and other devices. It also has a
bunch of Java Swing applications to test the output of the instrument
on the computer and view the results graphically etc. All I need is,
The database that I creat at work that stores a bunch of data
specifically, DNA fragments, sequences like TGTGGAAAAATTT etc also
needs to be shipped to the customers. How can this be done. I am
really new to the oracle, so this is what is my best to explain my
needs. excuse me.

---

Clarification of Question by edwk-ga on 20 Jun 2002 08:06 PDT

Also, is there a C API for Oracle?

This isn't an answer, just a comment, so don't take it as an answer. 

Unless you work something out with Oracle themselves, each computer is
going to need a licensed copy of the database engine to run. As you
know, you are going to need a computer to run the database with each
instrument, so a license for each is required. This could get very
expensive for your clients.

It sounds like, from your description, that you have not really
started hard development, so you might want to look into a database
like MySql, which will be much less expensive, and would probably work
great for you, unless you need things like transaction control. From
your description this may not be a requirement.

Oracle focuses on a Java API, not the C or C++. Though I did find a
page on the API for C here on this page.

Oracle Internet Directory Application Developer's Guide 
http://download-east.oracle.com/otndoc/oracle9i/901_doc/network.901/a90152/capi.htm

A good website on Oracle can be found here :

Oracle FAQ
http://www.orafaq.com/faqpub.htm


webadept-ga

Every client will need a license, period.  If it's a small database
only accessed on a single machine (ie: not accessed by anyone but the
person actually using the PC), you can use Personal Oracle to save
some money:

http://otn.oracle.com/software/htdocs/devlic.html?/software/products/8i_personal/htdocs/winsoft.html

If you want to give the data to the client along with your instrument,
use the Oracle export program to dump the database on your machine and
have an installation program restore the dump using the Oracle import
program on the client's machine.  The program runs as a command-line
app, so your installer can just call it with the appropriate commands:

http://www.desy.de/asg/oracle/impexp/impexp.html

Forgot the bit about the C API...

The Oracle C API involves a pre-compiler that pre-scans your code to
set up the database interaction (Pro*C)

Here is some documentation/examples:

http://www-db.stanford.edu/~ullman/fcdb/oracle/or-proc.html

Hope this is what you are looking for!