Re: Need help importing / exporting a schema

"Blake McBride" <blake_at_mcbride.name> wrote in news:1365u8vh62bdp1c_at_news.supernews.com:

>
> The dump would contain all the create table commands first, then the
> primary keys, indexes, foreign keys, etc. Done in this order there is
> no problem with dependencies. Also, if a database only contains
> string and numeric columns then exporting and importing in text based
> SQL commands works fine. The main reason I can see why Oracle won't
> provide text SQL schemas is to make it maximally difficult to change
> databases.
>
> Without a schema dump I can't keep an Oracle schema in sync with a
> postgres schema. I have my own program to do this (works with MSSQL &
> Postgres) but depends on a textual SQL schema file. This presents a
> significant problem for me.
>
> Blake McBride
>

Nothing is impossible for the person who does not have to do it.

DBMS_METADATA.GET_DDL extracts/generates SQL for any/all objects in the database.

Now all you have to do is call it with the correct arguments in the correct order to build your desired collection of database objects.

HTH & YMMV! Received on Sun Jun 03 2007 - 12:30:26 CDT