As long as you are doing a conversion, you should strongly consider going straight to 10g. Jared On 6/15/05, Chris Hoover <revoohc@xxxxxxxxx> wrote: > > Hey Everyone, > > I've been given a rather exciting project on which to work.=20 > Management wants to look at migrating one of our large in house > developed systems from PostgreSQL to Oracle. Does anyone know of any > good sites with help on this type of conversion? Also, does anyone > have any advice they can offer up? > > Here is what we have: > ~200 Postgresql DB's running between 5 systems (all schemas are the > same, 1 db per customer) > DB's run from a ~100MB to ~100GB. > > Any advice on how to go about this? > > We have a lot of text, serial, and boolean columns that don't appear > to map cleanly over to Oracle. What have some of you done in the past > conveting these type of columns? > > We are looking at either 9i (which we currenly have in house), or 10g > for the Oracle server version. > > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- //www.freelists.org/webpage/oracle-l