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?
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?