Lisa,
No we did not. It's still there. It's a ridiculous design
but it was there when I got here and it's not going
away anytime soon.
Cherie Machler
Gelco Information Network
"Koivu, Lisa" <[EMAIL PROTECTED]> on 03/29/2001 06:58:20 PM
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>,
Title: RE: OT -- # tables in your db (was: Slow database)
Nope, Cherie wins. Before I left, I realized I had a database that had 19,000+ tables in it. There were a ridiculous number of schemas. Cherie, did you guys ever bust that database up into two?
-Original Message-
From
> "very complex" at 300 tables.
>
> I checked on mine, excluding SYS and SYSTEM, I have 3185 tables. 159
> database links. 1064 views, again excluding SYS and SYSTEM.
>
> This is on Oracle 7.3.4.
>
> I am sure this is not the smallest db out there...
>
> (It's my birthday, so what if I feel a bi
Happy Birthday Patrice!
Here you go:
SQL> select object_type, count(*)
2 from dba_objects
3 where owner != 'SYS'
4 andowner != 'SYSTEM'
5 andowner != 'CTXSYS'
6 andowner != 'DBSNMP'
7 group by object_type;
OBJECT_TYPE COUNT(*)
--- --
DATA
