In this video you will understand about the different types of tablespaces and their use/purpose. . Our Upcoming Online Course Schedule is available in the url below docs.google.com/spreadsheets/... Reach us at learn@tisyasolutions.com
Simply amazing way to teach oracle concepts in short and concise form. I could'nt find any other YoutTube video as good as your's. Thanks for sharing !! Please keep uploading more videos like DB creation, SQL performance tuning
How to know the given tablespace is temporary,permanent or undo. Suppose i created a temporary tablespace named latha,how can the other users know that it's a temporary tablespace. Any querry?
The contents column of dba_tablespaces will reveal the type of tablespace.... docs.oracle.com/cd/B19306_01/server.102/b14237/statviews_4157.htm#REFRN23287
Very informative, however i liked the earlier technique, as in these latest ones, graphics (before any new topic) interrupt the flow of your explanation. Its my personal view :)
Good afternoon sir, I have a some query. The question is, I have a database. Suppose one user u1 is updating 1lakh of records and he has not committed and the database is in undo_ retention_gurantee. And undo tablespace did not have free space. Other user u2 is selecting the data from database. Another user u3 is inserting 1million records in database. 3 users are executing stmts simultaneously. What error will get u3? Please reply answer as soon as possible