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 -> how to check table with sql ?

how to check table with sql ?

From: rateng <rateng_at_wz.col.com.cn>
Date: Thu, 21 Oct 1999 09:04:28 +0800
Message-ID: <7ulohf$h0q$1@news.cz.js.cn> 





Hi,anyone


   I want to view how many table is in a scheme of tablespace ?
example:


    I have a aa tablespace ,userAA name user. I can use system privilege.
May I write the SQL command to view the database for
how many table and what's name in this tablespace?




   And other problam, How to copy a table of a user of aaa schema
to other user of bbb schema ?



   Please , thank you very much.



  regard:  rateng_at_wz.col.com.cn



Received on Wed Oct 20 1999 - 20:04:28 CDT












Original text of this message













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