Mailing List
Home
Forum Home
Oracle List - by freelists.org
Oracle on SUSE Linux - Runing Oracle on SUSE Linux
Oracle database error code ...
www.freelists.org
Subjects
ORA 12540: TNS:internal limit restriction exceeded
ORA 12838 please : Is possible to append two times to the same table befo
ORA 12838 please : Is possible to append two times to the same table before
ora 04031
ora 12500 on windows
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 01925: maximum of 30 enabled roles exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ora 12500 on windows
ORA 01650, one idea
ORA 01650
ORA 4030
ORA 12838 please : Is possible to append two times to thesametable before do
ORA 12838 please : Is possible to append two times to thesame table before d
ORA 01536
ORA 03113 end of file on communication channel
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 00600:
ORA 00020: maximum number of processes (%s) exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ORA 3113 while creating a cluster database 9201 RAC on Linux with OCFS
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 01650, one idea
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 2000 Error Using DBMS STATS GATHER SCHEMA STATS
ORA 01650, one idea
ORA 01650, one idea
ORA 01650, one idea
ORA 01650
ORA 01650
Subject: ora 01031
ORA 4030
ORA 4030
ORA 06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
Subject: Re: ORA 01722 invalid number
 
Subject: Re: Command to view tables inside a database

Subject: Re: Command to view tables inside a database

2007-11-01       - By Asif Momen

 Back

Hi,

Querying *_TABLES (replace * with ALL, DBA, or USER) view will list you all
tables.

Oracle reference manual lists all the views with description and you may find
it very help.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/toc.htm


Regards


Shwe Yee Than <shweyeesyt@(protected)> wrote: Hi,
 
 I'm new to Oracle Database.  I'm now using Oracle Database 10g Release 2.
Can anyone tell me the command to view all the tables inside a specific oracle
database?

Really appreciate for the helping hands.

Regards,
Shwe __ ____ ____ ____ ____ ____ ____ ____ ____ ____ __
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com


__ ____ ____ ____ ____ ____ ____ ____ ____ ____ __
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
<br>Hi,<br><br>Querying *_TABLES (replace * with ALL, DBA, or USER) view will
list you all tables. <br><br>Oracle reference manual lists all the views with
description and you may find it very help. <br><br>http://download.oracle.com
/docs/cd/B19306_01/server.102/b14237/toc.htm<br><br><br>Regards<br><br><br><b><i
>Shwe Yee Than &lt;shweyeesyt@(protected)&gt;</i></b> wrote:<blockquote class=
"replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px;
padding-left: 5px;"> Hi,<br>  <br>  I'm new to Oracle Database.&nbsp; I'm now
using <span class="parahead1">Oracle Database 10<i>g</i> Release 2.&nbsp; Can
anyone tell me the command to view all the tables inside a specific oracle
database?<br> <br> Really appreciate for the helping hands.<br> <br> Regards,
<br> Shwe</span><div> __ ____ ____ ____ ____ ____ ____ ____ ____ ____ __<br>Do
You Yahoo!?<br>Tired of spam?  Yahoo! Mail has the best spam protection around
<br>http://mail.yahoo.com
</div></blockquote><br><p>&#32;__ ____ ____ ____ ____ ____ ____ ____ ____ ____
___<br>Do You Yahoo!?<br>Tired of spam?  Yahoo! Mail has the best spam
protection around <br>http://mail.yahoo.com