Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Migrating db2 to Oracle 9i

Migrating db2 to Oracle 9i

From: Zvika Glickman <zglickman_at_il.bphx.com>
Date: 7 Mar 2004 08:44:22 -0800
Message-ID: <b6b91e64.0403070844.66ff4862@posting.google.com>

I'm migrating DB2 to ORACLE 9I.
In the DB2 schema each table defined in diferrent tablespace. Few tablespaces are define on the same STOGROUP (there are few STOGROUP).
It's a big db (few terra bytes). There are tousands of tables, so also thousands of tablespace.
When i'm migrating to Oracle:
 Is it right to define oracle tablespace for each DB2 tablespace (so i'll have
thousands of tablespaces)?
 if not, how should i split my entities to tablespaces so it will match the DB2 structure?
What is the parallel entity in Oracle to: STOGROUP in DB2? Received on Sun Mar 07 2004 - 10:44:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US