SELECT CONSTRAINT_TYPE, CONSTRAINT_NAME, INDEX_NAME FROM USER_CONSTRAINTS
SELECT * FROM USER_CONSTRAINTS T WHERE T.CONSTRAINT_NAME = 'PK_T_ADMINER'
ALTER TABLE T_ADMINER DISABLE CONSTRAINT PK_T_ADMINER;
ALTER TABLE T_ADMINER ENABLE CONSTRAINT PK_T_ADMINER;
ALTER TABLE TABLE_NAME DISABLE CONSTRAINT CONSTRAINT_NAME;
SELECT 'ALTER TABLE '|| TABLE_NAME ||' DISABLE CONSTRAINT '||CONSTRAINT_NAME||';' FROM USER_CONSTRAINTS
SELECT 'ALTER TABLE '|| TABLE_NAME ||' ENABLE CONSTRAINT '||CONSTRAINT_NAME||';' FROM USER_CONSTRAINTS
SELECT * FROM ALL_TRIGGERS
SELECT 'ALTER TRIGGER '|| TRIGGER_NAME ||' ENABLE'||';' FROM ALL_TRIGGERS
SELECT 'ALTER TRIGGER '|| TRIGGER_NAME ||' DISABLE'||';' FROM ALL_TRIGGERS
ALTER TRIGGER TG_UNIT ENABLE;
ALTER TRIGGER TG_UNIT DISABLE;
SELECT 'TABLES=(' FROM DUAL;
SELECT T.TABLE_NAME||',' FROM USER_TABLES T WHERE T.PARTITIONED ='NO';
SELECT ')' FROM DUAL;
--查看表在哪个表空间:
select table_name,TABLESPACE_NAME from user_tables where table_name=upper('xxx');
--查看用户默认表空间:
select username,default_tablespace from dba_users where username=upper('xxx');
--查看所有用户表
select * from user_tables
--查看用户所有触发器
select * from USER_TRIGGERS
--查看用户所有约束条件
select * from user_CONSTRAINTS
--查看用户所有表空间
select * from user_tablespaceS