Permissions

One of the following must apply:

• You own the table.
• The table has select (for copy into) or insert (for copy from) permission granted to public.
• You have been granted copy_into (for copy into) or copy_from (for copy from) privileges on the table.

Locking

• When copying from a table into a file, the DBMS Server takes a shared lock on the table.
• When performing a bulk copy into a table, the DBMS Server takes an exclusive lock on the table. Because bulk copy cannot start until it gets an exclusive lock, this operation can be delayed due to lock contention.
• When performing a non-bulk copy into a table, the DBMS server takes an "intended exclusive" lock on the table, and uses insert to update the table. As a result, the operation can be aborted due to deadlock.

Restrictions and Considerations

Copy cannot be used to add data to a view, index, or system catalog.

When copying data into a table, copy ignores any integrity constraints defined (using the create integrity statement) against the table.

When copying data into a table, copy ignores ANSI/ISO Entry SQL-92 check and referential constraints (defined using the create table and alter table statements), but does not ignore unique (and primary key) constraints.

The copy statement does not fire any rules defined against the table.

Values cannot be assigned to system_maintained logical key columns. The DBMS Server assigns values when copying from a data file to a table.

Related Statements

Create Table

Modify