11 2022 档案
摘要：今天从Windows 上把一个1TB的数据库导入到linux oracle 11g中，频繁出现如下的APEX报错： Fri Nov 18 15:43:41 2022Errors in file /u01/app/oracle/diag/rdbms/dagl/dagl/trace/dagl_j000_
阅读全文
摘要：/lib64/libstdc++.so.6: version `CXXABI_1.3.8' not found (required by ./7zz)/lib64/libstdc++.so.6: version `CXXABI_1.3.9' not found (required by ./7zz)
阅读全文
摘要：#!/bin/bashexport PATH=/usr/bin:/usr/sbin:/bin:/sbinftp -v -n 61.144.25.84 19990 <<EOFuser ftpuser02 uf*binarycd db prompt off get EXPDP_FULL20221104.
阅读全文
摘要：cat /etc/fstab ## /etc/fstab# Created by anaconda on Fri Nov 4 17:13:46 2022## Accessible filesystems, by reference, are maintained under '/dev/disk'#
阅读全文
摘要：客户端 NLS_LANG 的设置方法Windows:# 常用中文字符集set NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK# 常用unicode字符集set NLS_LANG=american_america.AL32UTF8可以通过修改注册表键值永久设置HK
阅读全文
摘要：select group#, sequence#, members, bytes, status, archived from v$log;select group#, status, type, member from v$logfile;添加redo组alter database add log
阅读全文
摘要：脚本内容：cat /opt/oracle/datadmp/expdp_adam.sh#!/bin/sh. /home/oracle/.bash_profilecd /opt/oracle/datadmp/find ./ -name "*.dmp" -mtime +3 -exec rm {} \;fi
阅读全文
摘要：Microsoft Windows [版本 6.1.7601]版权所有 (c) 2009 Microsoft Corporation。保留所有权利。 C:\Users\Administrator>expdp \"/ as sysdba\" attach=SYS_EXPORT_FULL_02 Expo
阅读全文
摘要：查看Oracle字符集： SQL> select * from nls_database_parameters; PARAMETER VALUE NLS_LANGUAGE AMERICANNLS_TERRITORY AMERICANLS_CURRENCY $NLS_ISO_CURRENCY AMER
阅读全文
