September 1st, 2012, 03:05 PM
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,
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.