Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How can i know certain table created in which tablespace

Re: How can i know certain table created in which tablespace

From: Jordan <mj_at_nba.com>
Date: Fri, 3 Aug 2001 20:03:51 +0800
Message-ID: <9ke42k$qlb1@imsp212.netvigator.com>

Thanks a lot, Tom. Did you have any materials about OCP exam? "Tom Best" <tombest_at_firstusa.com> ?????
news:99ab87b0.0108021321.5eaaaf7f_at_posting.google.com...
> "Jordan" <mj_at_nba.com> wrote in message
 news:<9kbnsk$i6d2_at_imsp212.netvigator.com>...
> > How can i know certain table created in which tablespace
> > THanks
>
> Jordon:
>
> Query ALL_TABLES, or DBA_TABLES, or USER_TABLES.
>
> Hope this helps.
>
> Tom Best
Received on Fri Aug 03 2001 - 07:03:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US