Go Back > Forum > Baan Quick Support: Functional & Technical > Operating Systems & Databases

User login

Frontpage Sponsor


Google search

For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 49

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 27th August 2004, 11:42
richard richard is offline
Senior Member
Join Date: Oct 2001
Location: France
Posts: 178
richard is on a distinguished road
Baan: triton 3.2/Baan IV/LN - DB: Oracle 31 - OS: HP UX 11.23
Number of tables in one database


We are managing 15 companies in one oracle 8 database on one single server, i.e. about 40,000 tables.
Our base has about 130 Go in 10 tablespaces.
Our performances and response time are very good.

I have to create a new archieve company and 2500 tables more.

Do you think this number of tables could be a problem ?
Have you some experience with even more companies/tables on one database/server ?


Reply With Quote
Old 27th August 2004, 12:04
Han Brinkman's Avatar
Han Brinkman Han Brinkman is offline
Join Date: Aug 2001
Location: The Netherlands
Posts: 1,155
Han Brinkman has a spectacular aura aboutHan Brinkman has a spectacular aura about
Baan: All - DB: Oracle/ms-sql/db2 - OS: *nix/windows
No Problem

Connected to:
Oracle8i Release - Production
JServer Release - Production

SQL> select count(*) from dba_tables where owner = 'BAANDB';



works fine for many years.

Han Brinkman
Reply With Quote
Sponsored Links
Old 27th August 2004, 12:25
Markus Schmitz's Avatar
Markus Schmitz Markus Schmitz is offline
Join Date: Feb 2002
Location: Cyprus
Posts: 668
Markus Schmitz is on a distinguished road
Baan: Ivc4 - DB: Oracle8i/9i/10g - OS: HP-Ux11i
Hi Richard,

the number of tables is no problem, but you might consider to create a new Oracle instance for archive companies anyway. This will give you some benefits in regards to backup and recovery, if your archive companies become big enough.


Reply With Quote
Old 27th August 2004, 15:15
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
Join Date: Sep 2002
Location: Netherlands
Posts: 585
Dikkie Dik is on a distinguished road
Baan: Triton 3.0 and higher - DB: All - OS: All
The number of tables can become a problem for your system tables when not using LMT. Several system tables get fragmented and can only be reorganized by re-creating the database. Therefore I advise to use LMT or edit the sql.bsq file before creating the database.

Kind regards,

PS. Editing the sql.bsq file should only be done by experienced people and can lead to unsupported environments. Therefore I don't give the things that should be changed.
BTW: this post has been made on my personal view. My employer might not share my point of view.
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating tables in some other database from Baan through a Session? baanprog Tools Development 7 6th July 2004 07:24
Count Number of Records by Tables and Companies NPRao Enhancements 5 12th June 2004 06:15
Database Server Termination on Audited Tables dvlahovic Tools Administration & Installation 2 23rd July 2003 12:52

All times are GMT +2. The time now is 09:41.

©2001-2018 - -