Re: Import Oracle DDL into Oracle Designer 9i?

"Broons Bane" <newsgrouper_at_yahoo.com> wrote in message news:1153298277.923411.282670_at_i42g2000cwa.googlegroups.com...
> Hi there, thanks for the reply.
>
> You can retrofit from the repository to entities, but I'm pretty sure
> there is on equivalent to what you are describing apart from the
> ill-documented import utility.
>
> Sybrand Bakker wrote:
> > 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
>

You are confusing two things here:
1)creating table, view etc definitions from a database, which can be done with the Designer Database Generator (it's under the generate options) and 2) retrofitting table definitions to entities.

For option 1), as Sybrand described, you connect to a database, select a schema and create the table, view, package, sequence etc. definitions in Designer.

DMP files are used to import/export complete repositories or applications systems within Designer (hence from Designer to Designer). Received on Wed Jul 19 2006 - 04:39:17 CDT