Oracle

How to Migrate Non-CDB to CDB - With Downtime

Step 1:Non-CDB Instance1.1 Open Non-CDB in Read-Only Mode1.2 execute dbms_pdb.describe and generate the PDB Description XML File1.3 Shutdown Non-CDB Instance Step 2: Target CDB2.1. Check the PDB description compatibiliydbms_pdb.check_plug_compatibility2.2. Confirm if any voilations are there pdb_plug_in_violation view for this PDBAll Voilations should be fixed except execute non-cdb_to_pdb.sql2.3. Create pluggable database using PDB Description XML FileOptions:COPY – This will copy all
Read More »

---

How to Access Control Lists (ACL) in Oracle

What is Access Control Lists(ACL) in Oracle? Oracle allows access to external network services using several PL/SQL APIs (UTL_TCP, UTL_SMTP, UTL_MAIL, UTL_HTTP and UTL_INADDR), all of which are implemented using the TCP protocol. In previous versions of the database, access to external services was effectively an on/off switch based on whether a user was granted execute permissions on a specific
Read More »

---

How to rotate listener log online

How to rotate listener log online In oracle listener log file contains a lot of useful information, like the program which was used for the connection, the IP address where the connection is coming from, the OS user which was used on the client and we can add many more to be recorded. Since it records more information the log
Read More »

---

How to get DDL in Oracle

We can get the DDL of an object using GET_DDL() It is a function of metadata package DBMS_METADATA. Syntax: select DBMS_METADATA.GET_DDL(‘TABLE’,'<table_name>’) from DUAL; Example: MUDHALVAN@UPGR:SQL> set long 1000 MUDHALVAN@UPGR:SQL> set pagesize 0 MUDHALVAN@UPGR:SQL> select DBMS_METADATA.GET_DDL(‘TABLE’,’EMP’) from DUAL; Output: CREATE TABLE “MUDHALVAN”.”EMP” ( “ENO” NUMBER(10,0) NOT NULL ENABLE, “ENAME” VARCHAR2(20), “DOB” DATE, CONSTRAINT “EMP_PK” PRIMARY KEY (“ENO”) USING INDEX PCTFREE 10
Read More »

---