Thanks.. pak bowo atas pencerahannya.. Tapi saya pakai versi 8i, jadi klo membuat tablespace harus disertai dengan datafilenya ?.
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Yulius Wibowo Sent: Monday, June 13, 2005 6:35 PM To: [email protected] Subject: [indo-oracle] Re: Tablespace Anda bisa membuat tablespace TANPA menggunakan DATAFILE clause hanya jika : 1. Database version yg anda pakai versi 9i ke atas DAN 2. settingan OMF (Oracle Managed File) di aktifkan untuk mengetahui OMF aktif atau tidak: SQL> show parameter db_create_file_dest ?? adakah nilainya ??? kalau kosong artinya OMF tidak diaktifkan, anda bisa set nilainya sbb: Misal kalau lokasi dari datafiles-nya diset di d:\oradata, pastikan folder d:\oradata tsb sudah ada ... SQL> ALTER SYSTEM SET db_create_file_dest = 'd:\oradata'; lalu test SQL> CREATE TABLESPACE my_ts; Secara otomatis akan terbentuk file sebesar 100MB, dengan nama yg unique ... SQL> select tablespace_name, file_name, bytes from dba_data_files; Bowo --- In [email protected], Handoko <[EMAIL PROTECTED]> wrote: > Nanya lagi pak bowo. > > Waktu saya coba step yang pak bowo berikan..! > > SQL> CREATE TABLESPACE new_tablespace_name > DATAFILE 'd:\oradata\new_filename.dbf' SIZE 100M; > > Tablespace sukses dibuat, tapi ketika saya create tablespace dengan syntax > > SQL> CREATE TABLESPACE new_tablespace_name; > > Tablespace tidak sukses.. error missing datafile/tempfile clause. > > Yang saya tanyakan : > 1. kenapa waktu saya create tablespace tanpa datafile kok gak bisa?, > 2. apakah hubungan datafile dengan tablespace ? > > -----Original Message----- > From: [email protected] [mailto:indo- [EMAIL PROTECTED] On > Behalf Of Yulius Wibowo > Sent: Sunday, June 12, 2005 4:18 PM > To: [email protected] > Subject: [indo-oracle] Re: Tablespace > > 1. CREATE a new tablespace > > SQL> conn / as sysdba > > SQL> CREATE TABLESPACE new_tablespace_name > DATAFILE 'd:\oradata\new_filename.dbf' SIZE 100M; > > Verify > SQL> select name from V$TABLESPACE; > SQL> select tablespace_name, file_name, bytes from dba_data_files; > > 2. assign a new tablespace to user (as default tablespace) > SQL> conn / as sysdba > SQL> ALTER USER nama_user DEFAULT TABLESPACE new_tablespace_name; > > Set QUOTA-nya > SQL> ALTER USER nama_user QUOTA 10M ON new_tablespace_name; > > (apabila nama_user sudah mendapatkan privilege UNLIMITED TABLESPACE > maka perintah utk setting QUOTA di atas tidak berlaku/nggak berguna) > Verify > SQL> select username, default_tablespace from dba_users; > > 3. Me-non-aktifkan user system > 3.a dengan cara mengganti default passwordnya dengan password yg > HANYA diketahui oleh SYSDBA. > > SQL> conn / as sysdba > SQL> ALTER USER system IDENTIFIED BY new_password; > > 3.b dengan cara men-dissable account-nya > SQL> conn / as sysdba > SQL> ALTER USER system ACCOUNT LOCK; > > Bowo > > > > > > --- In [email protected], Handoko <[EMAIL PROTECTED]> wrote: > > Dear rekan-rekan Milis.. > > > > Mohon bantuannya... gimana cara membuat tablespace baru,dan kemudian > > tablespace itu di set default, > > Sehingga sewaktu kita create table, table tersebut langsung ke > masuk pada > > tablespace default. Dan bagaimana > > Cara menonaktifkan SySDBA dengan user : system password : manager , > maaf klo > > pertayaannya gak berbobot > > Coz saya ini newbie.. > > > > Thanks..atas respon ato pencerahan dari rekan-rekan milis. > > handoko > > > > > > [Non-text portions of this message have been removed] > > > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.blogspot.com > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > Yahoo! Groups Links > > > > > > > > [Non-text portions of this message have been removed] -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links [Non-text portions of this message have been removed] -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
