Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle 8i personal version
John
This will be even worse. Don't forget he's connected as sys so he's going to
see lots of meaningless stuff starting with v_$ etc.
Dann-o
You need to connect as a user like 'scott' if you want to create some test
tables and then check them out with your 'select * from tab;' query.
Regards
Nick
"John Alexander" <jalexander_at_summitsoftwaredesign.com> wrote in message
news:HtAY5.21919$58.3993925_at_typhoon.tampabay.rr.com...
> select *
> from user_tables
> /
>
> Dann-o <d.ruttle_at_ntlworld.com> wrote in message
> news:huzY5.1892$Vv1.42421_at_news6-win.server.ntlworld.com...
> > I have installed Oracle succesfully on win 98 and created a database
using
> > the Oracle wizard.
> >
> > I am using the "INTERNAL" username and password to start the database
and
to
> > log in to SQL Plus, which works fine.
> >
> > My problem is that when I issue the SQL command:
> >
> > select * from tab;
> >
> > I get loads of system related tables, when all I really want are those
that
> > I have created.
> >
> > I'm very new to Oracle, so any pointers to solving this problem would be
> > greatly appreciated.
> >
> > regards
> > Dann-o
> >
> >
> >
>
>
Received on Sun Dec 10 2000 - 10:36:58 CST