|
Explanation: This syntax is correct to perform this task. The TRANSPORT_TABLE SPACE parameter specified as ‘y’, instructs Import to import transportable table space metadata from an export file. All transportable table spaces in EXPDAT.DMP file will be imported for HR user schema. Incorrect Answer: 1: This statement will export only TS_EMPLOYEES table and its data. 2: This statement will export entire schema of HR user. 4: This statement is incorrect: there is no TABLE SPACE parameter in Import utility. Only TABLE SPACES parameter exists. When TRANSPORT_TABLE SPACE is specified as ‘y’, use this parameter to provide a list of table spaces to be transported into the database.
|