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_at_posting.google.com>
Date: 7 Mar 2004 08:44:22 -0800
Message-ID: <b6b91e64.0403070844.66ff4862_at_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 - 17:44:22 CET