SQL> select constraint_name,status from user_constraints where table_name = 'T';


CONSTRAINT_NAME                STATUS
------------------------------ --------
NO_PK                          ENABLED

SQL> select index_name,status from user_indexes where table_name = 'T';

INDEX_NAME                     STATUS
------------------------------ --------
T_IND                          VALID

SQL> rename t to newname_tt;

Table renamed.

SQL> select constraint_name,status from user_constraints where table_name = 'NEW
NAME_TT';

CONSTRAINT_NAME                STATUS
------------------------------ --------
NO_PK                          ENABLED

SQL> select index_name,status from user_indexes where table_name = 'NEWNAME_TT';


INDEX_NAME                     STATUS
------------------------------ --------
T_IND                          VALID

SQL>
SQL> select constraint_name,status from user_constraints where table_name = 'T';


no rows selected

SQL> select index_name,status from user_indexes where table_name = 'T';

no rows selected