di DBA_SEGMENTS bisa difilter field TABLESPACE_NAME dan SEGMENT_TYPE = 'TABLE'
contoh: select owner, segment_name from DBA_SEGMENTS where TABLESPACE_NAME = 'Nama_tablespacenya' and SEGMENT_TYPE = 'TABLE'; Semoga membantu.... On Thu, Mar 19, 2009 at 9:45 AM, aly rmb <[email protected]> wrote: > salam semua, > untuk tau suatu tablespace, isinya table apa saja, kira* querynya bgaimana > ya ? > cari di bang google tp blum ketemu. > terimakasih sebelumnya. > > salam/Aly > > > New Email names for you! > Get the Email name you've always wanted on the new @ymail and > @rocketmail. > Hurry before someone else does! > http://mail.promotions.yahoo.com/newdomains/aa/ > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
