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:
/ @chiragstutorial
💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment
Tutorial Link :
https://www.chirags.in/tutorials/orac...
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
Watch video Oracle DBA Tutorial 3 - How to create tablespace (without autoextend on), datafile, user online without registration, duration hours minute second in high quality. This video was added by user Chirags Tutorial 05 June 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 249 once and liked it 2 people.