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.


Connected to: Oracle9i Enterprise Edition
With the Partitioning, OLAP and Oracle Data Mining options


Export file created by EXPORT:V09.02.00 via conventional path

Warning: the objects were exported by xxx, not by you

import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character
set
import server uses WE8ISO8859P1 character set (possible charset
conversion)
export client uses US7ASCII character set (possible charset conversion)
.. importing xxx's objects into CASEOWNER
IMP-00033: Warning: Table "XTSYS_EXPORT_OBJECTS" not found in export
file
IMP-00033: Warning: Table "XTSYS_IMPORT_IRID_MAPPING" not found in
export file
IMP-00033: Warning: Table "XTSYS_IMPORT_IVID_MAPPING" not found in
export file
IMP-00033: Warning: Table "XTSYS_TABS_EXPORTED" not found in export
file
IMP-00033: Warning: Table "XTSYS_RMicrosoftREPOSITORIES" not found in export
file
Import terminated successfully with warnings.

On 18 Jul 2006 08:43:50 -0700, "Broons Bane" <newsgrouper (AT) yahoo (DOT) com>
wrote:


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

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:

"Broons Bane" <newsgrouper (AT) yahoo (DOT) com> wrote

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

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 (DOT) com> wrote

Broons,

please don't top-post (this means: please put your reactions to posts on the
bottom of a post or in-line). If you do top-post, some of the (best) guru's
will not answer... And as you nay have noticed, this discussion is going to
be a bit hard to be read....Ok?

When you log on to Designer, you log on to a so called repository database,
which holds all the Designer projects. This is usually (and preferably) NOT
the database for your developed software (tables, views, plsql etc). When
you use the Design Editor, and generate the 'real' tables from your
definitions, you will log on to the database you want to generate your
tables to. Design Capture (which is in the menu of the Design Editor) works
the same way.
If you do not have a Designer Repository installed, I would advise you to
use JDeveloper for your Design capture, which is much easier to install
(just unzip, ready!)

Robbert