Oracle - 文章分类 - JDE

ORACLE EXP/IMP

摘要：EXP的所有参数（括号中为参数的默认值）：USERID 用户名/口令如： USERID=duanl/duanl FULL 导出整个数据库 (N)BUFFER 数据缓冲区的大小 OWNER 所有者用户名列表,你希望导出哪个用户的对象，就用owner=usernameFILE 输出文件 (EXPDAT 阅读全文

posted @ 2016-09-05 20:14 JDE 阅读(218) 评论(0) 推荐(0)

Oracle Weblogic的端口设置

摘要：首先是7001。它是域的控制台(Administration Console)的端口。修改方法：定位到到WEBLOGIC_HOME/user_projects/domains/domain/config/config.xml这个文件，在AdminServer下面增加一行如7003。然后运行WEBLO... 阅读全文

posted @ 2015-04-26 16:59 JDE 阅读(862) 评论(0) 推荐(0)

Oracle改主机名后OEM无法使用

摘要：Oracle安装好后hostname是不能乱改的HowtochangetheHostnameoftheWindowswhenthe Oracle 10/11G withASMbeingusedSolutionWhenchangingtheHostname,4fileswouldbeaffected.... 阅读全文

posted @ 2014-11-18 09:32 JDE 阅读(339) 评论(0) 推荐(0)

How to Reset Expired Passwords in E1Local OEE 11g Database

摘要：If the E1local database password has expired, you can reset the password using SQL.First, edit the sqlnet.ora file from the E1Local installation so that NTS authentication is used (back this file up or remember the original settings):SQLNET.AUTHENTICATION_SERVICES=(NTS)Then restart the E1Local DB se 阅读全文

posted @ 2013-12-10 14:47 JDE 阅读(462) 评论(0) 推荐(0)

Updating Oracle Database Statistics

摘要：Should update database statistics after loading a significant amount of data to the database. Without this step, the database will not use any of the indexes whtn accessing the data. Depending on the size of your tables, updating statistics may take a while.To update Oracle database statistics:1. St 阅读全文

posted @ 2013-08-22 17:17 JDE 阅读(255) 评论(0) 推荐(0)

文章分类 - Oracle