Name

SET COPYTYPECHECK

Synopsis

The COPYTYPECHECK setting controls whether SQL*Plus checks the datatypes when you use the COPY command to move data between two databases.

Syntax

SET COPYTYPECHECK {OFF | ON}

Parameters

OFF

Turns off type checking.

ON

Enables type checking. This is the default setting.

This setting was created specifically for use when copying data to a DB2 database.

Get Oracle SQL*Plus: The Definitive Guide, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.