Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Oracle DBA Tutorial 4 - How to create tablespace (with autoextend on), datafile, user and grant. That video is uploaded by Chirags Tutorial at 2022-06-05T08:43:01-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [SSIPOi6udpg]
| Name | Oracle DBA Tutorial 4 - How to create tablespace (with autoextend on), datafile, user and grant |
| Video Uploader | Video From Chirags Tutorial |
| Upload Date | This Video Uploaded At 05-06-2022 15:43:01 |
| Video Discription | inchirags@gmail.com Chirag's Oracle DBA Tutorial https://www.chirags.in ***************************************************************************************** * 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. SQL⇒ CREATE TABLESPACE testdb DATAFILE 'C:\APP\CHIRAG\ORADATA\ORCL\testdb01.dbf' size 1G autoextend on; 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. 3. Now check in path that 'testdb01.dbf' file is created or not. 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: 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 SSIPOi6udpg |
| Category | Education |
| Tags | Oracle 11g R2 | Chirag's Tutorials | Chirag's DBA Tutorials | Chirag's Oracle DBA Tutorials | Oracle 11g R2 Tutorial | Oracle 11g R2 Installation | Oracle 11g R2 Installation Process | Oracle 11g R2 Installation Process Step by Step | Oracle 11g R2 in Windows | Oracle 11g R2 Tutorial in Windows | Oracle 11g R2 Installation in Windows | Oracle 11g R2 Installation Process in Windows | Oracle 11g R2 Installation Process Step by Step in Windows |
