oracle add column to existing table

Question

I have already a table in oracle defined as below:

CREATE TABLE GENERAL_STATISTICS.PPLP_LOAD_GENSTAT3
(
  NAME   VARCHAR2(100 BYTE),
  START_TIME  DATE,
  END_TIME    DATE
)

What I would like to achieve is add an extra column at the end (as 4th column to the table). I execute:

ALTER TABLE PPLP_LOAD_GENSTAT3
ADD
(
ROWS_LOADED varchar2(100 BYTE)
);

I receive an error "ORA-01735: invalid ALTER TABLE option"

What would be the correct way to achieve this?

Thank you,

Best Regards

There is nothing wrong with the `alter table` statement. I just ran it OK in 11G. The only possible issue I can think of it if you are using a version of Oracle so old that it doesn't recognise the `byte` keyword? — Tony Andrews, Sep 13 '17 at 10:02
@TonyAndrews , thanks Tony for looking into it, no i use 11g as well. What's so bizarre here.. — tln_jupiter, Sep 13 '17 at 10:04
In the `alter` statement you omitted the schema prefix `GENERAL_STATISTICS.` - are you running the command in that schema? — Tony Andrews, Sep 13 '17 at 10:05
Well there is nothing wrong at all on the face of it. Maybe try re-typing the `alter` command - maybe it has a cut and pasted invisible character in it! — Tony Andrews, Sep 13 '17 at 10:08

score 0 · Answer 1 · answered Dec 11 '19 at 13:29

0

its for the type of field, you must try to change to another type of data

answered Dec 11 '19 at 13:29

jcamt

1 Answers1