Anda pakai Oracle versi berapa ya ? Kebetulan saya test di Oracle9i/10G ...
Kalau Oracle 8/8i memang belum ada option AND DATAFILES Bowo --- In [email protected], Handoko <[EMAIL PROTECTED]> wrote: > > Pak bowo saya sudah coba step yang bapak berikan' > tapi kok muncul error ORA 02173, apa ya kira-kira penyebabnya..? > > thanks > > -----Original Message----- > From: [email protected] [mailto:indo- [EMAIL PROTECTED] On > Behalf Of Yulius Wibowo > Sent: Tuesday, June 14, 2005 3:45 PM > To: [email protected] > Subject: [indo-oracle] Re: Tablespace > > Pakai option AND DATAFILES > > SQL> drop tablespace my_data including contents AND DATAFILES cascade > constraints ; > > Bowo > > > > --- In [email protected], Handoko <[EMAIL PROTECTED]> wrote: > > Mas-mas pendahulu oracle Tanya lagi ya..? > > > > Kenapa ya waktu saya drop tablespacenya kok datafilenya tidak > terhapus > > juga.. apakah saya salah buat tablespacenya? saya drop dengan scrip > sbb : > > > > drop tablespace my_data including contents cascade constraints ; > > > > bagaimana cara untuk menghapus manual datafile yang belum > terhapus..? > > > > thanks atas pencerahan dari mas-mas semua.. > > > > handoko > > > > -----Original Message----- > > From: [email protected] [mailto:indo- > [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 > > > > > > > > > [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/
