SAP BASIS,HANA AND ORACLE DBA BLOGS

RDBMS vs ORDBMS  A Relational Database Management System (RDBMS) is a Database Management System (DBMS) that is based on the relational model. Most popular DBMSs currently in use are RDMSs. Object-Relational database (ORDBMS) is also a DBMS that extends RDBMS to support a broader class of applications and attempts to create a bridge between relational and object-oriented paradigms. As mentioned, earlier RDBMS is based on the relational model and data in a RDMS are stored in the form of related tables. So, a relational database can simply be seen as a collection of one or more relations or tables with columns and rows. Each column corresponds to an attribute of the relation and each row corresponds to a record that consists of data values for an entity. RDMSs are developed by extending hierarchical and the network models, which were two previous database systems. Main elements of a RDMS are the concepts of relational integrity and normalization. These concepts are based on t...

#different ways to create the pdb in oracle 12c 1)       You can create it by using dbca gui tool Database Configuration Assistant (DBCA) Below is the link for create on oracle-base https://oracle-base.com/articles/12c/multitenant-create-and-configure-pluggable-database-12cr1 2) Now another method is by creating manually Now for that you firstly have to log in into CDB$ROOT By using SQL> ALTER SESSION SET CONTAINER = CDB$ROOT; Now you have to create it manually by using command CREATE PLUGGABLE DATABASE PDB9 ADMIN USER PDB002_ADMIN IDENTIFIED BY oracle storage (maxsize 5G MAX_SHARED_TEMP_SIZE 500M) DEFAULT TABLESPACE sales datafile '/opt/app/oracle/sale.dbf' SIZE 250M AUTOEXTEND ON FILE_NAME_CONVERT = ('/opt/app/oracle/oradata/anand_poc/','/opt/app/oracle/new') FILE_NAME_CONVERT for new location of datafiles which it only create system and sysaux tablespace into the new locations that is from above command is ( /opt/...