|
|
|
|
|
|
| Author |
Message |
Robbert van der Hoorn
*nix forums beginner
Joined: 29 Jun 2006
Posts: 16
|
 Posted: Thu Jul 20, 2006 9:06 am Post subject:
Re: Import Oracle DDL into Oracle Designer 9i?
|
|
|
"Broons Bane" <newsgrouper@yahoo.com> wrote in message
news:1153303444.126917.216380@m73g2000cwd.googlegroups.com...
| Quote: | 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@yahoo.com> wrote in message
news:1153298277.923411.282670@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@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).
|
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 |
|
| Back to top |
|
 |
Broons Bane
*nix forums beginner
Joined: 04 Feb 2006
Posts: 6
|
| Posted: Wed Jul 19, 2006 10:04 am Post subject:
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:
| Quote: | "Broons Bane" <newsgrouper@yahoo.com> wrote in message
news:1153298277.923411.282670@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@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). |
|
|
| Back to top |
|
|
Robbert van der Hoorn
*nix forums beginner
Joined: 29 Jun 2006
Posts: 16
|
| Posted: Wed Jul 19, 2006 9:39 am Post subject:
Re: Import Oracle DDL into Oracle Designer 9i?
|
|
|
"Broons Bane" <newsgrouper@yahoo.com> wrote in message
news:1153298277.923411.282670@i42g2000cwa.googlegroups.com...
| Quote: | 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@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). |
|
| Back to top |
|
|
Broons Bane
*nix forums beginner
Joined: 04 Feb 2006
Posts: 6
|
| Posted: Wed Jul 19, 2006 8:37 am Post subject:
Re: Import Oracle DDL into Oracle Designer 9i?
|
|
|
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:
| Quote: | On 18 Jul 2006 08:43:50 -0700, "Broons Bane" <newsgrouper@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 |
|
|
| Back to top |
|
|
Sybrand Bakker
*nix forums Guru
Joined: 03 Apr 2005
Posts: 1766
|
| Posted: Tue Jul 18, 2006 6:29 pm Post subject:
Re: Import Oracle DDL into Oracle Designer 9i?
|
|
|
On 18 Jul 2006 08:43:50 -0700, "Broons Bane" <newsgrouper@yahoo.com>
wrote:
| Quote: | 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 |
|
| Back to top |
|
|
Broons Bane
*nix forums beginner
Joined: 04 Feb 2006
Posts: 6
|
| Posted: Tue Jul 18, 2006 3:43 pm Post subject:
Import Oracle DDL into Oracle Designer 9i?
|
|
|
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_RM$REPOSITORIES" not found in export
file
Import terminated successfully with warnings. |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Fri Nov 21, 2008 6:39 pm | All times are GMT
|
|
Mobile Phone deals | Loans | Remortgaging | Meeting Rooms | Debt Consolidation
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
Oracle
