Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Export/migration advice
With your OS, can you do a
large file enabled file system?
--
Derek Runstadler
Art S. Kagel wrote in message <37399FED.1C1F_at_bloomberg.net>...
>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 - 12:28:34 CDT
![]() |
![]() |