Re: Export/migration advice

Jerry Gitomer wrote:
>
> Hi Art,
>
> As an Informix guru you will be amused to know that one way of
> accomplishing what you want is to write shell scripts that emulate the
> Informix UNLOAD.
>
> The easiest way to do this is find a copy of Jared Still's sqlunldr
> script since it will dump the data, create the SQL Loader control files and
> even create the DDL statements. You will have to come up with a means of
> recreating the stored procedures, grants, etc. but it sounds like you
> already have that part of the job under control.
>
> If you can't find copy of the script in question e-mail me and I will
> send it to you.

GREAT Jerry, thanks. I would not even know where to look. Is there a site like the IIUG Software Repository around for Oracle?  

> Jerry Gitomer
> --------------------------------------------------------------
>
> 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 - 14:11:09 CDT