An owner ID is a string used as an implicit qualifier for table names and index names. The ID applies to the execution of every SQL statement. In the DDL, owner IDs appear as a prefix to table and index names in CREATE and DROP statements.
This feature is useful for allowing multiple individuals to have their own test databases on the same server encyclopedia.
Important! Be careful when using the Qualify Tables and Indexes with OwnerID check box for remote installations. When the DDL is generated with the owner ID included in the table and index names, there may be difficulty installing the DDL unless the ID of the user installing the DDL is exactly the same as the user ID found in the DDL. To avoid the possibility of errors during installation, do not specify qualification of tables and indexes with your owner ID.
|
Copyright © 2013 CA.
All rights reserved.
|
|