| Reverse Engineering [message #90652] |
Tue, 29 June 2004 11:54  |
Viswa Peesapati
Messages: 3
Registered: June 2004
|
Junior Member |
|
|
Is there any way, I can reverse engineer the database objects into Designer9i? I mean not the Designer repository objects. I want to get the objects from one schema into Repository. I am thinking this should be possible, but not sure how to do this.
Can any one throw some light on this.
Thank you,
viswapsp@hotmail.com
|
|
|
|
| Re: Reverse Engineering [message #90653 is a reply to message #90652] |
Tue, 29 June 2004 12:15  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
Sure:
Oracle Designer > Design Editor > New Server Model
Genetare > Capture Design of... > Server Model
Setting up the containers isn't very intuitive. Search for a note on metalink or the otn forums.
|
|
|
|
| Re: Reverse Engineering [message #90655 is a reply to message #90653] |
Wed, 30 June 2004 06:07 |
Viswa Peesapati
Messages: 3
Registered: June 2004
|
Junior Member |
|
|
Hi Andrew,
Here is what I did. Created a new work area. created a database and user under that. In the design editor, Generate>Capture Design of > Server Model. Entered the source database user and password along with Connection string.
On the second tab, chose few objects and started doing reverse engineering. Thinking it is too much time consuming process, as it could not finish 450 objects in around 6 hours.
It has given the following message: I am thinking the reason for the following error is "Server (This is a development server) has been shutdown after 6 hours for other reasons. And I am thinking this message is due to that, though not positive.
Now I am just trying with selecting fewer objects (225)
Message
-------
RME-02107: Cannot fetch without 'select' variables defined
--------------------------------------------------------------------------------
Message
-------
RME-02125: Failed to fetch next row(s)
--------------------------------------------------------------------------------
Message
-------
RME-02107: Cannot fetch without 'select' variables defined
Cause
-----
Internal software problem. An attempt was made to
fetch from a cursor without any SELECT variable defined.
Action
------
--------------------------------------------------------------------------------
Message
-------
RME-02125: Failed to fetch next row(s)
Cause
-----
An error occurred while attempting to fetch the next row(s)
in an open cursor.
Action
------
Examine reported errors for specific details.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
