Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How can i know certain table created in which tablespace
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