Count number of records in all the tables with a querry URGENT PLEASE...

Posted on 16th Feb 2014 07:03 pm by admin

I downloaded ORACLE 9I DATA DUMP into my comp. There are number of tables. I need to find out the tables with records more than say 100 or so at on go. Can it be possible... If so kindly let me know.

Secondly, from the database which I downloaded I found out that Audit_ Trial was not enabled by firing
"select name,value from v$parameter
where name like 'audit%' and it turned out to be false.
Can we take it for granted that in the database in the server also the audit_trial has been disabled...

Your Answer:

Login to answer

Other forums

Stats of viewers
Hello. I have a website in php and people can login. I want to make an admin control panel where u c

listcube issue
Hi
I have a virtual cube ZREMOTE. I use Tcode "listcube" to retrieve contents. I use of the

Strange cookie problem. setcookie dependant on where user was directed from?
Hello,

I have a website that sets a cookie when a user visits the website. The cookie holds a

PHP/Database issue
My friend is helping me make a database where you go to a certain webpage of my site and the page wi

cPanel API
Hi Guys,

Need a little guidance. I'm trying to get my script to communicate with cPanel (or W

Form always sends to error page...
Hello,
Any help will be greatly appreciated. I am having trouble getting multiple fields to be re

Change of partner analyse in sales orders
Hello,

I changed the partner analyse for sales orders and added a new mandatory partnerro

PDO returns erroneous columns from within pdt
Hi All,

This is a truly weird behavior:
When using a simple pdo fetch, erroneous columns a

couldn't connect to your database
Hello I am new to php mysql

Actually i have read A tutorial on nettuts
"http://net.tu

empty() error
Why does

Code: empty($USER_ID = $_SESSION["USER_ID"])
create this error...