Export
PL/SQL문 declare h1 NUMBER; begin begin h1 := dbms_datapump.open (operation => 'EXPORT', job_mode => 'FULL', job_name => 'MY_EXPORT', version => 'COMPATIBLE'); end; begin dbms_datapump.set_parallel(handle => h1, degree => 1); end; begin dbms_datapump.add_file(handle => h1, filename => 'EXPDAT.LOG', directory => 'exp', filetype => 3); end; begin dbms_datapump.set_parameter(handle => h1, name => 'K..
DataBase/Oracle
2010. 6. 7. 13:41