Oracle DBA Tutorial 3 - How to create tablespace (without autoextend on), datafile, user

[email protected] Chirag's Oracle DBA Tutorial https://www.chirags.in
*****************************************************************************************
* How to create tablespace (without 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 chirag is tablespace name. and also user is chirag. Creating datafile with size 1 GB.
SQL⇒ CREATE TABLESPACE chirag DATAFILE 'C:\APP\CHIRAG\ORADATA\ORCL\chirag01.dbf' size 1G;

Tablespace created. Now creating user for tablespace.

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

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

Grant succeeded.

3. Now check in path that 'chirag01.dbf' file is created or not.
Datafile is created with given size.

Note : Flow the Process shown in video.

?Subscribe and like for more videos:
https://www.youtube.com/channel/UCLdaO4-i_gxQMi87JwjKOwA
?Don't forget to, ?Follow, ?Like, ?Share ?&, Comment

Tutorial Link :
https://www.chirags.in/tutorials/oracle_database

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