DE
Гайс, у кого-нибудь есть свободных 5 минут?
???
Size: a a a
2020 June 25
DE
а может и полезной информацией
А от кого ты прячешься?
🍁
ни от кого не прячусь, просто теперь в официальном канале дурова упоминание моего профиля
🍁
вот и все
DE
Ну ты сменил username
DE
И фото
CL
В лс могу?
DE
В лс могу?
А что у тебя случилось?
CL
Выдаёт ошибку
DE
Выдаёт ошибку
Кто?
CL
DROP TABLE OWNER
Error report -
ORA-02449: unique/primary keys in table referenced by foreign keys
02449. 00000 - "unique/primary keys in table referenced by foreign keys"
*Cause: An attempt was made to drop a table with unique or
primary keys referenced by foreign keys in another table.
*Action: Before performing the above operations the table, drop the
foreign key constraints in other tables. You can see what
constraints are referencing a table by issuing the following
command:
SELECT * FROM USER_CONSTRAINTS WHERE TABLE_NAME = "tabnam";
Error report -
ORA-02449: unique/primary keys in table referenced by foreign keys
02449. 00000 - "unique/primary keys in table referenced by foreign keys"
*Cause: An attempt was made to drop a table with unique or
primary keys referenced by foreign keys in another table.
*Action: Before performing the above operations the table, drop the
foreign key constraints in other tables. You can see what
constraints are referencing a table by issuing the following
command:
SELECT * FROM USER_CONSTRAINTS WHERE TABLE_NAME = "tabnam";
DE
Ну написано же
DE
Тебе перевести?
CL
Так а я не понимаю, где тут
CL
DROP TABLE owner1;
CREATE TABLE owner1 (
idowner NUMBER(3),
oname VARCHAR2(25),
osurname VARCHAR2(25),
email VARCHAR2(50),
oinfo VARCHAR2(1000),
PRIMARY KEY ( idowner )
);
CREATE TABLE owner1 (
idowner NUMBER(3),
oname VARCHAR2(25),
osurname VARCHAR2(25),
email VARCHAR2(50),
oinfo VARCHAR2(1000),
PRIMARY KEY ( idowner )
);
DE
SELECT * FROM USER_CONSTRAINTS WHERE TABLE_NAME = "owner1";DE
ещё и оракл
А как ты определил?
DE
О точно! Спс, я и не заметил