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],
"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 bit competitive
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(*)
--- --
"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 bit
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: Alex
