Pl/sql coding & shell scripting
Budget: $2 – $8 USD
Requirement #1. write a pl/sql package to fetch data from 2 parent & child tables with multiple filters (where) clause and get the data in csv & excel format and insert/update the data back to the same tables having datatypes null, notnull, Pk, Fk, check, sequence, lob, xlm, varchar, nvarchar, char date, timestamp, long datatypes in the tables, indexes partitions. Write the efficient code to run from sql developer sqlplus & bash shell.
—ORACLE 19c / Bash shell /Linux 7
Requirement #2.
There are multiple users in the database having tables index partitions and tablespaces having numbers of user objects & segments with various data types lobs, xml, varchar, nvarchar, date, timestamp, number long, iot, partitions pk, fk,, organizational index, check constrains , sequences etc we require a pl/sql code to release fragmentation from the tablespaces based on user by creating a backup of all the tablespaces (create all the new tablespaces as a backup) for that one user, then copy all the objects in a new tablespaces then drop all the old all tablespaces for that user and replace the newly created tablespaces with the original Names back.
create a new user to create & executable pl/sql package and from there you clear the fragmentation by calling pl/sql code and call the bash script to run the package. For each schema user (there may be many schema’s in the oracle 19c database on linux & bash shell.
3. Oracle password encryption script to generate for each user file meaning read the user file having user names and generate a sql file(Alter user username passport ….)
Required efficient coding and provide privileges to implement & execute/run the packages.
—ORACLE 19c / Bash shell /Linux 7
Requirement #2.
There are multiple users in the database having tables index partitions and tablespaces having numbers of user objects & segments with various data types lobs, xml, varchar, nvarchar, date, timestamp, number long, iot, partitions pk, fk,, organizational index, check constrains , sequences etc we require a pl/sql code to release fragmentation from the tablespaces based on user by creating a backup of all the tablespaces (create all the new tablespaces as a backup) for that one user, then copy all the objects in a new tablespaces then drop all the old all tablespaces for that user and replace the newly created tablespaces with the original Names back.
create a new user to create & executable pl/sql package and from there you clear the fragmentation by calling pl/sql code and call the bash script to run the package. For each schema user (there may be many schema’s in the oracle 19c database on linux & bash shell.
3. Oracle password encryption script to generate for each user file meaning read the user file having user names and generate a sql file(Alter user username passport ….)
Required efficient coding and provide privileges to implement & execute/run the packages.