Re: Exporting structure

If you use the rows = N option the resulting .dmp will be editable and you should be able to make the changes you require. (I have seen a few spurious characters inserted at the beginning of some lines so you may have to use sed or tl to remove them if you want to use the file as it stands)

I am pretty sure that the dmp file contains all the information you require, although if you are just changing the sizes of a few tables and indexes it may be worth just extracting the relevant commands to create a script which you can run against the instance. Once you have done this you can then use export and import in the normal manner.

Hope this helps,

Ian Received on Fri Oct 31 1997 - 00:00:00 CST