- 启动企业管理器
root下
>xhost +
>su - oracle
>oemapp dbastudio
- 关闭侦听情况下导入导出数据
>su - oracle
$lsnrctl stop #防止外部服务器连上来
$sqlplus '/as sysdba'
>shutdown immediate #去除session保证能drop user
>startup
>drop user xxx cascade;
>create user .....
$imp xxx/xxx .... #导入数据,若以sysdba登陆为 imp /'sys/ppp as sysdba/' .... ppp为何值好像都行
$lsnrctl start
$exit
>
- oracle9i参考书
http://download.oracle.com/docs/cd/B10501_01/nav/docindex.htm