Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Create a SQL script used to create a new copy of a user's schema.
Miles,
Thank you for such a simple and faithful solution to my delima!
I have partially tested your "strings" solution and it looks like it
looks like it will do the job. (Why didn't Oracle susgest this??)
Thank you again for the time you took to read and respond to my
question,
Bill
Miles Thomas wrote:
> Chris Hamilton <chrish_at_wnmail.att.com> wrote in article
> <01bc7665$cc94a780$4881b687_at_chrish-pc.cis.att.com>...
> > Miles Thomas <thomasm@"at".logica."dot".com> wrote in article
> > <01bc7648$29db6be0$4621ea9e_at_UKP01436.logica.co.uk>...
> >[SNIPPED]
> > Well, actually you can. On a Unix platform, do the following,
assuming
> > your export file is called expdat.dmp...
> >
> > % strings expdat.dmp > expdat.txt
> > % vi expdat.txt
> >
> > Edit the resulting text file and change anything you want, comment
out
> > anything you want, etc. All the create table, index, constraint,
etc.
> > statements are in there. The strings command will grab only text
and get
> > rid of binary headers and such. You can then execute the text file
from
> > SQL*Plus.
> >
> > You'll have to add semi-colons at the end of lines and filter out a
few
> > other things, but it's a good way to accomplish what you want to do.
> >
> > Chris
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > Chris Hamilton -- chrish_at_wnmail.att.com
> > AT&T WorldNet Service -- Lincroft, NJ
> > City of Washington Pipe Band -- USA
> > http://www.serve.com/cowpb/chamilton.html
> >
>
>
>
>
>