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 -> Is it possible to dump oracle database to DDL/SQL syntax

Is it possible to dump oracle database to DDL/SQL syntax

From: <fenton_travers_at_my-deja.com>
Date: Fri, 25 Aug 2000 05:19:22 GMT
Message-ID: <8o4vkc$hos$1@nnrp1.deja.com>

I have an oracle database and I want to dump it to a ddl file. Ie a file that I could later use like:

$ sqlplus < myData.ddl

so it would have the table drop syntax, table create syntax and the insert into syntax.

I can do this simply with MySQL but my Oracle DBA says I can't do this in oracle and I don't believe him.

Fenton

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Aug 25 2000 - 00:19:22 CDT

Original text of this message

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