Export/migration advice

We have a server using 7.3.3... and want to set up a test/development environment on another machine using 8.0.... with an eye to eventually upgrading the production server to Oracle 8 also. My problem is that we are constantly adding new tables and while we were using export to make backups and maintain the development engine with a few tables at a time as needed, we now need to copy the entire database, schemas, data and all, to development to be able to verify that our apps and load programs are working correctly against the Oracle 8 engine and with the ProC 8 compiler. OK, no big deal so far. True, so here's the rub.

We can no longer export the entire database as it has outgrown a single 2GB file and our OS does not support larger files. OK so break up the export... well we also have too many tables and the export is complaining. Breaking the export/import down further just seems too hard to me. I'm used to, sorry folk for mentioning the big I, Informix's dbexport/dbimport which make this kind of thing easy.

I want to know if there is an easier way that I am just missing because I cannot get out of my Informix head and am not familiar enough with the manual layout to find it myself. Help for an old DBA who is an Oracle newbie?

Art S. Kagel Received on Wed May 12 1999 - 10:36:13 CDT