기미차니
2022. 6. 7. 16:13
반응형
Oracle expdp 수행시 참고 (대표적인 옵션)
-. 작업 상황에 따라서 옵션 변경
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
create directory exp_dump as '/export';
expdp \'/as sysdba\' directory=exp_dump parfile=exp_full.par
-- exp_test.par
dumpfile = exp_test.dmp
logfile = exp_test.dmp.log
schemas = [schema]
tables = [schema].[table_name]
exclude = table_statistics, index_statistics
query = "where DAY < '20210101'"
parallel = 16
cluster = n
full = y
|
cs |
반응형