Operating System - HP-UX
1748041 Members
5227 Online
108757 Solutions
New Discussion юеВ

Oracle "Database Dictionary"

 
Ahmad Munawwar
Frequent Advisor

Oracle "Database Dictionary"

Hi,

There is something which really miss-my-minds and that something is the "Database Dictionary". How to retrieve this info from my system (HP-UX 11.0/ ORACLE 8.0.6). Is it possible to print out this information as hard copy.

Please advice.

Regards,
Munawwar

9 REPLIES 9
Animesh Chakraborty
Honored Contributor

Re: Oracle "Database Dictionary"

Hi,
I am not oracle expert.
Are you looking for this dociments?

http://www1.itrc.hp.com/service/cki/docDisplay.do?docLocale=en_US&docId=200000063619670
Did you take a backup?
T G Manikandan
Honored Contributor

Re: Oracle "Database Dictionary"

Data dictionary consists of tables and views which are stored in the system tablespace and has all the information regarding the database like the storage,structure,schema objects,users,etc.

You can get all information of the Oracle data dictionary using the static views and v$ views (dynamic).

For example you can use

select * from v$database;

This is stored in the data dictionary.This will give the information regarding the database name ,version,etc..

Just check this doc

http://www.vi.unizh.ch/oracle8i_816/onlinedocu/doc/server.816/a76961/toc.htm


Thanks
Ravi_8
Honored Contributor

Re: Oracle "Database Dictionary"

Hi,
Data dictionary conatins info about the database,
sql> select * from v$database;
will show you the info

you can take print of this.
when you loggedin(telnet) as oracle to server from your workstation, you can find the 'Terminal' menu. in this choose 'Start Logging' which will be stored in a file that you name.
never give up
Ahmad Munawwar
Frequent Advisor

Re: Oracle "Database Dictionary"

Hi,

I received the following message when do query (select * from v$database):

SQL> select * v from v$database
2 ;

DBID NAME CREATED RESETLOGS_CHANGE# RESETLOGS
---------- --------- --------- ----------------- ---------
PRIOR_RESETLOGS_CHANGE# PRIOR_RES LOG_MODE CHECKPOINT_CHANGE#
----------------------- --------- ------------ ------------------
ARCHIVE_CHANGE# CONTROL CONTROLFI CONTROLFILE_SEQUENCE# CONTROLFILE_CHANGE#
--------------- ------- --------- --------------------- -------------------
CONTROLFI OPEN_RESETL VERSION_T
--------- ----------- ---------
2294475349 BMPA 05-JAN-01 1 05-JAN-01
0 NOARCHIVELOG 949046
928675 CURRENT 05-JAN-01 4676 949046
NOT ALLOWED 05-JAN-01

am i disallowed to retrieve this info?

br,
munawwar

T G Manikandan
Honored Contributor

Re: Oracle "Database Dictionary"

if you want to retrieve them

then do a

sql>spool file1
sql>select * from v$database;
sql>spool off

open the file from the unix prompt and check for the results.

You can use desc v$database to find out the columns.

THen do a

sql>select name from v$database;

Also you can use applications as Toad from questsoftware.com to just get good formatted output.

http://www.toadsoft.com/downld.html

Thanks
Ahmad Munawwar
Frequent Advisor

Re: Oracle "Database Dictionary"

Hi TG,

I got the same output as above when spooled the info into file1. Any idea?

br,
munawar
Ahmad Munawwar
Frequent Advisor

Re: Oracle "Database Dictionary"

Hi,

Sorry.. actually that is the right output.

br,
munawwar
Volker Borowski
Honored Contributor

Re: Oracle "Database Dictionary"

Hi,

actually V$DATABASE is a bit less to discribe the "data dictionary" of a database. It is a whole lot more!

Example:

If you do a

CREATE TABLE BLA
(
key varchar2(2),
data varchar2(30)
);

The created datadictionary information which is stored in several oracle internal tables would be:
- The name of the table
- The name of the columns belonging to this table
- The datatype of the columns
- ....much more additional stuff ...

There are a lot of things that describe your database, and they all together are the "data dictionary".

There is no real sense to extract this information in the way oracle stores it, because there is no real way to read it or to restore it in any way.

Instead there are tools on the market, that do query these oracle internal tables and give you a human readable representation of your data dictionary, even in a way, that you get all the "CREATE ..." Statements so that you can rebuild this data dictionary into a new database. One nices little tool is TOAD, of which a time limited demo version is availabe.

Information can be found here http://www.toadsoft.com/, but I guess there are some twenty other tools like this in the world.

Hope this helps.
Volker


Victor Geere
Frequent Advisor

Re: Oracle "Database Dictionary"

If you have a windows workstation connected to your server, load Visio. Create a new diagram of type Database and connect to your Database using the drivers provided. From the menu select database, reverse engineer. This will list all your tables in a Entity relational diagram. Optionally you can also do this with the tables that make up the Meta Data, or Dictionary, but a entity relational diagram of your data is probably the best option unless you want to interogate the meta data.
I thought that I was because I had thought.