What is the purpose of the option View — Options — DB Capture –> Use Base Tables and when should I use it?
This option determines whether TOYS uses the base catalog tables as opposed to using the regular catalog views such as DBA_TABLES, USER_TABLES, etc. When enabled, TOYS will use the base table catalogs on the proviso that your session has the SELECT ANY TABLE privilege [Oracle 7 and 8] or has SELECT ANY DICTIONARY privilege [Oracle 9]. If your session does not have this privilege then TOYS ignores this option setting as there is no choice but to use the regular view catalogs. So, what are the effects of using the base catalog tables? Answer: speed and accuracy. First, speed. It is significantly faster to use the base catalog tables. Why is this so? Because, TOYS can perform certain specializations when accessing the base tables directly. These specializations are not possible via the regular catalog views. Second, accuracy. There are a number of bugs in the catalog views. These are mentioned in other FAQs. For a detailed discussion of the various issues read the topic in the Help manual
Related Questions
- The option quotes page does not display all of the months I expected to see. How can I view options contracts for latter months?
- What is the purpose of the option View -- Options -- DB Capture --> Use Base Tables and when should I use it?
- What is the "Master Elements" option used for in the View Options dialog?
