Confirmation of SQL statement disappeared

oracleoracle-12csqlplus

Until today after every SQL statement eg. CREATE user t identified by t; I had a confirmation of the execution "User created." Now I have nothing (no confirmation) but if I check if the user exists it is positive:

select username from all_users where username='T';

USERNAME
--------
T

How to turn it on again?

Best Answer

If the feedback on SQL*Plus is set to off then you don't get the confirmation messages. 

SQL> set feedback off
SQL> create user c##u1 identified by user1;

set feedback on.

SQL> set feedback on
SQL> drop user c##u1;

User dropped.

SQL> create user c##u1 identified by user1;

User created.

Documentation: SET FEEDBACK

Related Question