Oracle使用总结

1、新增数据提示违反约束：

附上sqlserver 查询数据表的主键约束：

--查询用户自建的表约束
SELECT OBJECT_NAME(OBJECT_ID) AS NameofConstraint,
SCHEMA_NAME(schema_id) AS SchemaName,
OBJECT_NAME(parent_object_id) AS TableName,
type_desc AS ConstraintType
FROM sys.objects
WHERE type_desc LIKE '%CONSTRAINT'
and OBJECT_NAME(OBJECT_ID) like 'PK_SYS_BUTTON%'

2、ORA-01502:索引或这类索引的分区处于不可用状态：