Re: Import Oracle DDL into Oracle Designer 9i?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 18 Jul 2006 20:29:04 +0200
Message-ID: <81aqb29dmaj8ueo4odfdvr9m8ul4ugbd88@4ax.com>

On 18 Jul 2006 08:43:50 -0700, "Broons Bane" <newsgrouper_at_yahoo.com> wrote:

>I'm trying to find a way of importing ddl from oracle database into
>oracle designer to save me a hell of a lot of typing! I've heard it is
>possible. i created a .dmp file using oracle's export utility (with no
>data) and then tried to import it into oracle designer, I got the
>following error messages. Any ideas? I tried to google it but only
>returned one result, which was no help.

Designer comes with a reverse engineering or retrofit utility (they change the name with every release) or database capture utility. Check the help file.
It allows you to connect to the database and read the complete schema (without export)

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Jul 18 2006 - 13:29:04 CDT