1
Exp
备份学习
Exp
简要介绍:
............................................................................................................. 3
命令基本格式为(命令行格式)
............................................................................. 3
一、数据库导出验证
..................................................................................................... 3
Userid
.
......................................................................................................................... 3
二、数据库导出方式
..................................................................................................... 4
Direct........................................................................................................................... 4
Query........................................................................................................................... 4
Buffer .......................................................................................................................... 4
Recordlength
............................................................................................................... 4
三、数据库导出范围
..................................................................................................... 6
Full .............................................................................................................................. 6
Tablespace
.
.................................................................................................................. 6
Tables .......................................................................................................................... 6
Owner
.
......................................................................................................................... 6
四、导出分类
................................................................................................................. 6
Rows ........................................................................................................................... 7
Indexex
.
....................................................................................................................... 7
Grants
.
......................................................................................................................... 7
Transport_tablespace .................................................................................................. 7
Constraints .................................................................................................................. 7
Triggers ....................................................................................................................... 7
五、导出时间及同步设定
............................................................................................. 7
Flashback_scn
............................................................................................................. 7
Flashback_time ........................................................................................................... 7
Consistent
.
................................................................................................................... 7
Object_consistent
.
....................................................................................................... 7
六、文件路径大小设定
................................................................................................. 7
File .............................................................................................................................. 8
Filesize ........................................................................................................................ 8
Compress..................................................................................................................... 8
Resumable
.
.................................................................................................................. 8
Resumable_name ........................................................................................................ 8
Resumable_time
.
......................................................................................................... 8
七、生成的辅助信息
..................................................................................................... 8
Log .............................................................................................................................. 8
Statistics ...................................................................................................................... 8
八、帮助和显示信息
..................................................................................................... 8
Feedback ..................................................................................................................... 8
Help
.
............................................................................................................................ 9
九、完整性和部分相关性检查
..................................................................................... 9
TTS_FULL_CHECK
.
................................................................................................. 9
十、命令存储参数文件设定
......................................................................................... 9
Parfile
.
......................................................................................................................... 9