SQL Plus syntax for adding a field to a table

quinnd6 · 28-05-2007 03:57PM #1

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 · 28-05-2007 04:01PM

sounds like a security issue

try providing the schema name with the table name

Alter SchemaName.TableName ...

Tom Dunne · 28-05-2007 04:04PM

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

bonkey · 28-05-2007 04:20PM

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 · 28-05-2007 04:57PM

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

8k2q1gfcz9s5d4 · 30-05-2007 03:40PM

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

SQL Plus syntax for adding a field to a table

Comments