Table space « Table « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Table
  3. Table space
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.alter tablespace




10.Map user objects to tablespaces.
11.Measure the fragmentation of free space in all of the tablespaces in a database
12.The plsql user is created using the USERS and TEMP tablespace.