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:[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/
