摘要:
> https://www.cnblogs.com/jay-xu33/p/5210098.html 查看服务器端字符集 修改字符集 来源: https://www.2cto.com/database/201412/361245.html <wiz_tmp_tag id="wiz-table-rang 阅读全文
摘要:
代码示例 #!/bin/bash ############ Usage: sh imp.sh 264 or ./imp.sh 264 ################# #require a integer parameter to indicate n+1 days to n days befor 阅读全文
摘要:
#!/bin/bash #========Usage: sh exp.sh 264 Or ./exp.sh 264 import data from records in tables which was inserted in 265 to 264 days before sysdate ======# if (($# == 0));then echo '===========you n... 阅读全文
摘要:
备份数据库,并删除七天前的备份文件 export ORACLE_SID=bdyz export ORACLE_BASE=/u01/oracle11g_R2 export ORACLE_HOME=$ORACLE_BASE/11g export LD_LIBRARY_PATH=$ORACLE_HOME/lib export NLS_LANG="simplified chinese"_china.zh... 阅读全文
摘要:
将源端数据库导入目标端数据库中 export ORACLE_SID=orcl export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1 export LD_LIBRARY_PATH=$ORACLE_HOME/lib export PATH=$PATH:$ORACLE_... 阅读全文