Example Schema: Oracle EXPORT (oracle)

This example demonstrates the use of the special "oracle" format. The input data is an Oracle dump.

database /tmp/testdb
table  customer
# indicate oracle format
oracle
#       Name            Type            Tag
field   CustID          varchar(10)     1
field   Company         varchar(80)     2
field   Address         varchar(80)     3
field   City            varchar(20)     4
field   State           varchar(10)     5
field   Zip             varchar(10)     6
field   Country         varchar(10)     7
field   Phone           varchar(20)     8

Here is what you might see if you look at the top of an Oracle EXPORT file in a text viewer.

EXPORT:V07.03.03
UPR_XYZ
RTABLES
1024
0
                                           Fri Mar 27 15:59:14 1998
TABLE "CUSTOMER"
CREATE TABLE "CUSTOMER" ("CUSTID" VARCHAR2(10), "COMPANY"
VARCHAR2(30), "ADDRESS" VARCHAR2(80), "CITY" VARCHAR2(20), "STATE"
VARCHAR2(10), "ZIP" VARCHAR2(10), "COUNTRY" VARCHAR2(10), "PHONE"
VARCHAR2(20)) INSERT INTO "TEMP" ("CUSTID", "COMPANY", "ADDRESS",
"CITY", "STATE", "ZIP", "COUNTRY", "PHONE") VALUES (:1, :2, :3, :4,
:5, :6, :7, :8)


Copyright © Thunderstone Software     Last updated: Dec 10 2018
Copyright © 2019 Thunderstone Software LLC. All rights reserved.