![]() ![]() If the name_clause were supplied as Employees or employees or any other variation, then the table would not be found.ĭepending on your operating system, the use of quotation marks when you specify a value for this parameter may also require that you use escape characters. For example, if the name_clause you supply is for a table named EMPLOYEES, then there must be an existing table named EMPLOYEES using all upper case. The name that you supply for the name_clause must exactly match, including upper and lower casing, an existing object in the database. ![]() It must be separated from the object type with a colon and enclosed in double quotation marks, because single quotation marks are required to delimit the name strings. 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. ArchivesCategories |