Real Time Training - Week-3(Day 11 - 15)
Day - 11(Excercise)| 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 ? |
