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!

SQL Developer 23.1 dbms_metadata.get_ddl output truncated

Olivier GabreauApr 21 2023

Hello SQL Dev team,

New version implies new bugs sadly. But this one is a regression :-(

DDL Code extracted from the database using DBMS_METADATA package is truncated.

SELECT DBMS_METADATA.get_ddl ('TABLESPACE', tablespace_name)
FROM dba_tablespaces
WHERE tablespace_name = 'FOODSUP';

-- 23.1 --

-- 22.2.1 --

Executing with Run Script yields the complete command.

Comments
Post Details
Added on Apr 21 2023
14 comments
2,102 views