一、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;