Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLDeveloper - Tools - Database Copy - Truncate Destination Before Copying --> truncates not just th

rdocenaDec 17 2019 — edited Jan 29 2020

It is my understanding that the option - Truncate Destination Before Copying, truncates only those involved in copying e.g. Object Copy, objects involved only like source tables selected to be copied would truncate their target tables.

We experienced unexpected behavior that it truncated other tables not just the source tables. Please see attached zipped log.SQLDeveloper_DBCopy_Wizard1.JPGSQLDeveloper_DBCopy_Wizard2.JPGSQLDeveloper_DBCopy_Wizard3.JPGSQLDeveloper_DBCopy_Wizard4.JPG

Comments
Post Details
Added on Dec 17 2019
6 comments
907 views