Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: scripts "create table" ddl statement
Thanks Howard
This oracle 8174 on sun solaris
Thanks
Maria
"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:<xisga.565$1s1.4140_at_newsfeeds.bigpond.com>...
> Version?????????????????????????
>
> I only ask, because in 9i there's a package to do precisely this. Which I
> would explain in more detail if I thought for one minute it might be
> applicable to you... but since you leave me guessing, it hardly seems
> worthwhile.
>
> Otherwise, and for all versions, do an export, and then an import with
> rows=n. indexes=n, indexfile=blah.txt ignore = y. You'll produce a text file
> called blah.txt which contains the entire DDL statement for any tables
> included in the original export.
>
> Regards
> HJR
>
>
> "Maria" <evoradba_at_yahoo.ca> wrote in message
> news:351fd9d6.0303261648.4da86d2f_at_posting.google.com...
> > Hi all
> >
> > Is there any Oracle scripts that can create "create table" ddl
> > statement from the database?
> >
> > Thanks
> > Maria
Received on Thu Mar 27 2003 - 08:18:26 CST