APPLIES TO:Oracle Database - Enterprise Edition - Version 10.2.0.3 to 11.1.0.6 [Release 10.2 to 11.1]Information in this document applies to any platform.***Checked for relevance on 28-MAR-2013***SYMPTOMSA DataPump import using the parameter REMAP_SCHE...【阅读全文】
OS:Red Hat Linux As 5DB:10.2.0.5.6 今天使用export手工备份ocr,执行如下命令的时候发现命令一直在执行,感觉是hang住了,按理说导出ocr是很快完成的,怎么感觉一直无法完成呢.[root@node1 ocrbak]#/u01/app/oracle/product/10.2.0/crs_1/bin/ocrconfig -export /u01/app/oracle/ocr_export140210.bak注意$ORACL...【阅读全文】
Create directory让我们可以在Oracle数据库中灵活的对文件进行读写操作,极大的提高了Oracle的易用性和可扩展性。其语法为:CREATE [OR REPLACE] DIRECTORY directory AS 'pathname';本案例具体创建如下: create or replace directory exp_dir as '/tmp';目录创建以后,就...【阅读全文】
]创建2个用户,依次授予对象权限,然后收回权限grant connect to scott;grant create session to scott (基本权限)create user test identified by test;create user hp identified by hp;conn scott/tigergrant select on emp to test with grant o...【阅读全文】