Re: Help on partition managing

Howard,

Thanks for bringing this point out. Sometimes, in the interest of brevity of replies, I tend to leave out important information. In this case, it's not just a trivial issue that I forgot to mention. I should have stated the caveat that you did. If you use 'vi' to edit a traditional dump file (rows=y), you will see very little other than a bunch of "\nnn" numbers. You'd spoil more than a hot dinner or two if you routinely tried to edit very many of those.

However, the dump file looks very different in 'vi' when you use 'rows=n'. I should have been more explicit in my answer. However, even stating this, there's a lot of clean-up that has to be done to extract just the DDL.

Again, thanks for setting me straight ... and helping anyone who rushed out to edit a 'rows=y' dump file. <g>

Roger Crowley - DBA - LearningFramework

Howard J. Rogers wrote:
>
> It's not a question of raising any corporate eyebrows, it's just that the
> dump file is a binary file, and editing it with a text editor and then
> saving it means it ceases to be a viable dump file. Not saying you can't
> extract the text-y bits out of it like that, which sounds what our original
> poster was doing, but I've trashed more dump files than I've had hot dinners
> doing stuff like that (all in the cause of demonstrating the point for
> students, of course!) and then using the 'save' option.
>
> Regards
> HJR
Received on Mon Jul 22 2002 - 16:51:27 CDT