Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
14%
200 - 500 GB
32%
500 - 800 GB
4%
800 - 1200 GB
4%
1200 - 1500 GB
11%
1500 - 2000 GB
14%
> 2000 GB
21%
Total votes: 28

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 13th May 2002, 10:56
maximus's Avatar
maximus maximus is offline
Member
 
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

Hi,

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.

max
Reply With Quote
Sponsored Links
  #2  
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
Reply


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 9.2.0.4 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 11:18.


©2001-2018 - Baanboard.com - Baanforums.com