Updating oracle database
Remember in my case the name of the pluggable database is “PDBORCL” and the service name is also “pdborcl”.
The service entry which we created in file can be specified here using @ sign followed by the username and password in the connection string.
So let’s go ahead and see how we can unlock HR user in Oracle Database 12c.
Because of the new and updated architecture of Oracle 12c a.k.a Multitenant Architecture, the process of unlocking the HR schema is not as simple as it was with the earlier versions of oracle database.
I need to duplicate a bunch of rows, while changing one value.
If the number of columns is large, you could copy the data you want into a temporary table, alter the data in the temporary table as you wanted, then copy the contents of the temporary table back into the original, and delete the temporary table.
The result returned from this query in my case is “pdborcl” which is the name of the service for my pluggable database “PDBORCL”.