Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Import Oracle DDL into Oracle Designer 9i?

Re: Import Oracle DDL into Oracle Designer 9i?

From: Broons Bane <newsgrouper_at_yahoo.com>
Date: 19 Jul 2006 03:04:04 -0700
Message-ID: <1153303444.126917.216380@m73g2000cwd.googlegroups.com>


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
> >

>

> 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 - 05:04:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US