- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle "Database Dictionary"
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-03-2002 05:50 PM
тАО10-03-2002 05:50 PM
Oracle "Database Dictionary"
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-03-2002 08:19 PM
тАО10-03-2002 08:19 PM
Re: Oracle "Database Dictionary"
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-03-2002 08:53 PM
тАО10-03-2002 08:53 PM
Re: Oracle "Database Dictionary"
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-03-2002 09:06 PM
тАО10-03-2002 09:06 PM
Re: Oracle "Database Dictionary"
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-03-2002 10:50 PM
тАО10-03-2002 10:50 PM
Re: Oracle "Database Dictionary"
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-03-2002 11:07 PM
тАО10-03-2002 11:07 PM
Re: Oracle "Database Dictionary"
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-04-2002 12:19 AM
тАО10-04-2002 12:19 AM
Re: Oracle "Database Dictionary"
I got the same output as above when spooled the info into file1. Any idea?
br,
munawar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-04-2002 12:56 AM
тАО10-04-2002 12:56 AM
Re: Oracle "Database Dictionary"
Sorry.. actually that is the right output.
br,
munawwar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-06-2002 12:25 AM
тАО10-06-2002 12:25 AM
Re: Oracle "Database Dictionary"
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-06-2002 11:14 PM
тАО10-06-2002 11:14 PM