|
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 |
