February 2022 - ASRblogger

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

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 ---------- ------------------------------ ---------- ---------- 2 PDB$SEED MOUNTED 3 PDB1 MOUNTED 4…

asrblogger February 28, 2022No Comments

SQL

Data Consistency

Data Consistency In Oracle Database, each user must see a consistent view of the data, including visible changes made by a user's own transactions and committed transactions of other users.…

asrblogger February 22, 2022No Comments

SQL

Introduction to Oracle SQL

Structured Query Language (SQL) is the set of statements with which all programs and usersaccess data in an Oracle Database. Application programs and Oracle tools often allow usersaccess to the…

asrblogger February 22, 2022No Comments

SQL

Sample Schemas

In Oracle Database, a database schema is a collection of logical data structures, or schema objects. A database user owns a database schema, which has the same name as the…

asrblogger February 22, 2022No Comments

Oracle

Datafiles in Oracle (Physical Storage)

Overview of Data Files At the operating system level, Oracle Database stores database data in structures called data files. Every Oracle database must have at least one data file. Use…

asrblogger February 18, 2022No Comments

Oracle

Oracle Database 19c – Practical & Assignments

PARAMETER & PASSWORDFILE: * Create pfile from spfile to location '/home/oracle/init<sid.ora>' * Create password file with sys password as oracle1 * Create parameterfile in different location /u01 & start the…

asrblogger February 13, 2022No Comments

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

Trending Topics.

Get the Latest Blogging Tips Straight to Your Inbox!