I have got tfgld106 table which is very big in size. The no of extents for this table are very high. I want to reduce the no of extents. For this I took the backup of the table using bdbpre, deleted the table, changed the parameters in ora_storage file, re-created the table from baan, imported data using bdbpost.
Now I want to use the deleted space in the original data files.
Oracle suggestes to use Export / Import Utility. But I have read that if the Export / Import Utility makes changes into the database structure BaaN will not be able to identify tables.
Can anyone tell me how do go about using Oracle Export /Import so that it will not chnage the Database Strucutre and will reorganise the space?

Hai,

While exporting the rows using Oracle export, you have to take care of exporting the rows only (omit constraints, grants etc.,). Later while importing the rows, it will not affect the database structure of BaaN.

define a parameter file and export the data

Sample parameter file :

file = <specify the export file name>
compress = y
rows =y
index =y
constraints =n
grants=n
consistent=n
tables = <schema.tablename>
log =y

after this export the data using the oracle export command

export username/password @connectstring parafile= <parameter file>

Be careful with exporting without grants. This will only work if you do not drop the target table. If you do drop the table, 'r_baan' will loose its privileges on the table and they will not be re-established with the import. My advice is to use grants=y unless you have non-Baan-standard privileges on your tables.