Hi,
Any body can help me regarding import DB incrementally. Oracle 9i supports if i export database incrementally then only i can import that in same fashion. But for incremental export the db user should be sys or system, but my dbuser is different.

And in one database we have the test company and livecompany
Example : tpptc001202(livecompany) tpptc001905(test company). How can i export only the 202 data.

I want to import the 202 data into another backup server daily.

is baan does incremental export and import (Baan application.).

My total oracle DB is 90 GB.

With baan tools it isn´t possible to export/import incremental, but you can do this for separate companys. But I wouldn´t recommend it, because it´s too slow, and after the import you must always run the baan reorg for "repair reference counters".

It´s better to create an export script for oracle with all tables in comp. 202.
First you have to select all tables with a little sql-query like this

select table_name
from dba_tables
where owner = 'BAAN'
and table_name like 'T%202'
;
Redirect the output to a file. Than create the export script with a little manual work.

Keep in mind, that if new tables are created, you have update your script. The better way is to fully automate this procedure, but I didn´t also done it up to now. ;)

Hope this helps

But How do export script? how to use that? Can you give the procedure?