oracle xe question

[matt-urrlRJtNKRMsHrnhXWJB8w at public.gmane.org (Matt Shields)]

On Fri, Feb 11, 2011 at 8:37 AM, Jerry Feldman <gaf-mNDKBlG2WHs at public.gmane.org> wrote:

> We use oracle XE for some of our products. Normally, when XE is
> installed everything is installed in /usr/lib/oracle/xe. I want to be
> able to move the physical database (/usr/lib/oracle/xe/oradata/) to
> another HD. Certainly one way to do this is to simply move the entire
> directory and symlink oradata to the new location or simply move the
> entire xe tree.
>
> Another quick question, is there a limitation to the size of the database.
>
> --
> Jerry Feldman <gaf-mNDKBlG2WHs at public.gmane.org>
> Boston Linux and Unix
> PGP key id: 537C5846
> PGP Key fingerprint: 3D1B 8377 A3C0 A5F2 ECBB  CA3B 4607 4319 537C 5846
>
>
>
> _______________________________________________
> Discuss mailing list
> Discuss-mNDKBlG2WHs at public.gmane.org
> http://lists.blu.org/mailman/listinfo/discuss
>
>
Why not move the entire directory to a new drive (local, iscsi, or san) then
mount that new drive as /usr/lib/oracle/xe/oradata.  I've done the same
thing with MySQL for years.  Default install for MySQL data dir is
/var/lib/mysql on RedHat/CentOS.  I've always wanted to keep my DB's
separate from the OS, so I've just mounted another volume to that path.
 Works great for external volumes because if the server ever dies, you just
reattach the volume to another server and startup mysql.

-matt