Monthly Archives: February 2022
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...
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...
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...
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...
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...