What is difference between base table and data dictionary views?

  • Interview Candidate
  • 1
  • 3752

Showing Answers 1 - 1 of 1 Answers

kunal1017

  • Jan 10th, 2008
 

Hi
Base tables are made when the database is created and these tables are stored in data dictionary. these base tables contains the information related to the database.  these tables are own by sys.
the information in these tables is crypted and cannot be modified.

So we use the views to  access the information in these base tables. these views are called data dictionary views. these views are created when we run the script
@ ORACLE_HOME/RDBMS/ADMIN/CATALOG.SQL

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions