Oracle Manual

oracle manual

exp
exp user/password owner=user file=/data/**.dump

exp user/password owner=user statistics=none file=/data/**.dump

imp
imp user/password fromuser=user touser=user file=/data/**.dump
imp user/password fromuser=user touser=user file=/data/**.dump

impdp
CONN sys/password@db10g AS SYSDBA
GRANT CREATE ANY DIRECTORY TO dba;

CREATE DIRECTORY test_dir AS '/data/backup/';
GRANT READ, WRITE ON DIRECTORY test_dir TO dba;

impdp dba/dba@STRING schemas=dba REMAP_TABLESPACE=***_DATA:USERS directory=test_dir dumpfile=***.dmp logfile=test.log

 

start oracle10g
sqlplus
sys as sysdba
passwd
startup

shutdown oracle10g
sqlplus
sys as sysdba
passwd
SHUTDOWN immediate

kill ORA-00020 issue
show parameter processes
select count(*) from v$process
alter system set processes=300 scope=spfile

listener是否启动
$ lsnrctl service

启动关闭listener
$ lsnrctl start
$ lsnrctl stop

 

字符集
　　* 源数据库字符集；
　　* Export过程中用户会话字符集；
　　* Import过程中用户会话字符集；
　　* 目标数据库字符集。

检查数据库字符集:
　　通过InitXXXX.ora文件进行查看；
　　借助SQL语句查看： SELECT NAME,VALUE$ FROM SYS.PROPS$ WHERE NAME='NLS_CHARACTERSET';

Export、Import用户会话字符集
在Windows系统中可以通过注册表中的NLS_LANG进行查看或修改，
对于Unix系统则可通过设置用户的环境变量NLS_LANG来查看或修改。

删除表空间，数据文件
DROP TABLESPACE <tablespace name> INCLUDING CONTENTS
ALTER DATABASE DATAFILE <datafile name> OFFLINE DROP

web console
emctl start dbconsole
emctl stop dbconsole
emctl status dbconsole

create user
create tablespace NAME datafile '/data/app/oracle/product/10.2.0/oradata/**.dbf' size 100m autoextend on next 50m maxsize unlimited;
create user NAME identified by PASSWORD default tablespace NAME temporary tablespace temp;
grant connect,resource to NAME;