Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


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

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 13th May 2002, 09: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, 15: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 07: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 13:19
Oracle 9.2.0.4 Database create patrickmonks Operating Systems & Databases 9 26th November 2003 14:41
BaaN Error 510 & Oracle Error 01034 gentercz Operating Systems & Databases 5 6th December 2002 10:16
BSP-US (LLC) added as a Baan Education Alliance svandenh General Discussion & Chat 1 20th August 2001 19:44


All times are GMT +2. The time now is 15:14.


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