Quote:
Originally Posted by SQL ORACLE
If we have to drop the password first, what attention do we need to pay?
Many thanks in advance
|
To which password file are you referring to?
If it's the one under ORACLE_HOME/dbs, then:
Code:
==> orapwd -h
Usage: orapwd file=<fname> password=<password> entries=<users> force=<y/n> nosysdba=<y/n>
where
file - name of password file (mand),
password - password for SYS (mand),
entries - maximum number of distinct DBA,
force - whether to overwrite existing file (opt),
nosysdba - whether to shut out the SYSDBA logon (opt for Database Vault only).
There are no spaces around the equal-to (=) character.
Otherwise if you refer to the password (user) table in the database, just increase the space allocated to the system tablespace.
dBforums
>
How to increase the number of entries in password file?
12-15-11, 11:41
Linear Mode
