Change user default table space and temporary table space : Table space « Table « Oracle PL / SQL






Change user default table space and temporary table space

 

SQL> create user oracle_admin  identified by oracle_admin;

User created.

SQL>
SQL> grant create session, dba to oracle_admin;

Grant succeeded.

SQL>
SQL> alter user oracle_admin
  2      default tablespace users
  3      temporary tablespace temp;

User altered.

SQL>
SQL>
SQL> -- connect oracle_admin/oracle_admin;
SQL>
SQL> DROP USER oracle_admin;

User dropped.

SQL>
           
         
  








Related examples in the same category

1.Get default table space for current user
2.Moving Tables To New Tablespaces or Storage
3.heap table
4.Show_space
5.Check space with show_space for an index with compress 1
6.Check space with show_space for an index with compress 2
7.Create two indexes on one table and check the space
8.alter tablespace
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.