huier_1234的博客

SYS DATA_PUMP_DIR默认目录C:\app\Administrator\admin\orcl\dpdump\SCHEMAS为数据库对象//导出expdp system/密码 DIRECTORY=DATA_PUMP_DIR DUMPFILE=**.dmp SCHEMAS=** logfile=expdp.log//导入impdp system/密码 @orcl directory=DATA_PUMP_DIR dumpfile=**.dmp SCHEMAS=** logfile=.

进入cmdsqlplus / as sysdbaSHOW PARAMETER LOCAL_LISTENER;ALTER SYSTEM SET LOCAL_LISTENER=’(ADDRESS=(PROTOCOL=TCP)(HOST=新IP地址)(PORT=1521))’;LSNRCTL START