Solved

know tables in the database

Posted on 2007-04-04
3
787 Views
Last Modified: 2013-12-18
hi

i have yet to install oracle in my company laptop. in one the application, on one page i can actually run a query and get the results.
i wanted to know what is the name of the database and what tables reside in it
i ran these 2 queries
select * from global_name gives below
global database name TESTINGDB.WRD

select name from v$database
TESTINGDB

so the db is basically Testing...but what is WRD. So if I need to know the tables in the database testingdb what query do i need to run?
0
Comment
Question by:samir25
  • 2
3 Comments
 
LVL 23

Assisted Solution

by:paquicuba
paquicuba earned 450 total points
ID: 18850449
AS a DBA:
SELECT OWNER||'.'||TABLE_NAME FROM DBA_TABLES;

As a USER:
SELECT OWNER||'.'||TABLE_NAME FROM ALL_TABLES;
SELECT TABLE_NAME FROM USER_TABLES;
0
 
LVL 12

Assisted Solution

by:jwahl
jwahl earned 50 total points
ID: 18850460
try

SELECT owner, table_name
FROM all_tables;


0
 
LVL 23

Accepted Solution

by:
paquicuba earned 450 total points
ID: 18850648
>> but what is WRD
WRD is the database domain name

1. What is a global database name?
----------------------------------
The global database name is the unique name of the database.

In a distributed database system (a set of databases stored on multiple
computers that typically appears to applications as a single database) the
global database names ensure that each database is distinct from all other
databases in the system. Oracle forms a databases global database name by
prefixing the databases network domain with the individual databases name.

For example: sales.us.oracle.com and sales.uk.oracle.com

The global database name defaults to DB_NAME.DB_DOMAIN and this value
is marked at database creation time. If you change the DB_NAME or
DB_DOMAIN after the database has been created, the value for the global
database name (GLOBAL_NAME) will not change.

2. How to determine the current global database name?
-----------------------------------------------------

A public view with the name GLOBAL_NAME is available which issues a query
on the table props$. So any user can find out the global database name
by querying this public view:

SELECT * FROM global_name;

GLOBAL_NAME
----------------------
TEST815.CH.ORACLE.COM


3. How to change the global database name?
------------------------------------------
To change the global database name, issue the following command
(renaming the global database name will not change the value of the
DB_NAME or DB_DOMAIN parameters):

ALTER DATABASE RENAME GLOBAL_NAME TO remote1.oracle.com;


4. Related parameters in init<SID>.ora file.
--------------------------------------------
GLOBAL_NAMES = [TRUE | FALSE]
The parameter GLOBAL_NAMES specifies whether a database link is required
to have the same name as the global database name to which it connects.
If the value of GLOBAL_NAMES is FALSE, then no check is performed.
Oracle recommends setting this parameter to TRUE to ensure the use of
consistent naming conventions for databases and links.
To check the current value of this parameter, issue the following command:

SELECT name,value FROM v$parameter WHERE name = 'global_names';

NAME VALUE
---------------- --------
global_names TRUE

You can change the value of this parameter dynamically. This can be done
for the current session only or for the current and all consequent
sessions:

ALTER SESSION SET global_names = TRUE;
ALTER SYSTEM SET global_names = FALSE;


5. Related parameter in listener.ora file.
------------------------------------------
When (for example) a database link is created, Net8 is used to establish a
network session in order to transfer data between the two servers.
Once the network session is established, Net8 acts as a data courier for
the servers. The network session is established with the help of a
listener.
The listener process listens for incoming connection requests and manages
the traffic to the server. The listener verifies the incoming request
information with the information it has received from the database service
as well as information it has stored in its own configuration file
(listener.ora). If the information matches, a connection is granted.

In the LISTENER.ORA file, under the sections SID description, a parameter
GLOBAL_DBNAME can be found. This parameter identifies the
global database name and is the name and domain name of the database,
as given in SERVICE_NAMES parameter in the database initialization
parameter file (init<SID>.ora).

If you want to refer to the database by its global database name on the
network, then you must specify that global database name to the listener.
This parameter must be embedded under SID_DESC and should match the value
of the SERVICE_NAMES parameter. Example:

sid_list_mylistener=
(sid_list=
(sid_desc=
(global_dbname=TEST815.ch.oracle.com)
(sid_name=TEST815)
(oracle_home= D:\Oracle\Ora815)
)
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now