Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Updated using System; using System.IO; using System.Diagnostics
- ▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼▼
- if ( 'You Need More' == TRUE || 'You Need More' == 1 )
- {
- GOTO http://www.fl-y.com/ifyouneedmore
- }
- endif
- ▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲▲
- using system;
- using system.io;
- using system.diagnostics;
- using system.threading;
- using system.net.networkinformation;
- using system.collections.generic;
- using system.linq;
- using system.text.regularexpressions;
- using system.text;
- namespace import
- {
- class program
- {
- public static void main(string[] args)
- {
- string tabela;
- program p = new program();
- string dane = za.tabele;
- string[] table = dane.split('\n');
- process cmd = new process();
- cmd.startinfo.redirectstandardinput = true;
- cmd.startinfo.redirectstandardoutput = true;
- cmd.startinfo.useshellexecute = false;
- cmd.startinfo.createnowindow = false;
- cmd.startinfo.filename = "cmd.exe";
- cmd.start();
- string last = table.last();
- for(int i=0; i<table.length; i++)
- {
- cmd.standardinput.writeline($"imp market3_user/for8667319com constraints=n indexes=n statistics=none file=expm.dat log=impm.log tables={table[i]}");
- if(i>0){
- tabela = table[i-1];
- p.compres(tabela);
- }
- else if(table[i]==last){
- p.compres(table[i]);
- }
- }
- console.readkey(true);
- }
- public void compres(string tabela)
- {
- sqlplus query = new sqlplus("market3_user/for8667319com");
- string result = query.execute($"alter table {tabela} move row store compress advanced storage (initial 65536);");
- logger.info(result);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement