tugas 1 abd

Upload: pratiwi-susanti

Post on 12-Apr-2018

215 views

Category:

Documents


0 download

TRANSCRIPT

  • 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