RE: Table creation script

From: Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>
Date: Fri, 29 Sep 2000 08:56:07 -0700
Message-Id: <10634.118236@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C02A2D.CBE3C1A0
Content-Type: text/plain

Or do an exp w/o data and do an import to view the script. Edit it to include only the tables and indexes.

Regards,
Satar

> -----Original Message-----
> From: Dennis M. Heisler [SMTP:dheisler_at_binghamton.edu]
> Sent: Friday, September 29, 2000 5:20 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Table creation script
>
> Get the book "Oracle SQL And PL/SQL Annotated Archives" (Oracle Press) by
> Kevin Loney and
> Rachel Carmichael. It has those scripts and more. Excellent reference.
>
>
> Majid Kazemi wrote:
>
> > Hi everyone;
> >
> > I would like to generate a create table and index script for an existing
> > database which can be used to create tables and indices whenever it is
> > required. You help highly appreciate it.
> > Thanks;
> > Majid
> >
> > --------
> > If you're bored, then visit the list's website: http://www.lazydba.com
> (updated daily)
> > to unsubscribe, send a blank email to
> oracledba-unsubscribe_at_quickdoc.co.uk
> > to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Dennis M. Heisler
> INET: dheisler_at_binghamton.edu
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

------_=_NextPart_001_01C02A2D.CBE3C1A0
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>RE: Table creation script</TITLE>
</HEAD>
<BODY>

Or do an exp w/o = data and do an import to view the script. Edit it to include only the = tables and indexes.

Regards, Satar

</P>
<UL>
<P><FONT SIZE=3D1 FACE=3D"Arial">-----Original Message-----</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Arial">From:&nbsp;&nbsp;</FONT></B> <FONT =

SIZE=3D1 FACE=3D"Arial">Dennis M. Heisler = [SMTP:dheisler_at_binghamton.edu]
 Sent:   Friday, September 29, 2000 5:20 PM To:     Multiple recipients of list ORACLE-L Subject:       = Re: Table creation script

Get the book "Oracle SQL And = PL/SQL Annotated Archives" (Oracle Press) by Kevin Loney = and
 Rachel Carmichael.  It has those = scripts and more.  Excellent reference.

Majid Kazemi wrote:

<P><FONT SIZE=3D2 FACE=3D"Arial">&gt; Hi everyone;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; I would like to generate a =

create table and index script for an existing > database which can be used to = create tables and indices whenever it is > required.  You help highly = appreciate it.

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Thanks;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Majid</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; --------</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; If you're bored, then visit the =

list's website: <A HREF=3D"http://www.lazydba.com" = TARGET=3D"_blank">http://www.lazydba.com</A> (updated daily)
 > to unsubscribe, send a blank = email to oracledba-unsubscribe_at_quickdoc.co.uk > to subscribe send a blank email = to oracledba-subscribe_at_quickdoc.co.uk

-- Please see the official ORACLE-L = FAQ: <A = HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A>

<BR><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Author: Dennis M. Heisler</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp; INET: =

dheisler_at_binghamton.edu

Fat City Network = Services    -- (858) 538-5051  FAX: (858) = 538-5051
 San Diego, = California        -- Public Internet = access / Mailing Lists
 <FONT SIZE=3D2 =

FACE=3D"Arial">---------------------------------------------------------=

-----------
 To REMOVE yourself from this mailing = list, send an E-Mail message
 to: ListGuru_at_fatcity.com (note EXACT = spelling of 'ListGuru') and in
 the message BODY, include a line = containing: UNSUB ORACLE-L
 (or the name of mailing list you want = to be removed from).  You may also send the HELP command for other = Received on Fri Sep 29 2000 - 10:56:07 CDT