IMP 时的 ORA-01435 user does not exist 处理
在做IMP全导入 时,首先创建好表空间(因为文件位置不同),导入时加上ignore=y 选项,原以为就能成功导入。结果最后报: "ALTER SESSION SET CURRENT_SCHEMA= "MATERIAL""IMP-00003: ORACLE error 1435 encounteredORA-01435: user does not existIMP-00000: Import terminated unsuccessfully从错误来看,是因为MATERIAL用户不存在,翻看日志,在前面找到:MP-00017: following statement failed with ORACLE error 959: "CREATE USER "MATERIAL" IDENTIFIED BY VALUES 'EBFAC36458941377' DEFAULT T
Statement Tracer For Oracle 与 SQL Monitor 的比较
Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan;
REDHAT X64 下ORACLE11GR2的安装
Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 st1:*{behavior:url(#ieooui) } /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.00