As long as you are doing a conversion, you should strongly
consider going straight to 10g.
Jared
On 6/15/05, Chris Hoover <revoohc_at_gmail.com> 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
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 15 2005 - 14:31:43 CDT
