![]() ![]() The name_clause applies only to object types whose instances have names (for example, it is applicable to TABLE, but not to GRANT). It consists of a SQL operator and the values against which the object names of the specified type are to be compared. It is a SQL expression used as a filter on the object names of the type. It allows fine-grained selection of specific objects within an object type. No other object types, including the schema definition information that is normally part of a schema-mode export when you have the DATAPUMP_EXP_FULL_DATABASE role, are exported. Only object types explicitly specified in INCLUDE statements, and their dependent objects, are exported. (See " Metadata Filters" for an example of how to perform such a query.) The values listed in the OBJECT_PATH column are the valid object types. To see a list of valid values for object_type, query the following views: DATABASE_EXPORT_OBJECTS for full mode, SCHEMA_EXPORT_OBJECTS for schema mode, and TABLE_EXPORT_OBJECTS for table and tablespace mode. The object_type specifies the type of object to be included. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |