Oracle ASM is widely used in IT industry. Here I have compiled Top 46 Oracle ASM Interview Questions to enhance the knowledge about Oracle ASM instance Question 1 What is ASM in Oracle? Answer Oracle ASM is Oracle’s volume manager specially designed for Oracle database data. It is available since Oracle database version 10g and many […]
How to shrink datafile in Oracle Database
We sometimes have shrink datafile in oracle to reclaim filesystem space.We can do it like Alter database datafile <datafile name > resize <smaller size>; Many times we may get the below error as the extent may spread out on the outer of the file ORA-03297: file contains used data beyond requested RESIZE value”. To resolve […]
Understanding IP Addresses, Subnets, and CIDR Notation
We need to have the basic knowledge of Networking concepts like IP Addresses, Subnets, and CIDR Notation before working on any Cloud infrastructure. Here I am giving the basic and to the my knowledge on few important concept which will be useful for any cloud vendors What is IP Address IP addresses are nothing but […]
How to create Users and Roles in Oracle database 12c
We already know how to create user and grant privileges in a traditional non-CDB database.Check the below detailed post to learn about it Create User in Oracle Lets find out now, how to create user in oracle 12c. In a non-CDB, a user name or Roles cannot begin with C## or c## How to create […]
How to Create User in Oracle and Assign privileges
We will be posting information on User access and security in oracle database.This post will give good information on Create User in Oracle , System Privileges and Oracle Object Privileges,How to grant the privileges to users,How to show all privileges from a user in oracle CREATE USER statement It is employed to create a user […]
alter table rename column in oracle database
Oracle allows you rename existing columns in a table. Use the RENAME COLUMN clause of the ALTER TABLE statement to rename a column i,e alter table rename column in oracle Syntax ALTER TABLE table_name RENAME COLUMN old_name to new_name; Lets see this example SQL> CREATE TABLE DEPT_MASTER ( dept_nr NUMBER UNIQUE, dept_name varchar2(100) NOT NULL, dept_status NUMBER(1,0) NOT NULL, […]
