Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How Convert the schema of a table to a Ascci File .SQL
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
![]() |
![]() |