Friday, 15 June 2012

ORACLE FILE ZIP


zip
===
SQL> HO ZIP


SQL> SET TERM ON;
SQL> PRO generating zip file...
SQL> HO zip -mT PFILE INITorcl6.ORA    // SQL> HO zip -mT <zip_name> <filesname>.<extention of file>
SQL> PRO PFILE.zip has been generated
SQL> PRO

SQL> HO zip  e:\Pfile INIT*.ORA  //zip location d drive file to e:\ drive into pfile directory
SQL> HO zip e:\pfile D:\try\try2Online_logfile\INIT*.ORA    //

unzip
======
SQL> HO UNZIP

SQL> HO unzip -o pfile.zip  // extract here same location
SQL> HO unzip -d e:\pfile -o D:\Pfile     //unzipfile
OR
SQL> HO unzip e:\pfile -d D:\Pfile     //unzipfile pfile e drive to D drive


NOT MORE THAN ,M NOT SURE 1GB FILE......?

No comments: