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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How Convert the schema of a table to a Ascci File .SQL

Re: How Convert the schema of a table to a Ascci File .SQL

From: Boroskie <boroskie_at_ix.netcom.com>
Date: 1997/11/18
Message-ID: <64r2kg$cu0@dfw-ixnews7.ix.netcom.com>#1/1

Export the user will all options with rows / table data no. The resulting dmp file( ASCII editable) will have all the SQL to create tables, indexes....

Best of luck, Boroskie(boroskie_at_ix.netcom.com)

In article <01bcf47f$93123840$d6c57ac3_at_xsm>, m5219_at_hotmail.com says...
>
>How i can convert the schema of a table or user with the format:
>
>
>create table customers .................
>
>
>
>create index ..................
>
>
>In Informix : dbschema -d <database> -t <tabla>
>this command generate a .SQL that content the sql instruction to create
 the
>table.
>Thanks and regard from spain.
>
>
>m5219_at_hotmail.com
Received on Tue Nov 18 1997 - 00:00:00 CST

Original text of this message

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