Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Export database schema and contents
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