RE: how many table -How to check

RE: how many table -How to check

 

  

Wrong.

This is the number of tables a given user owns.

A previous post, using DBA_TABLES was right were a user given apprpriate
privs to view it. Or.... ALL_TABLES .....



Regards,

Simon Palmer




"Simharaju Vidyasagar "
<oracledba-ezmlmshield-x34626378.[Email address protected]
29/11/2007 10:20

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
RE: how many table -How to check







SELECT COUNT(*) FROM USER_TABLES

Thanks
Sim


-----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


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


ATTENTION: The information in this email is confidential and may be
legally privileged.
It is intended solely for the intended recipient.
Access to this email by any one other than the intended recipient is
unauthorised.
In the event you have received this email by mistake you are requested
to immediately
inform ING Vysya Life Insurance of the same by forwarding this mail to
system.[Email address protected]
and thereafter you are required to delete it from your system
permanently.
If you are not the intended recipient, any disclosure, copying,
distribution or
any action taken or omitted to be taken in connection with it, is
prohibited and unlawful.
When addressed to our clients, any opinion or advice contained in this
email is subject to the terms and
conditions expressed in any applicable terms of business or client
engagement letter issued by ING Vysya Life Insurance.




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------------------------------------------------
This message and any attachment are confidential and may be privileged or otherwise protected from disclosure.
If you are not the intended recipient, please telephone or email the sender and delete this message and any attachment from your system.
If you are not the intended recipient you must not copy this message or attachment or disclose the contents to any other person.
Please consider the environmental impact before printing this document and its attachment(s). Print black and white and double-sided where possible.
------------------------------------------------------------------------------

Oracle LazyDBA home page