1. Constraints will not break when you rename tables.
2. You can back deleted datafiles but there is no guaranty that the object stored on the deleted datafile are available when it brought back
3. You can recover dropped tables by using FLASHBACK TABLE table_name TO BEFORE DROP;
4. Moving table to new tablespace will make all the indexes on the table unusable and prevent any DML activity on the table. Then you have to rebuild index.
2. You can back deleted datafiles but there is no guaranty that the object stored on the deleted datafile are available when it brought back
3. You can recover dropped tables by using FLASHBACK TABLE table_name TO BEFORE DROP;
4. Moving table to new tablespace will make all the indexes on the table unusable and prevent any DML activity on the table. Then you have to rebuild index.
