#1
  1. No Profile Picture
    Contributing User
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Jul 2003
    Posts
    3,622
    Rep Power
    595

    Noob create table trouble


    I am trying to create a table that will increment my ID by one using the following commands:

    /*Creates the log needed to increment ID*/
    create sequence seq_log;

    CREATE TABLE MESSAGE_LOG_TABLE
    (
    ID NUMBER(10) NOT NULL PRIMARY KEY,
    TABLE_NAME VARCHAR(50) NOT NULL,
    MESSAGE_COMMENTS VARCHAR(100),
    SYSTEM_DATE DATE NOT NULL
    );


    When I run the above my create sequence completes successfully but I get a ORA-00955: name is already used by an existing object error message on the create table. I have dropped all tables and sequences before running my command but I still get the same error message.

    After it bombs out it appears that SQL+ want's more information for it begins to give me line numbers as if it is looking for a ";" to end the above command. I have to exit SQL+ and log back in to continue working.

    Can someone please tell me what I am doing wrong?
    There are 10 kinds of people in the world. Those that understand binary and those that don't.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Jul 2003
    Posts
    3,622
    Rep Power
    595
    I figured out what my problem was.

    I had left some commented lines in the command that it was not liking.
    There are 10 kinds of people in the world. Those that understand binary and those that don't.

IMN logo majestic logo threadwatch logo seochat tools logo