Re: export/import

bards wrote:

[...]
> and want to get everything from 8.1.7 into 10g. Use level schema exports
> imply me having to do all the other system stuff up front unless I'm
> mistaken, that is create users, create roles, grant privs etc. Am I
> wrong ? It seems like a lot of work with the potential for human error
> (my typos etc).

Some extra work is worth the benefit of keeping your metadata scripted and under some kind of revision control system outside of the source database, IMHO. Are all the users, roles, grants, and so on exactly as your current spec requires in the 8.1.7 database? Or perhaps has someone, throughout the years since 8.1.7 was released, conducted a little test or implemented a little workaround that somehow didn't get formalized?

I suppose if you had a vendor-supplied database set-up instead of a developed-in-house system, my comment wouldn't apply ... but then, you would just be following your vendor's supported upgrade process, right? ;-)

Jumping two major releases is also a good time to force yourself to examine whether you are fully taking advantage of new features and improvements, specifically related to users, roles, grants, and so on. (Didn't one of the default roles change in version 10gR2? Perhaps you want to utilize the database default temporary tablespace instead of individual user default temp?)

Typos and human error are inevitable no matter what -- that's why test environments were created.

-Mark Bole Received on Thu Aug 25 2005 - 20:21:42 CDT