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

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 46

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 13th May 2002, 10:56
maximus's Avatar
maximus maximus is offline
Join Date: Apr 2002
Location: Bear, DE, USA
Posts: 77
maximus is on a distinguished road
Baan: Most - DB: Most - OS: Most
Relation of Oracle Database to baan data


I would like to know as to how can one get the oracle level details about the baan database. like oracle level tablenames, the space used by each table etc. I do not haev oracle enterprise manager so I will have to do it through sql. does any one have any document about it.

Any help is appreciated.

Reply With Quote
Old 13th May 2002, 16:38
gguymer's Avatar
gguymer gguymer is offline
Unconfirmed User
Join Date: Aug 2001
Location: Lufkin, Texas
Posts: 194
gguymer is on a distinguished road
Baan: Baan IVc4 SP12 - DB: Oracle 8i, 9i - OS: AIX 4.3, 5.3
There are a number of system tables and views provided by Oracle which is really all that the Enterprise Manager uses. You can use USER_TABLESPACES or DBA_TABLESPACES for tablespace info, USER_TABLES or DBA_TABLES for table info, and USER_INDEXES or DBA_INDEXES for index info to name a few. Some of the data in these tables is populated by executing the ANALYZE command on the tables. These are a few of the many available. They are well covered in the Oracle documentation and on Oracle's MetaLink. Baan also details how it is implemented within Oracle in it's Oracle driver documentation.

Gilbert Guymer
Database Administrator
Lufkin Industries, Inc.
Reply With Quote
Sponsored Links

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
Question on baan database (TB) pal_jyotirmoy1 Tools Administration & Installation 1 1st September 2004 08:55
Data Migration from Baan IV c4 SP4/WinNt4.0 to Baan IV c4 SP9/Windows2000 Server Gigaman Operating Systems & Databases 8 26th July 2004 14:19
Oracle Database create patrickmonks Operating Systems & Databases 9 26th November 2003 15:41
BaaN Error 510 & Oracle Error 01034 gentercz Operating Systems & Databases 5 6th December 2002 11:16
BSP-US (LLC) added as a Baan Education Alliance svandenh General Discussion & Chat 1 20th August 2001 20:44

All times are GMT +2. The time now is 07:49.

©2001-2018 - -