In real time export all data is not recommended.Export Level0
data is recommended, because calculation takes less time than export.
Script to export data
******************************************************************
spool on to 'C:\\BATCH\Prodlog.lpg';
login 'admin' 'password' on 'sales';
//alter database 'sales2'.'sales2' begin archive to file 'C;\\batch\arch1.txt';
Export database 'sales2'.'sales2' level0 data to data_file 'C:\\batch\exp.txt';
//alter database 'sales2'.'sales2' end archive;
logout;
exit;
******************************************************************
0 comments:
Post a Comment