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/...

Transportable Tablespaces Transportable tablespaces were introduced in Oracle 8i to allow whole tablespaces to be copied between databases in the time it takes to copy the datafiles. In Oracle 8i one of the restrictions was that the block size of both databases must be the same. In Oracle 9i the introduction of multiple block sizes has removed this restriction. In this article I will run through a simple example of transporting a tablespace between two databases. Setup For this example I'm going to create a new tablespace, user and table to work with in the source database. CONN / AS SYSDBA CREATE TABLESPACE test_data DATAFILE '/u01/app/oracle/oradata/DB11G/test_data01.dbf' SIZE 1M AUTOEXTEND ON NEXT 1M; CREATE USER test_user IDENTIFIED BY test_user DEFAULT TABLESPACE test_data TEMPORARY TABLESPACE temp QUOTA UNLIMITED ON test_data; GRANT CREATE SESSION, CREATE TABLE TO test_user; CONN test_user/test_user CREATE TABLE test_tab ( id NUMBE...

What is a PARTITION in Oracle?Why to use Partition And Types of Partitions PARTITIONS Partitioning allows tables, indexes, and index-organized tables to be subdivided into smaller pieces, enabling these database objects to be managed and accessed at a finer level of granularity. When to Partition a Table?? Tables greater than 2 GB should always be considered as candidates for partitioning. Tables containing historical data, in which new data is added into the newest partition. A typical example is a historical table where only the current month's data is updatable and the other 11 months are read only. When the contents of a table need to be distributed across different types of storage devices. TYPES 1       Range partitions 2       List partitions 3       Hash partitions 4       Sub partitions     ADVANTAGES OF PARTITIONS   Redu...

Oracle Multitenant Option - 12c : Frequently Asked Questions Oracle Multitenant Option - 12c : Frequently Asked Questions. APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.1 [Release 12.1] Information in this document applies to any platform. PURPOSE  To document many aspects & usages of pluggable database for better understanding and quick references of this product. QUESTIONS AND ANSWERS General CDB / PDB Concept in  12c Multitenant Architecture What is a pluggable database (PDB) in Multitenant Architecture? Pluggable Databases (PDBs) is new in Oracle Database 12c Release 1 (12.1). You can have many pluggable databases inside a single Oracle Database occurrence. Pluggable Databases are fully backwards compatible with an ordinary pre-12.1 database. Why would I consider using the Multitenant option ? You should consider following Database Consolidation Goals to achieve: Reduce Total Cost of Operation ...