Oracle 19c pl/sql
Budget: $15 – $25 USD
1. Write a pl/sql code to fetch the data & reload it back into the pk/fk relationship partitions tables. 2.5 hrs task
2. Write a pl/sql code to remove fragmentation from user tablespaces. Do No use exp/imp or datapump in pl/sql code use the following select/alter/create/move || pipe commands for backing up objects & segments into new tablespaces.
4 hrs task
3. Write a pl/sql code to generate user encrypted password file (Alter user … identified by …) from a username text file. 2.5 hrs task.
2. Write a pl/sql code to remove fragmentation from user tablespaces. Do No use exp/imp or datapump in pl/sql code use the following select/alter/create/move || pipe commands for backing up objects & segments into new tablespaces.
4 hrs task
3. Write a pl/sql code to generate user encrypted password file (Alter user … identified by …) from a username text file. 2.5 hrs task.