priya

Oracle version number refers: 9 – Major database release number 3 – Database maintenance release number 0 – Application server release number 5 – Component Specific release number 0 – Platform Specific release number It seems there might be a misunderstanding in your version number. Oracle Database version numbers typically consist of a series of … Read more

A table is basic unit of data storage in Oracle database. A table contains all the accessible information of a user in rows and columns. In the context of Oracle Database, a table is a basic unit of data storage. It is a database object that stores data in rows and columns, similar to a … Read more

When the database is created in Oracle database system, it automatically generate a SYSTEM named SYSTEM tablespace. The SYSTEM tablespace contains data dictionary tables for the entire database. In Oracle, the SYSTEM tablespace is a special tablespace that is automatically created when a new database is created. It is used to store the data dictionary, … Read more

A database contains Logical Storage Unit called tablespaces. A tablespace is a set of related logical structures. Actually a tablespace groups related logical structures together. In Oracle, a tablespace is a logical storage container that is used to organize and manage the physical storage of data within a database. It is a collection of one … Read more

Components of logical database structure. Tablespaces Database’s schema objects In Oracle database, the logical database structure consists of the following components: Table: Tables are the basic unit of data storage in Oracle. They store data in rows and columns. View: A view is a virtual table that is based on the result of a SELECT … Read more