Re: SQL*Plus Copy Command Question

If your column is supposed to be not null, why do you have a space in there? If you do not want to use an insert statement, then first update the rows containing the space with another value like N/A or something else. Mickey.

Christopher L. Beck (clbeck_at_us.oracle.com) wrote:
: rspencer_at_aol.com (RSpencer) wrote:
 

: >I have encountered a problem with using the copy command in SQL*Plus in
: >Oracle v7.0. I get an error in trying to copy data between identical
: >tables in two databases. These tables have not null constraints for
: >several columns. In my source table some rows for these not null varchar2
: >columns contain a value of a space. The SQL*Plus copy command interprets
: >these as null. Then the copy fails with an error message saying that a
: >mandatory attribute is missing or null during insert. Is there a way
: >around this problem?
 

: Try:
 

: insert into SOURCE_TABLE ( select * from DEST_TABLE );
 

: This will copy all the data, including spaces, from one table to the
: other.
 

: chris.
: --
: clbeck_at_us.oracle.com
 

: --
: clbeck_at_us.oracle.com
: Oracle Government
Received on Wed Sep 13 1995 - 00:00:00 CEST