Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
|
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 2nd, 2005, 08:38 AM
Registered User
 
Join Date: Mar 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to info2shiva
Default Data _Dictionary_objects

Hi every body ! hope every body are fine and Doing well with our GRACIOUS ORACLE.
I have heard that the objects in the data dictonary are only views .
and doesn't comprise of any table type objects .
But we can say that view is a subset of table (in deed which exists based on some base table ) .
Is this correct . If so how had these views devloped .

Thank you .
Bye
Shiva Kumar:)

Regards
Shiva
Have a nice time !
 
Old March 3rd, 2005, 09:40 AM
Registered User
 
Join Date: Feb 2005
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to SureshHyd
Default

It is true that we can access data dictionary thru views provided by oracle database. It directly does not expose the metadata information to user due to security issues. As far as i know, internally the metadata is stored in tables only. To protect this information from users, it provides different types of views based on role like dba_tables, all_tables, user_tables etc. In Oracle 9i, we have object types also, but they are internally stored in tables only.
if you find any info contradictory to this, please do let me know.





Similar Threads
Thread Thread Starter Forum Replies Last Post
problem in e-mail structure sending data from data tiawebchd General .NET 3 May 5th, 2008 08:07 AM
Data Binding - Editing GridView Row Data desk_star BOOK: Professional ASP.NET 2.0 and Special Edition; ISBN: 978-0-7645-7610-2; ISBN: 978-0-470-04178-9 7 December 30th, 2007 11:07 AM
Transfering data from csv file to data base g_vamsi_krish ASP.NET 1.0 and 1.1 Professional 2 May 16th, 2006 11:58 PM
Binding to Filtered Data (or Data subsets) gdbjohnson C# 8 August 27th, 2004 01:59 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.