Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Import Oracle DDL into Oracle Designer 9i?
Sorry, you are right, I am a bit confused.
When I log into Oracle 9i designer, is this essentially the physical schema and database that I am connecting to? If so, how do I view the physical database tables and selectively (or otherwise) import them into my designer repository?
Regards
Robbert van der Hoorn wrote:
> "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
> >
>
>
>