- 论坛徽章:
- 0
|
我试了半天也没有试出来
solaris 8
awk \'BEGIN { prev_tbs = \"\" # no tablespace processed yet
home = ENVIRON[\"ORACLE_HOME\"] # get ORACLE home directory
sid = ENVIRON[\"ORACLE_SID\"] # get ORACLE instance name
}
{ tablespace = substr($0, 1, 32) # extract tablespace and file
filename = substr($0, 33, 259) # name from SQL*Plus output
sub(/ +$/, \"\", tablespace) # remove trailing spaces
sub(/ +$/, \"\", filename) # remove trailing spaces
\"basename \" filename | getline base[/COLOR]
\"dirname \" filename | getline dir [/COLOR]
...
...
.....} test1.txt |
|