Variables in Python Identifiers: Identifiers are used to identify an entity uniquely in a program at the time of execution. Examples: class names, function names, variable names etc. Variable:Variable is a name given to a memory location that is used to hold a value. Ex:… Read More
Python – Datatypes 👇👇👇👇 Please check the below link for the full document 👇👇👇👇 https://www.ktexperts.com/wp-content/uploads/2022/12/datatypes.pdf Author : Teja LinkedIn : https://www.linkedin.com/in/teja-sai-nadh-reddy-tatireddy-048882201 Thank you for giving your valuable time to read the above information. Please click here to subscribe for further updates KTExperts is… Read More
PYTHON INTRODUCTION WHAT IS PYTHON Python is a high-level, interpreted, interactive and object-oriented scripting language developed by Guido Van Rossum. Python is a powerful, flexible and easy to use scripting language. FEATURES OF PYTHON: Free & Open Source Python language is freely available at the… Read More
Datapump export and import from Source PDB to Target PDB. Source : SQL> alter session set container=OGGDB1PDB; Session altered. SQL> select username from dba_users where oracle_maintained=’N’; USERNAME ——————————————————————————– PDBADMIN HR SQL> select table_name from dba_tables where owner=’HR’; TABLE_NAME ——————————————————————————– REGIONS LOCATIONS DEPARTMENTS JOBS EMPLOYEES JOB_HISTORY… Read More
Pluggable database save state Automate Pluggable DB opening during Container instance startup PDB Saved State is a feature in 12.1.0.2 for saving the OPEN state of all PDBS when CDB is restarted. This is for preserving the state of a Pluggable database proir to CDB… Read More
Oracle,Pluggable Different ortypes of creating Pluggable Database manually There are multiple ways to create a pluggable database, in this article we would go through the process of creating PDB manually as in certain cases where GUI model is not feasible as creating a PDB using… Read More
CLONE ORACLE 12c PLUGGABLE DATABASE INTO ANOTHER CDB In this article we will learn how to clone oracle 12c pluggable database (SHOPDB1) from one container database (SHOCDB1) to another container database (SHOCDB2), using the DBLINK The 3 main steps that we will do to clone… Read More
CLONE ORACLE 12c PLUGGABLE DATABASE IN SAME CDB In This article we will learn how to clone Oracle 12c pluggable database [SHOPDB2] from another oracle 12c pluggable database [SHOPDB1] in the same container database [SHOCDB1] using FILE_NAME_CONVERT parameter. 👇👇👇👇 Please check the below link… Read More
CREATE ORACLE 12c PLUGGABLE DATABASE MANUALLY In this article, we will learn how to create oracle 12c pluggable database (SHOPDB1) from seed pluggable database (PDB$SEED) in the same container database (SHOCDB1) using the manual command 👇👇👇👇 Please check the below link for the… Read More
CREATE & DROP ORACLE 12c PLUGGABLE DATABASE WITH DBCA In this article, we will learn how to create and drop oracle 12c pluggable database PDB (SHOPDB1) from seed pluggable database PDB (PDB$SEED) in the same container database (SHOCDB1) with oracle database configuration assistant… Read More
CONVERT ORACLE 12c SINGLE NODE RAC DATABASE TO ORACLE 12c 2-NODE RAC DATABASE In the PHASE 1 we have seen how to convert the 12c single standalone database to RAC database. check below link for PHASE 1 article. https://www.ktexperts.com/convert-oracle-12c-standalone-database-to-oracle-12c-rac-database/ And now In PHASE 2… Read More
CONVERT ORACLE 12c STANDALONE DATABASE TO ORACLE 12c RAC DATABASE In this article we have Oracle 12c Single Standalone Database running on SERVER [SHOMAC1] and will be converted it into 2 Node 12c RAC Database running on SERVER [19cRACNODE1/2]. In our test environment, Oracle 12c… Read More
12c NON-CONTAINER DATABASE TO 19c PLUGGABLE DATABASE CLONE→UPGRADE→CONVERT In this article, we are converting a 12c non-container oracle database to 19c container database using cloning a REMOTE NONCDB. With this there is an oracle version change from 12c to 19c, so we will upgrade the… Read More
Dear Readers, In this article, we will see the Upgradation Of The Oracle Database From 12c To 19c. Manual Command-Line Upgrade (DB UPGRADE) In this article, I have followed the steps to directly upgrade the non-container database from 12c to 19c because a direct upgrade… Read More
WHAT YOU NEED TO ACHIEVE A JOB? 👉Getting a job as a fresher or experienced seems extremely daunting post-COVID crisis. There is cutthroat competition in the job market, and freshers are always disadvantaged due to this. 👉Nevertheless, landing a job is far from impossible if… Read More
Hello Everyone, The below script will help us to find number of processes runs in the background and send us alerts based on warning and critical thresholds. Script : # ]$ cat /home/oracle/DBA/bin/running_process.sh #!/bin/bash # Syntax to run this script # ./running_process.sh oracle 100 170… Read More
PostgreSQL Articles Dear Readers, Please check the below list of PostgreSQL Articles SNo Description Link 1 Installation of PostgreSQL 11.4 On Windows Platform https://www.ktexperts.com/installation-of-postgresql-11-4-on-windows-platform/ 2 How to Download and Install the pgAdmin 4 https://www.ktexperts.com/how-to-download-and-install-the-pgadmin-4/ 3 Installation of PostgreSQL 11.4 in Linux Platform. https://www.ktexperts.com/installation-of-postgresql-11-4-in-linux-platform/ 4 Install… Read More
PostgreSQL Interview Q&A Part-3 Before going into the article, please check our previous article on PostgreSQL Q&A Part-2 1. Can we have different data directories for PostgreSQL Cluster? Under One PostgreSQL installation, you can create multiple Clusters. Each Cluster will have its own data directory. One… Read More
Hello Everyone, This article will help you learning basic commands in postgreSQL. Psql is an interactive terminal to work with the PostgreSQL database. It is used to retrieve data from the PostgreSQL database server faster and more effectively. The below commands are very helpful for… Read More
Tablespace Administration in Postgres – Q&A 1. What is tablespace in Postgres? A. It specifies in which location contents of the tables should be stored. We can’t use a database without tablespace Default tablespace is pg_default Users while creating objects can specify on which tablespace… Read More
