Re: Migrating db2 to Oracle 9i

zglickman_at_il.bphx.com (Zvika Glickman) wrote in message news:<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?

Thousands of tablespaces is possible, but not necessarily a good idea. Each tablespace will have at least one datafile, when Oracle performs a checkpoint all datafiles will need to be dealt with. Apart from that it is a maintenance nightmare.
I would split entities by application and/or size. With Oracle there is no such thing as a stogroup, you would best set up your tablespaces *locally managed* with appropiate settings and forget about individual storage clauses on table level.

Sybrand Bakker
Senior Oracle DBA Received on Mon Mar 08 2004 - 10:01:23 CET