SAP BASIS,HANA AND ORACLE DBA BLOGS

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