Friday, April 5, 2013

Creating user with dbms_metadata.get_ddl


select dbms_metadata.get_ddl('USER',username) from dba_users where username in ('user_1',user_2',user_3','user_4')


user_1,user_2,user_3,user_4 should be defined by dba as real user names...

No comments:

Post a Comment