Oracle Tablespace - Basic

proferyk 2,498 views 14 slides Jun 05, 2013
Slide 1
Slide 1 of 14
Slide 1
1
Slide 2
2
Slide 3
3
Slide 4
4
Slide 5
5
Slide 6
6
Slide 7
7
Slide 8
8
Slide 9
9
Slide 10
10
Slide 11
11
Slide 12
12
Slide 13
13
Slide 14
14

About This Presentation

This was presentation about Oracle Tablespace for Advanced Database lab.

# Eryk Budi Pratama


Slide Content

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

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

List tablespaces select * from user_free_space ;

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

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

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

Drop Tablespace drop tablespace nama-tablespace including contents;

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

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

Q&A