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

  Try SQL Navigator for the DDL extracts. It's a tool similar to TOAD, and worth the money.

"Howard J. Rogers" wrote:
>
> <fenton_travers_at_my-deja.com> wrote in message
> news:8o4vkc$hos$1_at_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.
> >
>
> Always trust your DBA, Fenton!!
>
> Seriously, though... he's sort of right. There's no way to track all DDL
> issued against a database that I can think of. On the other hand, if you
> want a script that will re-create a database, you could do worse than try
> doing an import with the 'indexfile' parameter set (to be a path/filename).
> If you do this when attempting a full database import, the 'indexfile' thus
> generated has actually got all the commands needed to reconstruct the entire
> database -although all the 'create table' statements etc will have 'REM'
> comments before them. Still -this is a text file, so you should be able to
> edit them out without too much bother.
>
> How you then re-populate all those tables? Well, you could try *another*
> run of the import utility, this time setting 'ignore=y' -it should ignore
> all the errors that would arise as a result of object existence, and get on
> with the job of doing a whole bunch of insert statements.
>
> Regards
> HJR
>
> > Fenton
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
 

-- 
---------------------------------------------------------------------
Chad Thompson, 
Programmer Analyst: VB, VC++, PLSQL, Oracle HRMS, Security Apps
                            Home: thomp901_at_micron.net

Thou shalt not tick off the dragon.... for thou art crunchy and 
taste good with ketchup.
---------------------------------------------------------------------
--