Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Uer, cant see the tables created
Sandeep Verma
post Apr 22 2012, 05:10 PM
Post #1


Newbie
*

Group: Members
Posts: 1
Joined: 22-April 12
Member No.: 47,114



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)
Attached File  PlsqlBlock___.txt ( 21.52K ) Number of downloads: 1
 
Go to the top of the page
 
+Quote Post
dave
post Apr 23 2012, 03:11 AM
Post #2


Advanced Member
***

Group: Members
Posts: 5,206
Joined: 8-October 04
Member No.: 785



you logged in with what user?

you created those tables in the sys schema, which is a bad thing to do
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 22nd July 2014 - 04:14 AM