So for type support are you meaning nested tables? I've started playing with this recently and it seems to work in Schema Compare.
My simple test case is..
- Code: Select all
create type acme.nt_nested is table of int;
create table acme."RankTable" (
"ID" NUMBER(4,0) NOT NULL ENABLE,
nested table nest store as "RankTable_nt_tested";
For storage clauses there is an option "Ignore Storage" in Schema Compare that is enabled by default.
Materialized views - as I've mentioned I've been working on a lot so now it supports complex queries, column aliases and grants. Indexes I'm not aware of anything outstanding.
I'm still getting up to speed on Oracle so any help from experts about missing features is really appreciated (especially if they come with a simple reproduce case).