472,126 Members | 1,634 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,126 software developers and data experts.

Migrating db2 to Oracle 9i

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?
Jul 19 '05 #1
0 1923

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by fpic | last post: by
3 posts views Thread by vv | last post: by
3 posts views Thread by goooooglegroups | last post: by
reply views Thread by Zvika Glickman | last post: by
1 post views Thread by Søren Alexandersen | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.