February 2022

2 min read

Oracle

Creating pluggable database from another pdb, when pdb$seed in in mount state

asrblogger

SQL> create pluggable database PDB1 from DEV1 create_file_dest='+DEV_DG_FLASH'; Pluggable database created. SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ----------...

1 min read

SQL

Data Consistency

asrblogger

Data Consistency In Oracle Database, each user must see a consistent view of the data, including visible changes made by...

3 min read

SQL

Introduction to Oracle SQL

asrblogger

Structured Query Language (SQL) is the set of statements with which all programs and usersaccess data in an Oracle Database....

3 min read

SQL

Sample Schemas

asrblogger

In Oracle Database, a database schema is a collection of logical data structures, or schema objects. A database user owns...

crop unrecognizable man inserting flashcard into laptop slot

4 min read

Oracle

Datafiles in Oracle (Physical Storage)

asrblogger

Overview of Data Files At the operating system level, Oracle Database stores database data in structures called data files. Every...

6 min read

Oracle

Oracle Database 19c – Practical & Assignments

asrblogger

PARAMETER & PASSWORDFILE: * Create pfile from spfile to location '/home/oracle/init<sid.ora>' * Create password file with sys password as oracle1...

Creating pluggable database from another pdb, when pdb$seed in in mount state

Data Consistency

Introduction to Oracle SQL

Sample Schemas

Datafiles in Oracle (Physical Storage)

Oracle Database 19c – Practical & Assignments

Create Pluggable Database (PDB) Manually Using SQL Prompt Oracle 19c !!

How to check FRA ( Fast Recovery area) Utilization in Oracle ?

How to check Tablespace Utilization in Oracle ?

Install and Configure OpenSearch & OpenSearch Dashboard

You may have missed