When trying to use the "Copy Data to Another Schema" option, if the data contains only space character(s) (to leave a field blank, but not NULL), it will copy over as NULL and not space character(s).
This also creates a problem with enabling and disabling a NULL constraints that might be associated with the table.
WORKAROUND:
none
STATUS:
Waiting for fix in a future version of Toad for Oracle.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy