Oracle Tablespaces Articles

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

Oracle : Storage Management

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 : USER MANAGEMENT

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

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