Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

End of ilne in spool

happy10319Feb 28 2019 — edited Mar 1 2019

Hi,

On 12c on linux

I spool a query, and out put is:

ALTER PROFILE XXXXUSER LIMIT FAILED_LOGIN_ATTEMPTS 5 PASSWORD_LIFE_TIME 90 P

ASSWORD_REUSE_TIME 360 PASSWORD_REUSE_MAX 4 PASSWORD_VERIFY_FUNCTION VERIFY_FUNC

TION PASSWORD_LOCK_TIME 1 PASSWORD_GRACE_TIME 15;

And it can not be executed:

ALTER PROFILE XXXXUSER LIMIT FAILED_LOGIN_ATTEMPTS 5 PASSWORD_LIFE_TIME 90 P

                                                                                                                                                     *

ERROR at line 1:

ORA-02376: invalid or redundant resource

What to do  and how to spool it well?

Thank you.

This post has been answered by Frank Kulash on Feb 28 2019
Jump to Answer
Comments
Post Details
Added on Feb 28 2019
6 comments
148 views