Re: [PEN-TEST] hacking oracle questions

["Edwards, Steve" <sedwards () SEDWARDS COM>]

On Wed, 29 Nov 2000, anindya wrote:

> 1) How do I discover what table names exist in a particular Oracle database
>    i.e. the schema? Once I have the table names, I can use the
>    "describe" command in svrmgrl to get the columns in the
>    table , but apparently there is no easy way to get the
>    table names themselves..

I use the following to keep tabs on the tables my lusers create:

set linesize 80;
set pagesize 58;
ttitle center "show-tables" skip 2
--
--
clear columns;
column table_name       format a10              heading 'Name'
column tablespace_name  format a10              heading 'T/S'
column initial_mb       format 9,990            heading 'Ini MB'
column max_extents      format 990              heading 'Max'
column next_mb          format 9,990            heading 'Nxt MB'
column pct_increase     format 90               heading '%'
select
                  table_name
                , owner
                , tablespace_name
                , initial_extent / (1024 * 1024) initial_mb
                , max_extents
                , next_extent / (1024 * 1024) next_mb
                , pct_increase
        from
                  all_tables
        where
                  'SYS' != owner
        and
                  'SYSTEM' != owner
        order by
                  table_name
/
exit;

Thanks in advance,
------------------------------------------------------------------------
Steve Edwards      sedwards () sedwards com      Voice: +1-760-723-2727 PST
Newline            Pager: +1-888-478-5085           Fax: +1-760-731-3000