Oracle DBA Tutorial 4 - How to create tablespace (with autoextend on), datafile, user and grant

*****************************************************************************************
* How to create tablespace (with autoextend on), datafile, user and grant permission to user *
*****************************************************************************************

Autoextend Tablespace:
You can set a tablespace to automatically extend itself by a specified amount when it reaches its size limit. If you do not enable autoextend, then you are alerted when the tablespace reaches its critical or warning threshold size.

Steps: ---
1. Login to your Oracle Database. (sqlplus / as sysdba)
2. run the below commands.

Check the path of datafiles.
SQL⇒ select name from v$datafile;

You ll get the location of datafiles. So i ll create new datafile in same location.
Here testdb is tablespace name. and also user is testdb. Creating datafile with size 1 GB.

Tablespace created. Now creating user for tablespace.

SQL⇒ create user testdb identified by testdb default tablespace testdb;

User created. Now give the permission to user.
SQL⇒ grant dba to testdb;

Grant succeeded.

Datafile is created with given size. now check in oracle. file is created.

Note : Flow the Process shown in video.

😉Subscribe and like for more videos:
💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment

Tutorial Link :

Thanks & Regards,
Chitt Ranjan Mahto "Chirag"
_________________________________________________________________________________________
Note: All scripts used in this demo will be avilable in our website.
Link will be available in description.

#oracle
#oracletutorial
#chiragstutorial
#chiragsdatabasetutorial
#oracledatabase
#chiragsdbatutorial
#databasetutorial
#bestDatabaseTutorial
#oracletutorialchirags