Table of Contents

Search

  1. Preface
  2. Introduction to Data Validation Option
  3. Repositories
  4. XML Data Source
  5. Tests for XML Data Sources
  6. Connections
  7. Expressions
  8. Table Pairs
  9. Tests for Table Pairs
  10. Single-Table Constraints
  11. Tests for Single-Table Constraints
  12. Examples of Tests from Spreadsheets
  13. SQL Views
  14. Lookup Views
  15. Join Views
  16. Aggregate Views
  17. Business Intelligence and Reporting Tools Reports
  18. Dashboards
  19. DVOCmd Command Line Program
  20. Troubleshooting
  21. Appendix A: Datatype Reference
  22. Appendix B: Reporting Views
  23. Appendix C: Metadata Import Syntax
  24. Appendix D: Jasper Reports
  25. Appendix E: Glossary

Data Validation Option User Guide

Data Validation Option User Guide

Overriding the Owner or Table Name

Overriding the Owner or Table Name

You can override the owner name or table name for the source table in a lookup view. You may need to override the owner name if the table exists in a different schema. You may need to override the table name if the table name changes or you want to use a different table that has the same table metadata.
To perform the override, enter the new owner name, table name, or both in the Override Owner Name connection property for the source table. When you enter the new owner name or table name, you must use a valid syntax.
You must have Execute permission on the owner name to override the owner name.
The following table specifies the required syntax for each type of override:
Type of Override
Syntax
Change owner name.
<Owner Name>
Change table name.
/<Table Name>
Change owner name and table name.
<Owner Name>/<Table Name>