The following are the partitioning related enhancements introduced in Oracle 12c: Online partition operations Reference partitioning enhancements Multi-partition maintenance operations Adding multiple partitions Truncating multiple partitions Merging multiple partitions Splitting into multiple partitions Dropping multiple partitions Dropping a Partition Dropping a partition will discard the rows stored in that partition as a DDL statement. This […]
Archives for May 2018
How to Split a Partition Into Multiple Partitions in Oracle 12c
The following are the partitioning related enhancements introduced in Oracle 12c: Online partition operations Reference partitioning enhancements Multi-partition maintenance operations Adding multiple partitions Truncating multiple partitions Merging multiple partitions Splitting into multiple partitions Dropping multiple partitions Splitting Partition into multiple partitions You can split a partition into multiple partitions. In previous releases, you were able […]
How to Merge Multiple Partitions in Oracle 12c
The following are the partitioning related enhancements introduced in Oracle 12c: Online partition operations Reference partitioning enhancements Multi-partition maintenance operations Adding multiple partitions Truncating multiple partitions Merging multiple partitions Splitting into multiple partitions Dropping multiple partitions Merging multiple partitions In Oracle 11g, you can merge the content of two partitions only in single DDL. However, […]
How to use wget to download file via proxy
The wget program allows you to download files from URLs. Although it can do a lot, the simplest form of the command is: wget [some URL]. Assuming no errors, it will place that file in the current directory. If you do not specify a filename, by default it will attempt to get the index.html file. […]
Linux Command line Basics – Working with Files and Directories
This post explains how to work with files and directories. This includes tasks, such as locating your position in the directory structure, viewing file contents, copying and moving files and directories, creating and removing files and directories, and searching for files and directories. Viewing Directories A directory is a list of references to objects, which […]
Solaris Volume Manager (SVM) : How to Use Mirrors to Roll Back System Changes
There are many circumstances where major changes are being made to the system, such as a patchset install or OS upgrade, when it would be nice to have the option to undo those changes and revert to a previous system state in case something goes wrong. With software volume management and a little preparation, it […]
Linux Command line Basics – Executing commands from the command line
You can use system commands on the command line to instruct the system to perform specific tasks. The commands are received into a terminal window. This post is a very basic introduction to using commands with options and/or arguments and also how to run multiple commands on the command line. Note: UNIX commands are case-sensitive. […]
How to set boot-device with luxadm command in Solaris
This procedure demonstrates how to easily use the “luxadm” command to set the “boot-device” Open Boot Prom (OBP) parameter from a system booted from cdrom or in single user mode. The command will change the “boot-device” setting at the OS level and at the same time, change the “boot-device” setting at the OBP level. This […]
How to create an OBP boot device alias in Solaris [SPARC]
These aliases are created to simplify access to hardware devices at the OBP level. They can be used in place of the full OBP hardware path at the “ok” prompt. When viewed via the “devalias” command at the prom level, they are listed in the form of the alias name followed by the full hardware […]
“resize2fs: Permission denied to resize filesystem” error while online resize of a filesystem
The Problem On CentOS/RHEL 6, an LVM volume group size has been extended and an attempt to do online resize of ext4 filesystem on LVM volume group failed with following error. resize2fs /dev/mapper/P05TRF1vg-vol_controlm resize2fs 1.43-WIP (20-Jun-2013) Filesystem at /dev/mapper/P05TRF1vg-vol_controlm is mounted on /controlM; on-line resizing required old_desc_blocks = 1, new_desc_blocks = 1 resize2fs: Permission denied […]