Re: Newbie Question

If I am not incorrect, when you logged into schema manager as "manager" and you look for the information, you have to specify the owner, which in this case would be "scott". To do this is just a matter of putting "scott" in front of the table, ie scott.tablename. Try this and see what you get. Hopefully this will help you out.

Gene Martin

In article <KE056.5149$3t2.195214_at_newsread1.prod.itd.earthlink.net>,   "Gary J. Groomer" <gary_at_designfirst.com> wrote:
> I just installed Oracle 8i Personal Edition on my computer for local
> development and testing. I ran into a strange problem with the first
 table
> that I created.
>
> I opened the SQL* Plus Worksheet and ran a script to create a simple
 table
> and insert data into it. I used a SQL SELECT * to view the data and
> everything appeared as expected. Then, I tried to access the data
 from an
> external application and then from the Oracle Schema Manager and no
 data
> showed up. Then, I added some data, manually, with the Schema
 Manger's Data
> Editor. The newly added data showed up in the Schema Manager Data
 Editor
> and the external application, but not the data inserted previously
 with SQL*
> Plus Worksheet. Next, I went to the SQL* Plus Worksheet and ran a SQL
> SELECT * and the old and the new data showed up. Why isn't all of
 the data
> showing up in the Schema Manager Data Editor and the external
 application?
>
> Keep in mind that I have yet to create any new views and/or new
 users. I
> logged into the Schema Manager as system/manager and the SQL* Plus
 Worksheet
> as scott/tiger. Any help would be greatly appreciated.
>
> Gary Groomer
>
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 04 2001 - 10:32:19 CST