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], "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>
> > 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>
> > > 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]
>
