Real Time Training - Week-2(Day 6 - 10)
Day - 7(Exercise)1. Create a user(without any role) with password oracle123 and the user should belong to user_data tablespace ? |
2. Connect to the database as user and create a table tab01 as select * from all_objects ? |
3. Check and rectify the error ? |
4. Create a user with password expiration limit in 2 days ? |
5. Password should have one capital letter, number, special character ? |
6. Should not allow the old password to be reused and account to be locked after 3 wrong attempts ? |
7. Password expiration, recreate password ? |
8. Create a job to gather the stat for schema - SCOTT every one hour ? |
9. Create a job to find the fragmentation ? |
Recent Videos | Today
Fragmentationm
Description about Fragmentationm
Oracle Installation
Description about Installation