It sounds to me like the O7 database may have had very large extents,
possibly as a result of somebody running an exp/imp cycle with
compress=y to coalesce tables into one extent each. (This used to be
fashionable among some DBAs.)
If that's the case, there's no easy way out. You can run imp with the
INDEXFILE option, which will get you a text file containing CREATE
TABLE and CREATE INDEX statements. You can edit that to remove the
storage clauses that are causing your problems, then run the result in
sqlplus. If there are a lot of tables, it'll take you a while, unless
you're handy with awk and sed.
Received on Thu Sep 13 2007 - 01:23:35 CDT
