After a system crash we must export Baan Companies with oracle tools to reimported into an other maschine.

Have anybody some ideas or scripts ????

Thanks all

Thomas

Hi Thomas,

You have some options but it all depends on what the 'scope' of your recovery is: ie. full database, company 000, any other companies:

If possible I would recommend to do a full logical database export and import. That scenario will be the least troublesome from a database point of view.

If you really have to do it on a company basis, than you will have to do an export based on either a list of tables (for each company) -or- if you are using Oracle8i and have tables for each company in separate tablespaces, you may be able to use a tablespace export/import. But that last one is still an unexplored option for myself :)