Re: how to check table with sql ?

From: <tedchyn_at_yahoo.com>
Date: Thu, 21 Oct 1999 13:05:47 GMT
Message-ID: <7un332$v78$1@nnrp1.deja.com>

In article <7ulohf$h0q$1_at_news.cz.js.cn>, "rateng" <rateng_at_wz.col.com.cn> wrote:
> 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
>
>

try dba_tables or dba_segments where owner= tablespace= ted

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 21 1999 - 08:05:47 CDT