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

Home -> Community -> Usenet -> c.d.o.server -> ORACLE RDBMS SQL Schema and Data Exporter

ORACLE RDBMS SQL Schema and Data Exporter

From: John S. Fletcher <jfletche_at_know.demon.co.uk>
Date: 1997/04/23
Message-ID: <01bc5027$b7e8df90$e219989e@invincible>#1/1

Schema is small program written in Pro*C that provides the unique capability of exporting an Oracle database definition and data to a file of the SQL necessary to create that database. It works in a similar fashion to the familiar Oracle RDBMS exp[ort] tool but in a way that provides readable ASCII text instead of a proprietary binary file. The script created by it is an SQL*Plus 3.0+ script and is designed to be run as is using SQL*Plus to "import" the database. The advantage of this format is that it can be edited using familiar and readily available ASCII editing tools to, for instance, spell check data or systematically change or remove data in a table. Secondarily it provides an easily readable and useable "snapshot" of a database at the time the program is run.

More information and program for Windows NT / Windows 96 @ ... http://www.gamelan.demon.co.uk/schema/ Received on Wed Apr 23 1997 - 00:00:00 CDT

Original text of this message

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