Re: Listing all user and system tables
From: Jim Kennedy <kennedy-family_at_home.com>
Date: Mon, 26 Nov 2001 17:53:22 GMT
Message-ID: <mkvM7.80918$XJ4.43830956_at_news1.sttln1.wa.home.com>
Date: Mon, 26 Nov 2001 17:53:22 GMT
Message-ID: <mkvM7.80918$XJ4.43830956_at_news1.sttln1.wa.home.com>
select table_name from dba_tables where tablespace='THENAMEOFTHETABLESPACE';
Jim
"Ashley Jarvis" <aw_jarvis_at_hotmail.com> wrote in message
news:e3982325.0111260904.321601d1_at_posting.google.com...
> Is it possible to list all tables within a specified Tablespace ?
> If so could someone enlighten me...as I can't seem to find this in
> any documentation.
>
> I'm using Oracle 8.1.7
>
> Thanks
> ash
Received on Mon Nov 26 2001 - 18:53:22 CET