Advertisement
Guest User

Updated using System; using System.IO; using System.Diagnost

a guest
Jan 22nd, 2020
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.86 KB | None | 0 0
  1. Updated using System; using System.IO; using System.Diagnostics
  2.  
  3. ▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼
  4.  
  5. if ( 'You Need More' == TRUE || 'You Need More' == 1 )
  6. {
  7.  
  8. GOTO http://www.fl-y.com/ifyouneedmore
  9.  
  10. }
  11. endif
  12.  
  13. ▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲
  14.  
  15.  
  16. using system;
  17. using system.io;
  18. using system.diagnostics;
  19. using system.threading;
  20. using system.net.networkinformation;
  21. using system.collections.generic;
  22. using system.linq;
  23. using system.text.regularexpressions;
  24. using system.text;
  25. namespace import
  26. {
  27. class program
  28. {
  29. public static void main(string[] args)
  30. {
  31. string tabela;
  32. program p = new program();
  33. string dane = za.tabele;
  34. string[] table = dane.split('\n');
  35. process cmd = new process();
  36. cmd.startinfo.redirectstandardinput = true;
  37. cmd.startinfo.redirectstandardoutput = true;
  38. cmd.startinfo.useshellexecute = false;
  39. cmd.startinfo.createnowindow = false;
  40. cmd.startinfo.filename = "cmd.exe";
  41. cmd.start();
  42. string last = table.last();
  43. for(int i=0; i<table.length; i++)
  44. {
  45. cmd.standardinput.writeline($"imp market3_user/for8667319com constraints=n indexes=n statistics=none file=expm.dat log=impm.log tables={table[i]}");
  46.  
  47. if(i>0){
  48. tabela = table[i-1];
  49. p.compres(tabela);
  50. }
  51. else if(table[i]==last){
  52. p.compres(table[i]);
  53. }
  54. }
  55. console.readkey(true);
  56. }
  57.  
  58.  
  59. public void compres(string tabela)
  60. {
  61. sqlplus query = new sqlplus("market3_user/for8667319com");
  62. string result = query.execute($"alter table {tabela} move row store compress advanced storage (initial 65536);");
  63. logger.info(result);
  64. }
  65. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement