Pages

Exporting Data using MAXL Script


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:

© 2010 Datawarehousing Support | Home | Disclaimer | Privacy Policy