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