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
Oracle LazyDBA home page