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
Смотрите видео Oracle DBA Tutorial 3 - How to create tablespace (without autoextend on), datafile, user онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Chirags Tutorial 05 Июнь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 249 раз и оно понравилось 2 людям.