Oracle Tablespaces – KTEXPERTS

Oracle Tablespaces Articles

3 years ago by KTEXPERTS TEAMOracle Tablespaces

Dear Readers, Please check the below articles to get good knowledge on Oracle Tablespaces. SNO Article Name Article Link 1 Tablespace Management in Oracle. https://www.ktexperts.com/tablespace-management-in-oracle/ 2 Oracle : Storage Management https://www.ktexperts.com/oracle-storage-management/ 3 Transportable Tablespace between two pluggable database(PDB’s) https://www.ktexperts.com/transportable-tablespace-between-two-pluggable-databasepdbs/ 4 ORACLE: Cross Platform Transportable Tablespace… Read More

Tablespace Management in Oracle.

6 years ago by Binnary Ajay KumarOracle DB Admin

Tablespace Management in Oracle. A Tablespace is a logical storage unit within an Oracle database. It is logical because a table space is not visible in the file system of the machine on which the database resides. A table space, in turn, consists of at… Read More

Easy way to perform Transportable tablespace across platforms.(Video included)

6 years ago by Binnary Ajay KumarOracle DB Admin

Easy way to perform Transportable tablespace across platforms. Transportable Tablespace feature was introduced in Oracle 8i to transfer large amount of data between the oracle databases. In Oracle 10g this useful feature was enhanced with cross-platform support which allowed a tablespace, or set of tablespaces, to be… Read More

Transportable Tablespace between two pluggable database(PDB’s)

6 years ago by Binnary Ajay KumarOracle 12C New Features

Dear Readers, In this article, we will see the following Transportable Tablespace between two pluggable database(PDB’s). This article discusses simple example of performing TTS (Transportable Tablespace) across two pluggable databases in a same container. Transportable tablespaces(T-Ts) is used to move the data from one database… Read More

Oracle : Storage Management

7 years ago by SoundharyaOracle DB Admin

STORAGE MANAGEMENT In oracle, database space demanding objects are called segments. There are 5 different segments i.e. tables, indexes, temporary, undo, rollback segments. Within a single server, we can create multiple database. Database contains one or more tablespace. One tablespace can… Read More

ORACLE: Cross Platform Transportable Tablespace

7 years ago by SUMAN MORAOracle DB Admin

Cross Platform Transportable Tablespace Transportable Tablespace is used to move a large amount of data between databases where the tablespace is copied from source database to the target database. A Tablespace can be Transport between databases on the same Platform from version 8i.… Read More

Oracle : TRANSPORTABLE TABLESPACE IN ORACLE

7 years ago by SoundharyaOracle DB Admin

TRANSPORTABLE TABLESPACE IN ORACLE Transportable Tablespace is used to move large amount of data between… Read More

Oracle : USER MANAGEMENT

8 years ago by DayakerOracle DB Admin

USER MANAGEMENT How to create user? Syntax sys>> create user <username> identified by <password>; Create user u1 identified by u1; How to assign the privileges to user? Grant connect,resource to u1; How to assign the tablespace to user? Alter user u1 default tablespace userdata; How… Read More

Oracle : TABLESPACE MANAGEMENT

8 years ago by DayakerOracle DB Admin

TABLESPACE MANAGEMENT WHAT IS TABLESPACE ? IT’S A LOGICAL LINK BETWEEN USER AND DATAFILES.IT IS LOGICAL STORAGE OF DATA DICTIONARY: EXTENTS INFORMATION WILL GET FROM BASE TABLES LOCAL: EXTENTS INFORMATION WILL GET FROM DATAFILE HEADERS TABLESPACE MANAGEMENT HOW TO CREATE THE TABLESPACE SYS>>… Read More

Oracle : Query to find how much space can be reclaimed from each datafile

8 years ago by Vinod SiramOracle DB Admin

set linesize 1000 pagesize 0 feedback off trimspool onwithhwm as ( — get highest block id from each datafiles ( from x$ktfbue as we don’t need all joins from dba_extents ) select /*+ materialize */ ktfbuesegtsn ts#,ktfbuefno relative_fno,max(ktfbuebno+ktfbueblks-1) hwm_blocks from sys.x$ktfbue group by ktfbuefno,ktfbuesegtsn),hwmts as… Read More