Or alternatively - you did Commit after inserting the data with worksheet
didn't you ?
--
John
(Remove NOSPAM to reply)
------------------------------------------------
"Reasonable people adapt themselves to the world. Unreasonable people
attempt to adapt the world to themselves. All progress, therefore, depends
on unreasonable people."
-George Bernard Shaw
<unixsysad_at_my-deja.com> wrote in message news:9328ij$geb$1_at_nnrp1.deja.com...
> 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 - 11:17:41 CST
