Warning: You are no longer connected to ORACLE. ORA-01017: invalid username/password logon denied Yes! With no SYS users works fine to me too. Just a suggestion that helped get the correct output length. Since this returns output as a CLOB, one thing I had to change to get the correct output was to either increase the 'long' SQL*Plus parameter (I set it to 300), or put a TO_CHAR in front of the 'dbms_metadata.get_ddl' function:Ģ ( select (dbms_metadata.get_ddl('USER','SCOTT')) ddl from dual )ģ select replace(substr(ddl,1,instr(ddl,'DEFAULT')-1),'CREATE','ALTER')||' ' ![]() ![]() Thank you for the tip, this is great, especially with the password hash changes in Oracle 12c.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |