Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS OF A SCHEMA.

RE: SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS OF A SCHEMA.

From: Jack C. Applewhite <japplewhite_at_inetprofit.com>
Date: Mon, 02 Jul 2001 11:51:17 -0700
Message-ID: <F001.0033F445.20010702104524@fatcity.com>

<SPAN

class=437034017-02072001>Bunyamin,
<SPAN

class=437034017-02072001> 
<SPAN

class=437034017-02072001>A very easy thing to do is export the schema (Rows=No), then copy the Create Table statements from the *.dmp file.  That way you don't have to worry about your script getting out of date with features of newer versions of the RDBMS.
<SPAN

class=437034017-02072001> 
<SPAN

class=437034017-02072001>Jack

--------------------------------Jack C. 
ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin,
Texaswww.iNetProfit.comjapplewhite_at_inetprofit.com(512)327-9068

  <FONT face=Tahoma
  size=2>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_fatcity.com]On Behalf Of Bunyamin K.   KaradenizSent: Monday, July 02, 2001 12:46 PMTo:   Multiple recipients of list ORACLE-LSubject: SCRIPT NEEDED TO MAKE   THE CREATE TABLE SCRIPTS OF A SCHEMA.
  Hi Gurus,
  I do not have time to write it.
  IF you have a script creating
  <FONT face=Arial
  size=2>              
  the create table scripts of a schema, I will be so happy .   Thanks
  Bunyamin Received on Mon Jul 02 2001 - 13:51:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US