Import/Export small database with spacing contraints!! Not enough disk space! And can't use vi to modify the exported schema!

Hi,

        I need to move a client database to another machine, but this database is too big for the destination even without exporting data because the sizes of the initial extents of 600 some tables. I am trying to *manually* edit the exported schema, so I can run it as sql script, but editor like vi or view cannot handle the long number of charcters of many objects like trigger! So, I am not sure what to do now!!

Is there a way to change the exported schema without corrupting the file? So the imp utility can still use the *modified* exported schema?

If vi, view cannot handle the task of editing the exported schema? What other editors that experts use when they need to change the exported schema? Or, what other people will do in this situation?

Any ideas or experiences that you want to share with me?

I will appreciate any helps ;-)

thanks in advance.

Please contact me either posting here, or email me to mleung_at_intelus.com or mleung_at_earthlink.net

Michael Leung Received on Sat Feb 20 1999 - 21:14:49 CST