Pak Bowo,
Please jangan panggil saya Om, saya masih umur 17 thn :)
On 11/6/07, Yulius Wibowo <[EMAIL PROTECTED]> wrote:
>
> Hehehe,
> salah keyword salah persepsi ... :-)
>
> Betul yg Om Yoel Susanto bilang.
>
> Bisa dicoba,...
> setelah menghapus seluruh data dari table ybs + commit, jalankan:
>
> SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS
> ('table_ownernya','nama_table');
>
> atau
> SQL> ANALYZE TABLE nama_table COMPUTE STATISTICS;
>
> lalu
> SQL> SELECT table_name, num_rows FROM user_tables;
> Pasti nilai num_rows nya 0 ... dijamin!
>
> Perlu dicatat, nilai2 yg ada di user_tables, bersifat statis,
> hanya akan di rubah/reset setelah dijalankan
> DBMS_STATS.GATHER_TABLE_STATS, atau DBMS_STATS.GATHER_SCHEMA_STATS
> atau DBMS_STATS.GATHER_DATABASE_STATS atau ANALYZE TABLE.
>
> CMIIW,
> Bw
>
> --- In [email protected] <indo-oracle%40yahoogroups.com>, "Yoel
> Susanto" <[EMAIL PROTECTED]>
> wrote:
> >
> > ROW_NUMS atau NUM_ROWS ??? Di user_tables cuman ada NUM_ROWS.
> >
> > NUM_ROWS adalah jumlah record yang ada di table tersebut. Nilai
> tersebut
> > adalah hasil gather statistic. Setelah delete, gather ulang
> statistic table
> > tersebut, pasti nilainya akan 0.
> >
> > CMIIW
> >
> > On 11/6/07, Oscar Wilyanto <[EMAIL PROTECTED]> wrote:
> > >
> > > kalau informasi 'row_nums' yang ada di 'user_tables' itu apa
> yah?
> > > soalnya saat semua row di suatu tabel didelete nilai 'row_nums'
> disana tidak
> > > otomatis jadi 0.
> > >
> > > Ketika tabel sudah terisi lagi dengan record2 baru dan kita
> melakukan
> > > query dengan sorting menurut rownumnya, sortingya kok ngaco yah?
> maksudnya
> > > urutan record hasil querynya tidak seperti urutan saat record
> masing2 record
> > > dimasukan (berantakan).
> > >
> > > ----- Original Message -----
> > > From: Yoel Susanto
> > > To: [email protected]
> > > <indo-oracle%40yahoogroups.com><indo-oracle%40yahoogroups.com>
> > > Sent: Tuesday, November 06, 2007 10:09 AM
> > > Subject: Re: [indo-oracle] reset rownum
> > >
> > > ROWNUM itu pseudo column, tidak bisa di reset.
> > >
> > > Seperti kata Pak Yulius,ROWNUM adalah nomor urut dari hasil
> query.
> > >
> > > On 11/6/07, Bernard Situmeang <[EMAIL PROTECTED]<bsjsitumeang%
> 40yahoo.com>>
> > > wrote:
> > > >
> > > > Hallo Oscar,
> > > >
> > > > Coba kau truncate table tsb (truncate table...), rownumnya
> akan direset.
> > > >
> > > > selamat mencoba..
> > > >
> > > > salam
> > > >
> > > > Bernard Situmeang
> > > >
> > > > ----- Original Message ----
> > > > From: Oscar Wilyanto <[EMAIL PROTECTED] <oscar%40mkdgroup.com><oscar%
> 40mkdgroup.com>>
> > > > To: [email protected]
> > > > <indo-oracle%40yahoogroups.com><indo-oracle%
> 40yahoogroups.com><indo-oracle%40yahoogroups.com>
> > > > Sent: Monday, November 5, 2007 11:13:20 AM
> > > > Subject: [indo-oracle] reset rownum
> > > >
> > > > Dear masters,
> > > >
> > > > mo nanya donk, gimana sih caranya reset rownum disuatu table?
> > > >
> > > > masalahnya setiap table habis didelete habis (no rows), trus
> diisi lagi
> > > > rownumnya tidak mulai dari nol lagi..
> > > >
> > > > thanks
> > > > Oscar
> > > >
> > > > ------------ --------- --------- --------- --------- ---------
> -
> > > > This message contains confidential information and is intended
> only for
> > > > the
> > > > individual named. If you are not the named addressee you
> should not
> > > > disseminate, distribute or copy this e-mail. Please notify the
> sender
> > > > immediately by e-mail if you have received this e-mail by
> mistake and
> > > > delete
> > > > this e-mail from your system. E-mail transmission cannot be
> guaranteed
> > > to
> > > > be
> > > > secure or error-free as information could be intercepted,
> corrupted,
> > > lost,
> > > > destroyed, arrive late or incomplete, or contain viruses. MKD
> Group
> > > > therefore
> > > > does not accept liability for any errors or omissions in the
> contents of
> > > > this
> > > > message, which arise as a result of e-mail transmission. If
> verification
> > > > is
> > > > required please request a hard-copy version.
> > > >
> > > > MKD Group, www.mkdgroup. com
> > > > ------------ --------- --------- --------- --------- ---------
> -
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > > Send instant messages to your online friends
> > > http://uk.messenger.yahoo.com
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > >
> > > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > > ----------------------------------------------------------
> > > This message contains confidential information and is intended
> only for
> > > the
> > > individual named. If you are not the named addressee you should
> not
> > > disseminate, distribute or copy this e-mail. Please notify the
> sender
> > > immediately by e-mail if you have received this e-mail by
> mistake and
> > > delete
> > > this e-mail from your system. E-mail transmission cannot be
> guaranteed to
> > > be
> > > secure or error-free as information could be intercepted,
> corrupted, lost,
> > > destroyed, arrive late or incomplete, or contain viruses. MKD
> Group
> > > therefore
> > > does not accept liability for any errors or omissions in the
> contents of
> > > this
> > > message, which arise as a result of e-mail transmission. If
> verification
> > > is
> > > required please request a hard-copy version.
> > >
> > > MKD Group, www.mkdgroup.com
> > > ----------------------------------------------------------
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
[Non-text portions of this message have been removed]
