Free Oracle Server for intranet?

wrote in message
news:1139882631.655359.320260@g14g2000cwa.googlegroups.com...
: Our department is loosing access to MS Server 2000. I am looking into
: different possibilities of replacements, Oracle being one. I know
: Oracle is available for free, but I'm not clear what the limitations of
: it are, and that's what I need clarified for me please.
:
: It would reside in an intranet environment on a single processor
: machine with about 2-10 people accessing it at a given time. We would
: also need some sort of replacement for our DTS packages. I'm not sure
: of what kind of equivalent feature is available on Oracle. The DTS
: packages basically import CSV files and run several queries in a row
: before and after the CSV import, and perform some scripted
: transformations when importing the data.
:
: Thanks in advance!
:

Application Express (HTML DB) with OracleXE will do exactly what you're
looking for, but you'll need to do just a little development to replicate
the DTS functionality -- doesn't sound like it would be too difficult,
though. and it looks like FSU offers a bunch of Oracle courses, so you must
have a PL/SQL programmer lurking around there somewhere to help you do that
;-) [ although i see one of the tutorials is for installing Oracle
Developer on Windows98 :-( ]

anyway, you need to look at
http://www.oracle.com/technology/pro.../xe/index.html

++ mcs

wrote in message
news:1139882631.655359.320260@g14g2000cwa.googlegroups.com...
: Our department is loosing access to MS Server 2000. I am looking into
: different possibilities of replacements, Oracle being one. I know
: Oracle is available for free, but I'm not clear what the limitations of
: it are, and that's what I need clarified for me please.
:
: It would reside in an intranet environment on a single processor
: machine with about 2-10 people accessing it at a given time. We would
: also need some sort of replacement for our DTS packages. I'm not sure
: of what kind of equivalent feature is available on Oracle. The DTS
: packages basically import CSV files and run several queries in a row
: before and after the CSV import, and perform some scripted
: transformations when importing the data.
:
: Thanks in advance!
:

Application Express (HTML DB) with OracleXE will do exactly what you're
looking for, but you'll need to do just a little development to replicate
the DTS functionality -- doesn't sound like it would be too difficult,
though. and it looks like FSU offers a bunch of Oracle courses, so you must
have a PL/SQL programmer lurking around there somewhere to help you do that
;-) [ although i see one of the tutorials is for installing Oracle
Developer on Windows98 :-( ]

anyway, you need to look at
http://www.oracle.com/technology/pro.../xe/index.html

++ mcs

On Mon, 13 Feb 2006 18:03:51 -0800, shumaker wrote:

> Our department is loosing access to MS Server 2000. I am looking into
> different possibilities of replacements, Oracle being one. I know
> Oracle is available for free, but I'm not clear what the limitations of
> it are, and that's what I need clarified for me please.

The package is called Oracle Database 10g Express Edition. It is fully
free to deploy in production, intranet or extranet, contains the entire
Oracle SQL core that is common to the Oracle Database 10g line.

High level summary of the limitations:

1) Single CPU will be used (even on multi-CPU machines);
2) Max 1GB RAM will be used;
3) Max 4GB user data space;
4) No built-in JVM and therefore no Java-based stored procedures;
5) No 'Enterprise Edition' options or EE-only features;

A more comprehensive list is in the online 'Licensing Information' docco
at http://www.oracle.com/pls/xe102/homepage

Note that is is currently considered beta, while Oracle irons out the
install issues. I don't think the actual engine will change in any
significant way, other than to include patches available at release.

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** Top posting [replies] guarantees I won't respond. ***

On Mon, 13 Feb 2006 18:03:51 -0800, shumaker wrote:

> Our department is loosing access to MS Server 2000. I am looking into
> different possibilities of replacements, Oracle being one. I know
> Oracle is available for free, but I'm not clear what the limitations of
> it are, and that's what I need clarified for me please.

The package is called Oracle Database 10g Express Edition. It is fully
free to deploy in production, intranet or extranet, contains the entire
Oracle SQL core that is common to the Oracle Database 10g line.

High level summary of the limitations:

1) Single CPU will be used (even on multi-CPU machines);
2) Max 1GB RAM will be used;
3) Max 4GB user data space;
4) No built-in JVM and therefore no Java-based stored procedures;
5) No 'Enterprise Edition' options or EE-only features;

A more comprehensive list is in the online 'Licensing Information' docco
at http://www.oracle.com/pls/xe102/homepage

Note that is is currently considered beta, while Oracle irons out the
install issues. I don't think the actual engine will change in any
significant way, other than to include patches available at release.

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** Top posting [replies] guarantees I won't respond. ***