4 Replies Latest reply: Jan 31, 2013 1:55 PM by 982988 RSS

    SQL Developer 3.2.20.09 - Database Export generating an unusable file

    982988
      I am using the Database Export option in the tools menu to create a script to create schema objects. Unfortunately, the output of the script is not very usable. There seem to be extra '/' throughout the script. Here is a sample:

      --------------------------------------------------------
      -- DDL for Sequence ADDL_INFO_GROUP_SEQ
      --------------------------------------------------------

      CREATE SEQUENCE "ADDL_INFO_GROUP_SEQ" MINVALUE 1 MAXVALUE 2147483647 INCREMENT BY 1 START WITH 1 CACHE 1000 NOORDER CYCLE ;
      /
      --------------------------------------------------------
      -- DDL for Sequence ADDL_INFO_NAME_LANG_SEQ
      --------------------------------------------------------

      CREATE SEQUENCE "ADDL_INFO_NAME_LANG_SEQ" MINVALUE 1 MAXVALUE 2147483647 INCREMENT BY 1 START WITH 1 CACHE 1000 NOORDER CYCLE ;
      /
      --------------------------------------------------------
      -- DDL for Sequence ADDL_INFO_VALUE_SEQ
      --------------------------------------------------------

      CREATE SEQUENCE "ADDL_INFO_VALUE_SEQ" MINVALUE 1 MAXVALUE 2147483647 INCREMENT BY 1 START WITH 1 CACHE 1000 NOORDER CYCLE ;
      /
      --------------------------------------------------------
      -- DDL for Sequence ATTACHMENT_GROUP_SEQ
      --------------------------------------------------------

      CREATE SEQUENCE "ATTACHMENT_GROUP_SEQ" MINVALUE 1 MAXVALUE 2147483647 INCREMENT BY 1 START WITH 1 CACHE 1000 NOORDER CYCLE ;
      /

      Obviously, having both the ';' at the end of the statement and the '/' on the following line will cause an error when the script is executed.

      Has anyone else seen this kind of behavior?