duplication of objects from user ( and its tablespaces ) to another user ( and own tablespaces )?
Hello,
I have a question on copying the schema content ( all object types: indexes, tables, seq, views, stored plsq&java procedures, synonyms, global synonyms ) from one user to another user witth another defalt tablespace for data and another tablespace for indexes on periodical weekly bases.
For example:
1. There is USER1 that is based on tablespaces TS1_data, TS1_indx
2. And there is USER2 that is based on tablespaces TS2_data, TS2_indx.
Objects of the User1 are changing daily.
But objects of the USER2 should be copy of the obects of USER1, where refresh is made each end of the week.
I have a question on copying the schema content ( all object types: indexes, tables, seq, views, stored plsq&java procedures, synonyms, global synonyms ) from one user to another user witth another defalt tablespace for data and another tablespace for indexes on periodical weekly bases.
For example:
1. There is USER1 that is based on tablespaces TS1_data, TS1_indx
2. And there is USER2 that is based on tablespaces TS2_data, TS2_indx.
Objects of the User1 are changing daily.
But objects of the USER2 should be copy of the obects of USER1, where refresh is made each end of the week.
0