Home » SQL & PL/SQL » Client Tools » Cant see the tables created (10g)
Cant see the tables created [message #551948] Sun, 22 April 2012 17:18 Go to next message
s4sandeep
Messages: 21
Registered: August 2011
Location: Faridabad, India
Junior Member

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
Re: Cant see the tables created [message #551949 is a reply to message #551948] Sun, 22 April 2012 17:21 Go to previous messageGo to next message
BlackSwan
Messages: 25854
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

You should NOT be creating any objects in SYS schema.
CREATE statement is DDL & therefore does implicit COMMIT so no explicit COMMIT is required.

[Updated on: Sun, 22 April 2012 17:21]

Report message to a moderator

Re: Cant see the tables created [message #551950 is a reply to message #551949] Sun, 22 April 2012 17:26 Go to previous messageGo to next message
s4sandeep
Messages: 21
Registered: August 2011
Location: Faridabad, India
Junior Member

Hi BlackSwan,

Thanks for your reply, but is this the reason (creating table in sys schema ) I am facing this problem?

This schema is not the production one, its just my personal pc's oracle schema.

Thanks
Sandeep Verma
Re: Cant see the tables created [message #551974 is a reply to message #551950] Mon, 23 April 2012 01:16 Go to previous message
Michel Cadot
Messages: 65385
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
- Never ever use SYS (or SYSDBA) but for maintenance purpose (startup, shutdown, backup, recover)
- SYS/SYSDBA is special
- SYS/SYSDBA is Oracle proprietary (try to open a SR/TAR starting with "i did that with SYS/SYSDBA" and you'll see the immediate answer)
- SYS/SYSDBA does not act like any other user
- When you use SYS/SYSDBA Oracle deactivates some code path and activates others
- Whatever you do with SYS/SYSDBA will neither validate nor invalidate the same thing with any other user.

NEVER EVER use SYS/SYSDBA for anything that can be done by another user.
Use SYS/SYSDBA ONLY for something that can't be done by someone else.


Regards
Michel
Previous Topic: problem related to database mount
Next Topic: PL\SQL Developer - paste option
Goto Forum:
  


Current Time: Tue Feb 20 02:28:05 CST 2018

Total time taken to generate the page: 0.03106 seconds