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.