DBA_learner
Member
Hello All,
I am a bit confused with type-1 to type-2 conversion/creation. Please check below for the same:
1. If we take full back-up of type-1 database and restore it over type-2 structure file (new created structure file from type-1 structure file, number of database blocks is 8) then will it be a database of type-2 storage areas.
I tired doing that and am able to create database with new type-2 structure file but when I see table detail under Data dictionary -> Reports -> Detailed table then there are many tables (more then 8) under single area define with 8 database blocks.
2. If we dump the database and load it with new type-2 structure file then will it be a database of type-2 storage areas.
I tried this as well but found the same (mentioned above) that there are many tables under single area define with 8 database blocks.
3. As per my understanding, if our cluster has 8 database blocks then our area associated with the cluster should have 8 database tables associated with it (one database block for one table), is this correct?
Kindly suggest.
Regards,
I am a bit confused with type-1 to type-2 conversion/creation. Please check below for the same:
1. If we take full back-up of type-1 database and restore it over type-2 structure file (new created structure file from type-1 structure file, number of database blocks is 8) then will it be a database of type-2 storage areas.
I tired doing that and am able to create database with new type-2 structure file but when I see table detail under Data dictionary -> Reports -> Detailed table then there are many tables (more then 8) under single area define with 8 database blocks.
2. If we dump the database and load it with new type-2 structure file then will it be a database of type-2 storage areas.
I tried this as well but found the same (mentioned above) that there are many tables under single area define with 8 database blocks.
3. As per my understanding, if our cluster has 8 database blocks then our area associated with the cluster should have 8 database tables associated with it (one database block for one table), is this correct?
Kindly suggest.
Regards,