摘要：
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 阅读全文
摘要：
[oracle@dbtest backup]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Thu May 5 13:58:39 2022 Copyright (c) 1982, 2013, Oracle. All r 阅读全文
摘要：
1、查找特定表大小 select round(BYTES/1024/1024,2)||'M' from Dba_Segments where segment_name=upper('表名')； 2、查找数据库中占用空间较大的对象 SELECT OWNER,SEGMENT_NAME,SUM(bytes 阅读全文
摘要：
[oracle@oracle-pd ~]$ sqlplus "/ as sysdba" SQL*Plus: Release 12.2.0.1.0 Production on Tue Aug 10 17:15:59 2021 Copyright (c) 1982, 2016, Oracle. All 阅读全文
摘要：
挂载光盘 #mout /dev/sr0 /mnt/cdrom 修改yum源 [root@localhost nginx-1.20.1]# cat /etc/yum.repos.d/rhel-source.repo [rhel-source]baseurl=file:///mnt/cdromenabl 阅读全文