Create Table As Select Does Not Copy Table's Default Values.
(Doc ID 579636.1)
Last updated on JANUARY 09, 2025
Applies to:
Oracle Database - Enterprise Edition - Version 8.1.7.4 to 19.8.0.0.0 [Release 8.1.7 to 19]Information in this document applies to any platform.
This problem can occur on any platform.
Symptoms
If you use CTAS ( Create Table As Select ) to copy a table, the new duplicate table does not contain the default values of the original table. As a result, if you use DBMS_REDEFINITION.COPY_TABLE_DEPENDENTS, it does not copy column's default values.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |