dbapath947

Startup shutdown modes oracle database – Activity

In this post, we will perform an activity on startup and shutdown modes of Oracle database.The startup modes include startup open, startup mount, startup nomount and shutdown modes include shutdown abort, shutdown transactional, shutdown normal, shutdown immediate. Also read the startup and shutdown modes of Oracle database concept. Database shutdown modes They are of four …

Startup shutdown modes oracle database – Activity Read More »

Oracle 11g : Tablespace Management activity

The CREATE TABLESPACE statement is used to create a tablespace in Oracle database where schema objects are stored. The CREATE TABLESPACE statement can be used to create the 3 kinds of tablespaces: Permanent Tablespace Temporary Tablespace Undo Tablespace 1. Permanent Tablespace HOW TO CREATE A  NEW TABLESPACE SYS> SYS> create tablespace NEWTS datafile ‘/u01/TEST/newts01.dbf’ size …

Oracle 11g : Tablespace Management activity Read More »