Migration of partitioned tables from DB2 to Oracle
890758Feb 6 2012 — edited Feb 6 2012The requirement is to migrate few schema structures from a DB2 warehouse database to Oracle 11g database. I thought of geeting the ddls from DB2 DBAs and applying here in oracle database after modfiying it with the oracle clauses(schema name, tablespace etc).
80% of the tables in this DB2 setup are partitioned tables. And as per my understanding they are partitioned by indexes (range based).
The problem is the range limit in DB2 partition is inclusive (i.e. the data in any given partition will be less than or equal to the range limit). I can not use the same partition ranges in Oracle (as here range limits are 'values less than' ).
Each table is having around 200-250 partitions. If I have to modify each partition name, as per oracle standard ranges, it will be a huge manual 'notepad' work.
Please suggest me any better approach which will help me in doing this task in a better way.
I am not using any tool.