How to work with Tablespaces in Real-Time? Tablespace Administration

A #tablespace is an allocation of space in an #Oracle #database where schema objects are stored. Watch this video to understand how to #administer tablespaces inside oracle database.

00:00 Tablespace Best Practices
05:58 Tablespace Utilization
10:50 Tablespace Threshold
15:07 Tablespace Alert Mechanism
17:13 Utilization Report
30:23 Temp Tablespaces Handling
37:09 Find Datafiles of a Tablespace
38:15 Extend Datafile
44:04 Add Datafile
46:37 Reclaiming space from Datafile
52:34 Drop a Datafile
53:54 Drop Tablespace
59:04 Drop an empty Datafile

[chiengdorkcy]

Thank you so much DB Genesis for more information about Tablespace. I am Junior DBA tasked to managed Tablespaces. So you make everything's clear in this sessions.

[ShivalayaRattan]

This is what explanation is. Very detailed and clear.

[reshmioracle]

Understood the concepts really well. Thanks for the video

[shubhamgupta]

your way of explaining things is awesome... really benefited a lot from all courses that i took from you.. thanx a tonn for your support and help :)

[navin]

Awesome....great patience...clear and understanding ...thnks

[simbarashevhovha]

Thanks for this good and helpful tutorial

[balajichandramohan]

In Add Space to Tablespace, could you please explain when to resize existing datafile and when to add datafile to tablespace.

[yvesco]

You are very good
Please more videos

[yassir]

intersting Course..
could any one provide me the query for ?

[nabrcnatureaquaculturebiof]

Thanks Alistair
Please make an other video to up grade 11g 12c

[shayansarkar]

Why should we add space to DR if it's done in Prod? It will automatically get added in DR
Can u pls explain this ?

[hemantkumar]

Hi all,
If i deleted the temporary tablespace, then can i open the Database ¿¿ or while opening its will show missing temporary file

[dudeoo]

When u reclaim space from datafile, how are you sure that the space reclaimed by resizing the datafile, you are not tampering the part of file where data is present?

[sandeepkumar-dwxq]

can you share the scripts or the link for the scripts to copy them

[vinayakbudapanahalli]

Could you share the commands.txt file with us, if no concerns

[sirdomino]

Hi where can we get the script ? Thank you

[yatheeshkumar]

after resizing showing error ORA-01916: keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected, kindly help us