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 -> Export database schema and contents

Export database schema and contents

From: Dipl.-Informatiker Khamis Abuelkomboz <khamis_at_knuut.de>
Date: Sun, 08 Oct 2000 20:34:32 +0200
Message-ID: <39E0BE38.81C6A5CF@knuut.de>

How can I export my database in sql statements, so that I can create/load
the same schema and contents on a different database, the result should be
something like

CREATE TABLE Animal (
 ID NUMBER(6) PRIMARY KEY,
 name VARCHAR2(20) UNIQUE,
 legs NUMBER(3),
 insertionDate DATE);

CREATE SEQUENCE AnimalIDs;

INSERT INTO Animal VALUES(AnimalIDS.NEXTVAL, 'cow', 4, SYSDATE);
INSERT INTO Animal VALUES(AnimalIDS.NEXTVAL, 'tiger', 4, SYSDATE);
INSERT INTO Animal VALUES(AnimalIDS.NEXTVAL, 'spider', 8, SYSDATE);
COMMIT; Received on Sun Oct 08 2000 - 13:34:32 CDT

Original text of this message

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