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: Tom Best <tombest_at_firstusa.com>
Date: 2 Aug 2001 14:21:34 -0700
Message-ID: <99ab87b0.0108021321.5eaaaf7f@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 Thu Aug 02 2001 - 16:21:34 CDT












Original text of this message













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