How can you migrate from a LONG to a LOB data type for a column?
A.
Use the DBMS_MANAGE_LOB.MIGRATE procedure.
B.
Use the UTL_MANAGE_LOB.MIGRATE procedure.
C.
Use the DBMS_LOB.MIGRATE procedure.
D.
Use the ALTER TABLE command.
E.
You cannot migrate from a LONG to a LOB date type for a column.
Explanation:
In Oracle9i, a LONG column in a table can be migrated to a LOB column using the ALTER TABLE
statement. The syntax is:
ALTER TABLE <schema>.<table name> MODIFY <long column name> {CLOB | BLOB |NCLOB}
Incorrect Answers:
A & B These are invalid packages and there is not a Migrate Procedure C: This is not a valid procedure
E: LONG Data Types are migrated to LOB’s using the ALTER TABLE Statement