saya biasa menggunakan cara begini (tricky) : 1. buat tabel 2. masukkan 1 baris kesemua kolom ( jangan ada kolom yang diisi null ), dan kalau bisa masukkan nilainya sesuai dengan maksimum value yang bisa ditampung kolom tsb. 3. lakukan perintah "analyze table <nama tabel> compute statistics" 4. lakukan query "select avg_row_len from user_Tables where table_name='<nama tabel' " maka anda akan dapatkan 1 record length dalam satuan bytes, untuk tau berapa besar ukuran tabel ya tinggal kali dengan jumlah baris (estimasi aja). semoga membantu
Toni Iskandar <[EMAIL PROTECTED]> wrote: Dear Millis, saya mau tanya bagaimana caranya untuk mengetahui ukuran record length dari suatu table dan besarnya data dari suatu table. terimakasih. [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.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com SPONSORED LINKS Membership database software Database mortgage software Pda database software Database management software Oracle database administration Oracle database management --------------------------------- YAHOO! GROUPS LINKS Visit your group "indo-oracle" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click. [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/u8TY5A/tzNLAA/yQLSAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- 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/
