Let consider the below example, where we list all the indexes in the database. sql> select index_name from dba_indexes where tablespace_name =’EXAMPLE’ and index_name like ‘E%’ order by 1 asc; INDEX_NAME —————– EMP_EMAIL_UK EMP_EMP_ID_PK EMP_DEPARTMENT_IX EMP_JOB_IX EMP_MANAGER_IX EMP_NAME_IX Getting DDL To get the DDL: DBMS_METADATA.GET_DDL ( object_type IN VARCHAR2, name IN VARCHAR2, schema IN VARCHAR2 […]
How to rename a Pluggable Database, along with the respective directories, in Oracle 12c
Please go through the following steps to change the name of a PDB, along with the respective directories, in 12c. 1. Connect to the CDB and check the information about the PDB first: sql> select name, open_mode, restricted from v$pdbs; sql> select name, con_id, dbid,con_uid,guid from v$containers order by con_id; sql> select service_id,name,network_name,creation_date,pdb,con_id from cdb_services; […]
How to rename Oracle-Managed Files (OMFs)
There are 2 different scenarios to consider: Renaming an OMF to a non-OMF name. Renaming an OMF to another OMF-compliant name. Note that renaming an OMF to another OMF-compliant name is not normally recommended. You should allow Oracle to name the files. But, should you wish to rename one but maintain its OMF status, it […]
chcon command examples in Linux
The chcon command helps to change the SELinux context or TYPE of what will most often be a single or perhaps sometimes a few files that can be referenced easily together with some form of a wildcard. chcon along with semanage and restorecon can be used to fix an incorrect SELinux context. You can use […]
lvresize command examples in Linux
If you are running out of space and you want to add more space to your LVM volume, you can use the lvresize command to do so. To do that, unmount the volume and use the lvresize command. (Actually, it is not required that you unmount the volume to grow it, but it is done […]
lvextend command examples in Linux
Logical Volume Manager 2 (LVM2) allows you to aggregate physical storage devices into volume groups. You can then divide that aggregated space into one or more logical volumes. Once created, logical volumes can be extended to utilize unused space within the volume group, allowing the file system residing on the logical volume to be extended […]
How to Start, Stop and Restart Zimbra Service
The Zimbra server contains Postfix, MySQL, OpenLDAP, ClamAV, and Spam-Assassin, Calendar, and various other features. Zimbra provides a paid option as well as an open source version. The first command in Zimbra mail server which we need to care about zimbra server service status. All services should be running on server. If any of service […]
How to Find and Delete Empty Directories and Files in Linux
1. Find empty directories in the current directory using find -empty: $ find . -type d -empty 2. Use the following command to remove all empty directories under the current directory: $ find . -type d -empty -exec rmdir {} \; 3. Find empty files in the current directory using find -empty: $ find . […]
Understanding C Arrays: Their creation and manipulation, multi-dimensional arrays
We have seen how to create variables – integer, float, or character types, each variable is given a unique name and you can store one item under that name. Often, however, we need several similar items to be grouped under a single name. For example, marks scored by a student in different subjects, the salaries […]
Control Structures of C – for, while and do loops, if then else statements, switch statements
Here we learn about the control structures of C. The compiler normally takes the program line by line and executes them in a sequence ( one after another ). But this may not always be the case. Based on certain conditions existing in the data, we may want to change the data – Then we […]