Oracle Tablespace - Basic

This was presentation about Oracle Tablespace for Advanced Database lab.

# Eryk Budi Pratama

1. Oracle Database Tablespace Eryk Budi Pratama – Dimas Aryo Anggoro Advanced Database Lab Informatics Engineering –Bakrie University

2. Tablespace Oracle stores data logically in tablespaces and physically in datafiles associated with the corresponding tablespace .

3. List tablespaces select * from user_free_space ;

4. Create Tablespace Create tablespace nama-tablespace datafile ‘nama-datafile.dat ’ size 2M autoextend on next 500K maxsize 4M ;

5. Altering Tablespace alter database datafile ‘nama-datafile.dat’ resize 6 M ;

6. Adding Datafile alter tablespace dataku add datafile ‘nama-datafile.dat’ size 2M;

7. Drop Tablespace drop tablespace nama-tablespace including contents;

8. Create User create user nama_user identified by password-user default tablespace dtpraktek ;

9. Grant & Resource grant connect to user01; grant resource to user01;

10. Q&A