Tags: user
Aug
07
1.EXPORT:
exp system@test owner=test123 file=d:\oracle\user.dmp log=d:\oracle\userdump.log
rows=y statistics=none feedback=100 indexes=y consistent=y compress=n;
(for individual tables=table1,table2,.....)
2.IMPORT:
imp system@test fromu… more »
Aug
06
create user [username] identified by [password] default tablespace
[tablespace name which has free space acc to statement 8] quota unlimited on [same tablespace name]; more »
Jul
16
Lock user ID :
# passwd -l username
Unlock user ID :
# passwd -u username
Change password:
# passwd username more »
Jul
16
Unlock the locked HP-UX user account:
# /usr/lbin/modprpw –l –k username
NOTE: modprpw is HP-UX command and it will not work in Solaris, AIX and Linux. more »
Jul
16
Lock user ID :
# passwd -l username
Unlock user ID :
# passwd -d username
Unlock user ID and force user to enter new password :
# passwd -df username
Note: This will unlock the user id, and force the user to enter a new password… more »
XML Feeds
Recent comments