Bagaimana cara memperbaiki kesalahan 'nama sudah digunakan' di Oracle SQL?
CREATE TABLE permission (
user_id INTEGER NOT NULL,
device_id VARCHAR2(20) NOT NULL,
permission_type VARCHAR2(20),
permission_id INTEGER NOT NULL
)
LOGGING;
ALTER TABLE permission ADD CONSTRAINT permission_pk PRIMARY KEY ( permission_id );
Saya mendapatkan kesalahan berikut,
Error report -
ORA-00955: name is already used by an existing object
00955. 00000 - "name is already used by an existing object"
*Cause:
*Action:
permission
mungkin sudah ada. Jatuhkan dulu. - person Gordon Linoff   schedule 13.04.2019