Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help on partition managing
Enkidu Utnapishtim wrote:
>
> 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.
To extract DDL, try using dbms_metadata. No need to muck around with binary .dmp files, and I'm sure with a little bit of PL/SQL coding (or even just using vi on the output), you can do whatever sort of changes you need (search/replace, etc.). And if you don't have access to the original database or it isn't 9i, just import the .dmp file into a test 9i database and do it there.
Regards,
Sean
Received on Mon Jul 22 2002 - 17:28:10 CDT