How to find how many tables in each data base

babuda

 Profile Answers by babuda Questions by babuda

• Jul 14th, 2008

what abt this ?  1* select sum(count(*)) from all_tables group by ownerSQL> /SUM(COUNT(*))-------------           39SQL>

babuda

 Profile Answers by babuda Questions by babuda

• Jul 14th, 2008

Someone need to confirm whether this is correct! Each owner is treated as schema(?),bang me if I am wrong  1* select count(1),owner from all_tables group by ownerSQL> /  COUNT(1) OWNER---...

Answer Question  Select Best Answer

How to verify null occupy memory?

nrajakumar

 Profile Answers by nrajakumar Questions by nrajakumar

• Aug 15th, 2008

Create table tblNull(col int)sp_spaceused tblNullinsert into  tblNull(col) values(NULL)sp_spaceused tblNull

babuda

 Profile Answers by babuda Questions by babuda

• Jul 14th, 2008

When we say memory occupy means it is allocated atleast a byte or char or storage space. when we run thisselect null from dual nothing is returned, in my opinion null does not occupy any storage spaceany thoughts? we can think it over

Answer Question  Select Best Answer

babuda

 Profile Answers by babuda Questions by babuda

• Jul 14th, 2008

I am not sure abt this but I was successful when I did this 2 years agoOpen tnsnames.ora filetake a back upchange the service from dedicated to permanent. I am not sure which one is itORCL01 =  (...

vijay

• Sep 12th, 2007

First you create database and user in Oracle 9iMapping for all database using tnsnames.ora file and save it. Create DSN and connect

Answer Question  Select Best Answer