2 Replies Latest reply: Mar 28, 2012 12:23 AM by 912595 RSS

    tablespaces

    926829
      How do i create the following tablesaces:


                system
                sysaux          
                temp
                undo
                tools
                users
                data
                index
        • 1. Re: tablespaces
          415289
          most of tablespace from below list are created by default(like system,sysaux,undo,temp) when you create the database.
          if you like to create tablespace manually like data,index .here is the command.


          http://www.adp-gmbh.ch/ora/sql/create_tablespace.html
          • 2. Re: tablespaces
            912595
            923826 wrote:
            How do i create the following tablesaces:


                      system
                      sysaux          
                      temp
                      undo
                      tools
                      users
                      data
                      index
            All tablespace except Data and Index are created by default when you create 10g or later database.
            Please post database relted questions to Forum Home » Database » Database - General