| 失效链接处理 |
|
oracle 11.2.0.4常用操作说明?PDF 下蝲
本站整理下蝲Q?/strong>
链接Q?a target="_blank">https://pan.baidu.com/s/1cUBWXEntLzeEyyUzN6krDw
提取码：(x)vw6m
相关截图Q?/strong>
主要内容Q?/strong>
1.日常q维c?/div>
1.1备䆾 Backup Qexp&impQ?/div>
1.1.1 exp导出备䆾
[说明]
备䆾重于一切！备䆾重于一切！备䆾重于一切！
[适用范围]
Oracle单机和RAC
[SQL语句]
[windows客户端]
按用户导出：(x)exp test/test@test file=d:\daochu.dmp log=d:\daochu.log owner=user1,user2
[Linux服务器上exp导出]
按用户导出：(x)exp test/test file=/home/oracle/daochu.dmp log=/home/oracle/daochu.log owner=user1,use2
1.1.2 imp导入
[说明]
若现在已l有一份成功导出的dmp备䆾文gQ需要恢复或者迁UL据，往往使用imp命o(h)导入
[适用范围]
Oracle单机和RAC
[SQL语句]
[windows客户端]
导入单张表：(x)imp test/test@test file=d:\daoru.dmp log=d:\daoru.log tables=(test)
A用户的导出文Ӟ需要导入用户BQ?/div>
imp userB/userB file=d:\daoru.dmp log=d:\daoru.log fromuser=userA touser=userB
[Linux服务器上imp 导入]
1、dmp文g上传?u01目录?例如test.dmp)
2、用root用户sshdL
cd /u01
chown oracle:oinstall test.dmp
chmod 775 test.dmp
3、环境变量设|?/div>
su - oracle
export LANG=ZH_CN.GB18030 (可以避免导入后，字段注释和表注释q)
4、导?/div>
imp test/test file=/u01/test.dmp log=/home/oracle/test.log full=Y
5、查看日?/div>
下蝲/home/oracle/test.logQ观察导入是否成功?/div>
1.2表空?Tablespace
1.2.1表空间用率查询SQL
[说明]
表空间分c：(x)pȝ表空_(d)SYSTEMQSYSAUXQUNDOQTEMPQUSERQ?业务表空_(d)譬如QZF表空_(d)(j)
[适用范围]
Oracle单机和RAC
[SQL语句]
SELECT DF.TABLESPACE_NAME,
COUNT(*) DATAFILE_COUNT,
ROUND(SUM(DF.BYTES) / 1048576 / 1024, 2) SIZE_GB,
ROUND(SUM(FREE.BYTES) / 1048576 / 1024, 2) FREE_GB,
ROUND(SUM(DF.BYTES) / 1048576 / 1024 -
SUM(FREE.BYTES) / 1048576 / 1024,
2) USED_GB,
ROUND(MAX(FREE.MAXBYTES) / 1048576 / 1024, 2) MAXFREE,
100 - ROUND(100.0 * SUM(FREE.BYTES) / SUM(DF.BYTES), 2) PCT_USED,
ROUND(100.0 * SUM(FREE.BYTES) / SUM(DF.BYTES), 2) PCT_FREE
FROM DBA_DATA_FILES DF,
(SELECT TABLESPACE_NAME,
FILE_ID,
SUM(BYTES) BYTES,
MAX(BYTES) MAXBYTES
FROM DBA_FREE_SPACE
WHERE BYTES > 1024 * 1024
GROUP BY TABLESPACE_NAME, FILE_ID) FREE
WHERE DF.TABLESPACE_NAME = FREE.TABLESPACE_NAME(+)
AND DF.FILE_ID = FREE.FILE_ID(+)
GROUP BY DF.TABLESPACE_NAME
ORDER BY 8;
|
| Java1234官方?5Q?/td> | 
|
| Java1234官方?5Q?/td> | 838462530 |
苏公|安?32061202001004?/p>
