This discussion is archived
4 Replies Latest reply: Jan 31, 2013 11:55 AM by 982988 RSS

SQL Developer 3.2.20.09 - Database Export generating an unusable file

982988 Newbie
Currently Being Moderated
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?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points