What is Table Fragmentation in an Oracle And How To Remove Table Fragmentation?
Table fragmentation means when you updated or deleted data in a table and you wanted to reclaim space, yes you could, but Oracle immediately can’t … Read more
Database
How to Resize Temporary Tablespace in Oracle 11g Database
To resize temporary tablespace in an Oracle 11g database, you should follow the below given document approach, which includes prerequisites. Checking the current configuration, and … Read more
How To Grant Read Only Access To User in Oracle Database?
In this article, we will discuss how to grant read only access to user in Oracle database. In the very first we need to create … Read more