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

Поделиться
HTML-код
  • Опубликовано: 10 сен 2024

Комментарии • 39

  • @chiengdorkcy4851
    @chiengdorkcy4851 9 месяцев назад

    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
    @ShivalayaRattan 3 года назад +2

    This is what explanation is. Very detailed and clear.

    • @dbagenesis
      @dbagenesis  3 года назад

      Thank you! Keep Watching

  • @reshmioracle7852
    @reshmioracle7852 4 года назад +3

    Understood the concepts really well. Thanks for the video

  • @navin681
    @navin681 5 лет назад +2

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

    • @dbagenesis
      @dbagenesis  3 года назад

      Thank you! Keep watching

  • @shubhamgupta4682
    @shubhamgupta4682 7 лет назад +4

    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 :)

  • @ritasarma6591
    @ritasarma6591 2 года назад +1

    Very good explanation! Thanks!

  • @ziadfawzi
    @ziadfawzi Год назад +1

    Thank you so much.

  • @balajichandramohan5117
    @balajichandramohan5117 2 года назад

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

  • @hemantkumar5578
    @hemantkumar5578 5 лет назад +2

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

    • @sagarvyas3776
      @sagarvyas3776 4 года назад

      Db will not allow you to drop the temporary tablespace as it is default temp tbs..

  • @simbarashevhovha8401
    @simbarashevhovha8401 3 года назад +1

    Thanks for this good and helpful tutorial

  • @shayansarkar7570
    @shayansarkar7570 2 года назад

    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 ?

  • @yassir07
    @yassir07 5 лет назад +1

    intersting Course..
    could any one provide me the query for Checking-tablespace-utilization ?

  • @dudeoo2007
    @dudeoo2007 4 года назад

    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?

  • @nabrcnatureaquaculturebiof4172
    @nabrcnatureaquaculturebiof4172 5 лет назад +1

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

  • @yvesco87
    @yvesco87 7 лет назад

    You are very good
    Please more videos

  • @yatheeshkumar294
    @yatheeshkumar294 2 года назад

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

  • @sandeepkumar-dw6xq
    @sandeepkumar-dw6xq 5 лет назад +1

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

    • @dbagenesis
      @dbagenesis  5 лет назад +1

      Goto support.dbagenesis.com/ and search for tablespace to get all the tablespace related scripts

  • @vinayakbudapanahalli192
    @vinayakbudapanahalli192 6 лет назад

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

  • @sirdomino1000
    @sirdomino1000 7 лет назад

    Hi where can we get the script ? Thank you

    • @dbagenesis
      @dbagenesis  7 лет назад +1

      oraclegenesis.com/blog/528688/how-to-check-tablespace-utilization-in-oracle

    • @sirdomino1000
      @sirdomino1000 7 лет назад +1

      THHHHHHAAAANNNNNNKKKKKKKKKKKKK YYYYYYYYYYYYYYYYYYYYYYOUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUuu

    • @nagarjunamekala3194
      @nagarjunamekala3194 6 лет назад

      for some reason I can't access to your blog. and also to above link. Getting error like "SSL handshake failed" Can you help me to get into your blog?

    • @nagarjunamekala3194
      @nagarjunamekala3194 6 лет назад

      Hi Genesis,
      I can't open the links of oraclegenesis.com sites, getting "ssl connection not establishing" error. Please try to resolve this issue.
      Thanks.

    • @yashs7445
      @yashs7445 6 лет назад

      same here cannot open any links or any web page