Re: Another newbie tablespace question

Never mind, the newbie answered his own question: dba_tables (thanks to the OReilly Oracle DBA book)

jemptyg_at_rwmc.net (George Jempty) wrote in message news:<2ecd96e6.0109040643.48f0308a_at_posting.google.com>...
> I too am a new Oracle DBA -- actually a new DBA period (was a database
> developer). We are running 8.1.6 (NOT 8i) on HP-UX.
>
> My question is this. I know (in theory) how to use the tablespace
> clause with the CREATE command.
>
> What I would like to know is, given a tablespace_name, how to find its
> associated tables. Is this information stored in a system table? If
> so, what is the name of the table?
>
> Thanks in advance
>
> George Jempty
Received on Tue Sep 04 2001 - 21:10:15 CEST