Uer, cant see the tables created Options

[Sandeep Verma]

Hi,

I am stuck on a problem which is sounding weired here is the description:

1. I logged in the oracle sqlplus using cmd with sys as sysdba user and run the attached script for creation of some tables.
2. The script ran successfully and I could see the data in all tables which are , select * from authors; select * from books; select * from inventory;
3. I logged in with same user using toad and no such table is showing.

wondering what can be the problem!!

PS: I used commit after step 2.

Thanks in advance for any help.

Regards
Sandeep Verma

Attached File(s)

 PlsqlBlock___.txt ( 21.52K ) Number of downloads: 1

 

[dave]

you logged in with what user?

you created those tables in the sys schema, which is a bad thing to do