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