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 ? |
Recent Videos | Today
Fragmentationm
Description about Fragmentationm
Oracle Installation
Description about Installation