We often need to find the database size for space allocation and future growth, Let’s see how to check db size in oracle for Both the Non-CDB and CDB databases How to check db size in oracle for Non-CDB Database Here is the query which can be used to find the database size select ‘Total […]
How to check db size in oracle Read More »
Here in this post, we will talk about the ROWNUM keyword in Oracle What is ROWNUM Example CREATE TABLE “EMP” ( “EMPNO” NUMBER(4,0), “ENAME” VARCHAR2(10), “JOB” VARCHAR2(9), “MGR” NUMBER(4,0), “HIREDATE” DATE, “SAL” NUMBER(7,2), “COMM” NUMBER(7,2), “DEPTNO” NUMBER(2,0), CONSTRAINT “PK_EMP” PRIMARY KEY (“EMPNO”), CONSTRAINT “FK_DEPTNO” FOREIGN KEY (“DEPTNO”) REFERENCES “DEPT” (“DEPTNO”) ENABLE ); insert into emp
Introduction High-Level steps Steps to Backup Database To Cloud Object Storage Using DBCLI Create the object store on the DB system We need the information below before we create an object store Login to the server as OPC and sudo to root dbcli create-objectstoreswift -n <object_store_name> -t <object_storage_namespace> -u <user_name> -e https://swiftobjectstorage.<region_name>.oraclecloud.com/v1 -p [-h] [-j] This will prompt for the auth
How To Backup Database To Cloud Object Storage Using DBCLI Read More »
RMAN List backup is a useful command to list the backup taken in the system. It shows all the details about the backup taken, what time it was taken, location of the backup. First, you need to connect with the Target database with or without a catalog and then these commands can be run. If
RMAN List backup commands Read More »
DML operations like insert, update, and delete are allowed in Oracle views with certain restrictions. Let’s check in this post to update the view in Oracle, insert into view Oracle, delete from view in Oracle DML on view in Oracle For example, Let’s first create the TEST view. Create view emp_data as select e.empno,e.ename,e.sal,e.deptno,d.dname From
How to perform DML operations on Oracle View: Insert, Update, delete Read More »
INTRODUCTION TO FNDLOAD CONFIGURATION FILE The contents of the configuration file are at the heart of the loader operation since they specify the structure of the data and the access methods to use to move the data between the data file and a database. A configuration file has the form: configuration_file ::= item { item
