1.perform a schema refresh from tax user to tax1 user.
|
2. perform a schema refresh from tax1 user to tax2 and tax3.
|
3. mention the pre – requisites of schema refresh and post schema refresh steps.
|
4. export schema with only structure and no data.
|
5. create a table Ao in tax user from all_objects,
insert the data from all_objects till the table reaches the size of 500mb.
|
6. check number of extends.
|
7. export the created table and import the table to other user using compress option.
|
8. check number of extends.
|
9. export the tables from tax user but the dump file size should be 100mb.
|
10. export table AO but using sys user.
|
11. import the table data only without index into another user with below parameter
Commit, buffer.
|
12. import index alone.
|
13. using transport tablespace option complete import and export of dev database.
|
14. read the dump.
|
15.import the tax dump without data into any user u1.
|
16. import the data separately into the user u1.
|
17. import the index separately into user u1.
|