# Reverse engineering views-only Oracle Schema returns nothing

**URL:** <https://forums.toadworld.com/t/reverse-engineering-views-only-oracle-schema-returns-nothing/2288>\
**Category:** Toad Data Modeler\
**Created:** [May 26, 2010, 11:59am UTC](https://forums.toadworld.com/t/reverse-engineering-views-only-oracle-schema-returns-nothing/2288 "2010-05-26T11:59:50Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![tggagne](https://avatars.discourse-cdn.com/v4/letter/t/ed8c4c/32.png) [@tggagne](https://forums.toadworld.com/u/tggagne)\
**Post date:** [May 26, 2010, 11:59am UTC](https://forums.toadworld.com/t/reverse-engineering-views-only-oracle-schema-returns-nothing/2288/1 "2010-05-26T11:59:50Z")

</div>

I /really/ need to create a model of a People Soft Oracle Schema that contains only views.

After going through the wizard and telling it not to RE entities but everything else, the resultant model has /nothing/. It does have all the users listed, including the one I’m trying to RE, but no views show up.

Does anyone know what the trick is to REing views inside an Oracle Schema’s Users?

---

<div class="post-metadata">

**Author:** ![tggagne](https://avatars.discourse-cdn.com/v4/letter/t/ed8c4c/32.png) [@tggagne](https://forums.toadworld.com/u/tggagne)\
**Post date:** [May 26, 2010, 12:32pm UTC](https://forums.toadworld.com/t/reverse-engineering-views-only-oracle-schema-returns-nothing/2288/2 "2010-05-26T12:32:03Z")

</div>

It looks like the answer is to:

1. create an empty (new) physical model
2. from the file-\>connection, connect to your target
3. Use the connection dialog’s “Live RE”, select the user schema, the objects beneath it, and drag those objects onto the physical model

So, even though I’ll say the question was “answered,” I’m disappointed in the result. The views don’t include their attributes. I guess I’ll ask that as a separate question.

---

<div class="post-metadata">

**Author:** ![frahuang](https://avatars.discourse-cdn.com/v4/letter/f/b38774/32.png) [@frahuang](https://forums.toadworld.com/u/frahuang)\
**Post date:** [May 26, 2010, 1:01pm UTC](https://forums.toadworld.com/t/reverse-engineering-views-only-oracle-schema-returns-nothing/2288/3 "2010-05-26T13:01:21Z")

</div>

In the Options page of the RE wizard, you should uncheck the option “Load Objects Only from Users/Schemas of Selected Tables”. It’s the first option in the Options page. Then you should get the views to display in the result diagram.

However, currently the Views does not display attributes. It’s a enhancement request for future release.

---

<div class="post-metadata">

**Author:** ![tggagne](https://avatars.discourse-cdn.com/v4/letter/t/ed8c4c/32.png) [@tggagne](https://forums.toadworld.com/u/tggagne)\
**Post date:** [May 26, 2010, 1:43pm UTC](https://forums.toadworld.com/t/reverse-engineering-views-only-oracle-schema-returns-nothing/2288/4 "2010-05-26T13:43:14Z")

</div>

That worked. Thank you. The RE ran much longer that way than the drag-and-drop earlier, but it still worked.

Regarding the empty views, if populating views with attributes is already a feature request, and 3.5 just came out, I don’t expect to see it implemented soon.

Even if it were, I need to find another tool to do the same thing or do it manually (36 views).

---

<div class="post-metadata">

**Author:** ![vladka](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/vladka/32/41_2.png) [@vladka](https://forums.toadworld.com/u/vladka)\
**Post date:** [June 1, 2010, 2:49am UTC](https://forums.toadworld.com/t/reverse-engineering-views-only-oracle-schema-returns-nothing/2288/5 "2010-06-01T02:49:41Z")

</div>

Hi,

Just a quick update on the populating views with attributes request - it will not be supported in next v. 3.6 either. We believe to support it in v. 3.7.

Thanks for your patience.

Regards,

Vladka + TDM Team

---

<div class="post-metadata">

**Author:** ![brad.shacker](https://avatars.discourse-cdn.com/v4/letter/b/439d5e/32.png) [@brad.shacker](https://forums.toadworld.com/u/brad.shacker)\
**Post date:** [August 18, 2015, 9:49am UTC](https://forums.toadworld.com/t/reverse-engineering-views-only-oracle-schema-returns-nothing/2288/6 "2015-08-18T09:49:05Z")

</div>

Aug 18 2015 - ?? still not supported in v 5.2.

Is this frequent customer request still “active” as a Change Request?
