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
