Oracle Manual
来源:互联网 发布:兰州知豆一个月多少钱 编辑:程序博客网 时间:2024/04/30 22:45
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;
- Oracle Manual
- Manual Oracle Uninstall
- Manual Create Oracle Database Instance
- manual
- 图解oracle BPM入门 asynchronous/Manual Process
- Oracle Data Integrator Driver for XML - User's Manual
- 【ORACLE】Oracle 11g RAC使用Manual和Policy Managed方法配置
- Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1) [ID 1503653.1]
- Oracle 11g RAC使用Manual和Policy Managed方法配置
- 10g Manual Database Creation in Oracle (Single Instance and RAC) (文档 ID 240052.1)
- gnu manual
- WinDump Manual
- Doxygen Manual
- OProfile manual
- Log4j Manual
- eWebEditor Manual
- Makefile manual
- makefile manual
- 制作超高容量视频光盘KVCDKDVD光盘制作全攻略2
- 解决在windows目录下的文件到ubuntu系统下出现的中文乱码问题
- 软件开发中的11个系统思维定律
- 火狐(Mozilla Firefox) 与 IE 空值的不同
- Cookie's expire age
- Oracle Manual
- 一个简单的多线程 pthread_detach
- __stdcall、__cdcel和__fastcall三者的区别
- 制作超高容量视频光盘KVCDKDVD光盘制作全攻略3
- Linux 下能代替 windows 的软件列表
- delphi中的register, pascal, cdecl, stdcall, safecall
- 制作超高容量视频光盘KVCDKDVD光盘制作全攻略4
- Ant 基础介绍 以及功能介绍
- mac10.6.3上装xcode3.2.5