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

Hi Michael,

Did you run either
imp show=y log=<a filename>
or
imp indexfile=<a filename>
The output of this usually can be handled with vi. Alternatively you can try the ugly_ddl.ksh script by Steve Hauser (and I sorry I don't seem to have the URL somewhere)

Hth,

Sybrand Bakker, Oracle DBA

"m.L." wrote:

> 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 - 23:38:25 CST