We have Baan V (c?) using the Oracle 10g. However, I just learned that there is only one prod database to support one production and one test Baan environments. Can I export the DB from AIX to a MS box without Baan existing on that MS box and use the database? I need to develop some new report using the Crystal Report XI interfacing with the DB.
(It was bad a setting originally, but I just got on board 2 weeks for the project)

Chi

Simple answer: Yes

Thanks for your short answer. For further detailed questions, can I just dump the baan schema or have to be the total database? Anything I need to be caution with?

Chi

you just need to export the baan schema.

Baan is not referencing any other tables and the baan tablesitself do not use any contraints between each other. So you could also just dump the tables you are actually interested in!

If the table in Baan is called tdsls040 in company 100, then the table name in oracle is ttdsls040100 (note the extra t at the beginning).

Regards

Thanks, Markus. It was a much helpful information, since I am totally new to Baan and my previous experience with Oracle only goes to 9i.

Chi
Peace Corps Volunteer, US

I export specific baan tables to my laptop for software development. I have a batch file (Windows) that formats the Oracle Export command and makes it easy.

exp log=exp_baan.log userid={username}@{database} tables=(BAANDB.TTCCOM001300,BAANDB.TTCCOM010300,BAANDB.TTCCOM013300,BAANDB.TTCCOM020300,BAANDB.TTCMCS042300,BAANDB.TTDPSC001300,BAANDB.TTDPSC002300,BAANDB.TTDPSC003300,BAANDB.TTDPUR040300,BAANDB.TTDPUR041300,BAANDB.TTDPUR045300,BAANDB.TTDSLS040300,BAANDB.TTDSLS041300,BAANDB.TTDSLS042300,BAANDB.TTDSLS045300,BAANDB.TTDSSC001300,BAANDB.TTDSSC002300,BAANDB.TTDSSC003300,BAANDB.TTDSSC017300,BAANDB.TTDSSC018300,BAANDB.TTDSSC019300,BAANDB.TTDSSC029300,BAANDB.TTDSSC030300,BAANDB.TTFGLD008300,BAANDB.TTIBOM010300,BAANDB.TTICRP002300,BAANDB.TTICRP003300,BAANDB.TTICST001300,BAANDB.TTIHRA100300,BAANDB.TTIITM001300,BAANDB.TTIMPS520300,BAANDB.TTIMRP020300,BAANDB.TTIMRP942300,BAANDB.TTIMRP943300,BAANDB.TTIPCS020300,BAANDB.TTIPCS021300,BAANDB.TTIROU001300,BAANDB.TTIROU002300,BAANDB.TTIROU003300,BAANDB.TTIROU102300,BAANDB.TTISFC001300,BAANDB.TTISFC010300,BAANDB.TTISFC011300,BAANDB.TTTAAD100000,BAANDB.TTTADV401000,BAANDB.TTTADV402000,BAANDB.TTTTXT010300)

Just a little buzzle for the database part. Since the DB of Baan system was defined and created by Baan, it has a ini<baan>.ora file or pfile to initialize the DB. In order to run the copied one on my MS box, I need that file to create DB on the MS box, right?

C

When you do the import of the tables in the MS Box, the name of the database is not all that important. The settings in the init file should be looked at to verify that they are close to what you use on the production machine. In my case, I'm importing the tables into Personal Oracle 9i from Oracle 9i Enterprise.

However, if the Baan tables you are trying to move exist in tablespaces BAANDB and BAANDBIDX, then those tablespaces must exist in the MS box for the import to work. In addition, you will need to manually create the proper owners user account. If the files are owned by BAANDB then there must be an account BAANDB on the MS box and the default tablespaces setup just as they are on the production machine.

Roy

I am going to use expdp to export the Baandb schema only (not the total DB) and use it to restore on the MS box. Thanks.

C