alter tablespace : Table space « Table « Oracle PL / SQL

  1. Oracle PL / SQL
  2. Table
  3. Table space




alter tablespace

  

SQL> alter tablespace RBS
  2  default storage
  3  (initial 125K next 125K minextents 18 maxextents 249)
  4
SQL>










Related examples in the same category

1.Change user default table space and temporary table space
2.Get default table space for current user
3.Moving Tables To New Tablespaces or Storage
4.heap table
5.Show_space
6.Check space with show_space for an index with compress 1
7.Check space with show_space for an index with compress 2
8.Create two indexes on one table and check the space
9.Map user objects to tablespaces.
10.Measure the fragmentation of free space in all of the tablespaces in a database
11.The plsql user is created using the USERS and TEMP tablespace.