Re: Where Can I Find...

On 1/25/2013 8:21 AM, Gene Poole wrote:
> lso I don't want to use RPM because I like to control where software
> is installed. Another piece on information is that I am running on
> CentOS 5.8.

if you don't want to use RPM, why did you choose an RPM based distribution?

is '6 single sided DVDs' a cute way of saying around 24 GB of data?

there's absolutely NO reason to use a bunch of tablespaces for a
database that small. we use tablespaces for multi-terabyte databases.
Instead, on modern hardware, just put a bunch of small/fast disks in
a raid10 and use that for the whole thing.

An Oracle 'instance" is roughly equivalent to a postgres 'database', the
instance can have many schemas within it.

For copying the data across, I'd look into ETL packages, such as
http://www.jaspersoft.com/JasperSoft_JasperETL.html

these can connect to different database engines, and 'extract,
transform, and load', with a lot of flexibilty.

--
john r pierce 37N 122W
somewhere on the middle of the left coast