USER_TABLES will give you count of all the tables present in the schema in
which you have logged in whereas the DBA_ALL_TABLES and DBA_TABLES will give
you count of all the tables present in the given database.

Tushar Dave
Intrack Inc

-----Original Message-----
From: Jordan Radkev
[mailto:oracledba-ezmlmshield-x52340640.[Email address protected]
Sent: Thursday, November 29, 2007 3:45 PM
To: LazyDBA Discussion
Subject: RE: how many table -How to check

Isn't

SQL> select count(*) from user_tables;

better?

J

-----Original Message-----
From: chandan [mailto:oracledba-ezmlmshield-x41165630.[Email address
protected]
Sent: Thu 11/29/2007 11:15 AM
To: LazyDBA Discussion
Subject: RE: how many table -How to check


SQL>select count(*) from dba_tables;



Regards
Chandan

-----Original Message-----
From: abdul
[mailto:oracledba-ezmlmshield-x76662983.[Email address protected]
Sent: Thursday, November 29, 2007 2:42 PM
To: LazyDBA Discussion
Subject: how many table -How to check

Dear DBA's,


Please let me know how to check how many tables are the in database ,

I need a query for the same..

Cheers,
Abdul Razaak.M.P.

-----Original Message-----
From: Irfan Ahmad
[mailto:oracledba-ezmlmshield-x16592002.[Email address protected]
Sent: 29 November 2007 2:29 PM
To: LazyDBA Discussion
Subject: TNSListner Service has deleted or disappear

Dear friends
I am using oracle 9i on windows 2000. At the moment my windows services
is not showing TNSListner service. I think its deleted or disapear.
Please suggest me how i can add or appear this service again in my
services window.

Waiting 4 quick response.

Thanks & regards

Irfan Ahmad


Oracle LazyDBA home page