DBA_learner
Member
Dear All,
Kindly help me regarding below concerns of mine:
1. Under “Type-2”, database and index should have same area or should be different for data and index (as in type-1).
2. What all tables schema area should contain, only VST tables?
3. How do I convert type1àtype 2 conversions after doing dump and load? For example, I have one area named “Transaction” (Type - 1) and this area has 200 tables, so while converting this to type-2 storage, what all steps we need to follow?
Or we need to create separate areas for multiple tables, like one area for large table and one area for few small tables. If yes, then kindly share the step that needs to be followed for this allocation.
Kindly suggest.
Kindly help me regarding below concerns of mine:
1. Under “Type-2”, database and index should have same area or should be different for data and index (as in type-1).
2. What all tables schema area should contain, only VST tables?
3. How do I convert type1àtype 2 conversions after doing dump and load? For example, I have one area named “Transaction” (Type - 1) and this area has 200 tables, so while converting this to type-2 storage, what all steps we need to follow?
Code:
d "TRANSACTION":7,64;1 db-name.d1 f 1844608
d "TRANSACTION":7,64;1 db-name.d2 f 1844608
d "TRANSACTION":7,64;1 db-name.d3 f 1844608
d "TRANSACTION":7,64;1 db-name _7.d4
For converting above to type 2 storage structure, can I dump the database and load it in below kind of structure:
d "TRANSACTION":7,64;64 db-name.d1 f 1844608
d "TRANSACTION":7,64;64 db-name.d2 f 1844608
d "TRANSACTION":7,64;64 db-name.d3 f 1844608
d "TRANSACTION":7,64;64 db-name _7.d4
Or we need to create separate areas for multiple tables, like one area for large table and one area for few small tables. If yes, then kindly share the step that needs to be followed for this allocation.
Kindly suggest.