ALTER / MODIFY TABLESPACE | PART 2 | ORACLE ARCHITECTURE | RENAME | ADD /MODIFY DATAFILE | DROP

preview_player
Показать описание
This video will talk about modify an existing tablespace in oracle.
Use case
1) Adding Datafile: 02:00
2) Resize: 07:00
3) Rename Tablespace: 10:00
4) Rename Datafile :12:20
5) Drop Datafile and tablespace : 17:30

#oracle architecture
#architecture
#oracle 10g
#oracle 12c
#architecture high level overview
#login process
#oracle login process
#shared pool
#shared sql area
#data dictionary cache
#result cache
#library cache
#hot end
#medium end
#dirty end
#db_keep_cache_size
#db_recycle_cache_size
#java pool
#streams pool
#large pool
#program global area
#cursor state
#usersession data
#stackspace
#sort area
#others
#hash area
#system global area
#log writer
#database writer
#check point
#process monitor
#PMON
#System Monitor
#SMON
#Buffer pool
#Oracle
#Tamil
#DBA
#Database Administration
#temporary tablespace
#system tablespace
#sysaux tablespace
Рекомендации по теме
Комментарии
Автор

hello sir, can u tell me whwn can we use... alter system command and alter database command?

manandan
Автор

Nice explanation..how to reduce disk size - what are files we need to delete disk size full means?

powerofsilence
Автор

Bro, Can you explain RMAN concept with backup types and restore.

venkyvenky
Автор

nice bro. you showed your tablespace location in F drive. but i can't view my tablespace. my tablespace created at a path this is my path. how can i see my tablespace physically???

MuthuKumar-hxto