一、aix系统下启动、停止数据库

1、启动数据库
oracle@aix5:~> sqlplus /nolog
?
SQL*Plus: Release 9.2.0.4.0 - Production on Fri Jan 20 12:29:37?2011?
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
?
SQL> connect /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE 例程已经启动.
Total System Global Area 4932501504 bytes
Fixed Size????????????????? 2027584 bytes
Variable Size???????????? 687869888 bytes
Database Buffers???????? 4227858432 bytes
Redo Buffers?????????????? 14745600 bytes
数据库装载完毕。
数据库已经打开。

?2、启动监听器
oracle@aix5:~> lsnrctl start
3、停止监听器
oracle@aix5:~> lsnrctl stop
4、查看监听器状态
　　oracle@aix5:~> lsnrctl
　　LSNRCTL> status
　　LSNRCTL> exit
?
5、停止数据库：
oracle@aix5:~> sqlplus /nolog
?
SQL*Plus: Release 9.2.0.4.0 - Production on Fri Jan 20 02:29:37 2006
?
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect /as sysdba
Connected to an idle instance.
SQL> shutdwon abort;--立即停止

?

?

二、去掉oracle列中的空格
1、update tab_name set col_a = replace(col_a,' ','');
2、update tab_name set col_a=trim(col_a);

?

三、导出dmp文件，新增用户

1.导出DMP文件：
exp testuser/testuser@zjjdvg1? file='/bkdata/testuser_bak/testuserMMDD.dmp' full=y rows=y;

2.?新建testuser_bak用户
?-- Create the user
create user testuser_bak
? identified by "testuser_bak"
? default tablespace TBS_test
? temporary tablespace TBS_TEMP
? profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to testuser_bak;
grant resource to testuser_bak;
-- Grant/Revoke system privileges
grant alter any index to testuser_bak;
grant alter any table to testuser_bak;
grant create any index to testuser_bak;
grant create any view to testuser_bak;
grant create any sequence to testuser_bak;
grant create any table to testuser_bak;
grant select any sequence to testuser_bak;
grant select any table to testuser_bak;
grant select any dictionary to testuser_bak;
grant execute any procedure to testuser_bak;
grant unlimited tablespace to testuser_bak;

?

?