Home » SQL & PL/SQL » SQL & PL/SQL » How to view a table in 10g Express?
How to view a table in 10g Express? [message #226204] Thu, 22 March 2007 17:34 Go to next message
mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO
Senior Member

Okay, so I create two tables as SYS. When I execute an SQL "DESCRIBE <tablename>" statement, it says the tables do not exist. They DO exist, however, in USER_OBJECTS. A quick, but hopefully not TOO stupid a question: How do I access these tables? Am I not SYS when I execute an SQL statement (using the Web interface.
Re: How to view a table in 10g Express? [message #226208 is a reply to message #226204] Thu, 22 March 2007 19:01 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>Okay, so I create two tables as SYS.
BAD idea/action!

>When I execute an SQL "DESCRIBE <tablename>" statement, it says the tables do not exist.
As what user are you logged in as when you do DESC?
SQL> SHOW USER -- displays what results?


>How do I access these tables?
As you do a table in any other schema (assuming you have permissions to do so)as; SCHEMA_OWNER.TABLE_NAME.

>Am I not SYS when I execute an SQL statement (using the Web interface.
Most likely NOT the SYS user; which would be BAD idea.

I suggest you visit http://tahiti.oracle.com & read the fine Concepts Manual to start you Oracle education.
Re: How to view a table in 10g Express? [message #226240 is a reply to message #226204] Fri, 23 March 2007 01:18 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Did you by any chance create a table with a mixed case name? (does the tablename in user_objects show as mixed case?)
Re: How to view a table in 10g Express? [message #226447 is a reply to message #226204] Fri, 23 March 2007 15:07 Go to previous message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
When you setup a database, the VERY FIRST THING you do before witting any thing is to create another use with minimal privileges and then ONLY use it for developing. Unless you want to trash your system, NEVER use SYS for anything.
Previous Topic: Duplicates
Next Topic: cannot drop table
Goto Forum:
  


Current Time: Mon Dec 05 21:24:51 CST 2016

Total time taken to generate the page: 0.08591 seconds