SQL Plus syntax for adding a field to a table

quinnd6

How do I add a field to a table in sql plus on oracle?
whats the correct syntax can Ive an example?

Ive tried

alter table tablename add(fieldname varchar2(25));

It said table or view doesn't exist so am puzzled cos the tablename I used does exist.

DonnieBrasco

sounds like a security issue

try providing the schema name with the table name

Alter SchemaName.TableName ...

Tom Dunne

Yeah, are you sure you have permissions, because the syntax is correct.

bonkey

Its possible that the table you're referencing is owned by another user, and that you're avoiding having to supply the schema-name because of a public synonym.

I think that in a case like ALTER TABLE, public synonyms won't be used so if its owned by another user, then you need to use schemaname.tablename as DonnieBrakso suggested.

quinnd6

Yep there was a different command I had to enter in order to edit the table cheers guys.

8k2q1gfcz9s5d4

are you in the correct database? that always gets me!