7/21/2019 tugas 1 ABD

1/1

no 1

.1.create folder/home/derpinai/Mahasiswa

/home/derpinai/mahasiswa1

*derpinai adalah nama local directory, bisa diganti sesuai dengan nama local directory laptop anda.

2.create db MHS on /home/derpinai/Mahasiswa dbpath on /home/derpinai/mahasiswa1 pagesize 16 K catalog tablespace managed by system using ('katalog') user tablespace managed by database using (file 'c0000.usr' 16000,file 'c0001.usr' 16000) temporary tablespace managed by system using ('temporary')

no 2

1. connect db mhs

2.create bufferpool bp1 size 4 K

3.create large tablespace tblspc1 managed by database using (file 'c0002.idx' 16M) bufferpool bp1