1.启动数据库(ORACLE 9i):
>sqlplus /nolog
>connect /as sysdba
>startup
>quit
>lsnrctl
>start
quit
2.关闭数据库(ORACLE 9i ):
前提是用户连接已经关闭
>sqlplus /nolog
>connect sys/passwd as sysdba
>shutdown immediate
3、 字符串连接“||”
pl/sql:例如:update user set email = uid || ‘@test.net’ where uid = ‘1111’;
4.修改sysdba密码:
sqlplus /nolog
> conn as sysdba
>alter user sys identified by nosmoking
5.导出数据库文件:
> exp user/pwd@tnsname
导出文件:exp.dmp
…
6.导入数据库文件:
> imp
> user:user
> password:pwd
导入文件:exp.dmp
...
(将9i的数据库内容导入8i数据库中,可以通过8i的客户端机将9i的数据库文件导出?*.dmp,再将次dmp文件导入8i数据库中)
7、oracle中更改时间
update user t set t.birth=to_date('1965-1-1 0:0:0', 'yyyy-mm-dd hh24:mi:ss') where 1=1;