create user userName identified by password; 
			

指定表空间

create user neo identified by 123456 default tablespace netkiller;
			

drop user userName cascade; 
			

cascade 删除用户同时删除该用户所创建的对象。

alter user neo default tablespace neo;			
			

输入 sqlplus /nolog 回车

$ sqlplus /nolog

SQL> conn /as sysdba

SQL> alter user system identified by "123456";
SQL> alter user sys identified by "123456";
SQL> alter user FINANCE identified by "123123" account unlock;

User altered.
			

account unlock 解锁账号

alter user backup identified by "passw0rd" account unlock;			
			

密码文件 orapwORACLE_SID 这里的SID是orcl，所以密码文件是 orapworcl

orapwd file=$ORACLE_HOME/dbs/orapworcl password=newpass