Today (Saturday) We will make some minor tuning adjustments to MySQL.

You may experience 2 up to 10 seconds "glitch time" when we restart MySQL. We expect to make these adjustments around 1AM Eastern Daylight Saving Time (EDT) US.


Is this sort working as it is supposed to be? A bit confused whether it is sorting correctly or not


Login or Register to Reply

 
Thread Tools Search this Thread
# 1  
Is this sort working as it is supposed to be? A bit confused whether it is sorting correctly or not

Hi,

Below is the sample file:

Code:
$ cat x.txt
MDSYS|OGIS_GEOMETRY_COLUMNS|TABLE
MDSYS|OGIS_SPATIAL_REFERENCE_SYSTEMS|TABLE
MDSYS|SDO_IDX_TAB_SEQUENCE|SEQUENCE
MDSYS|SDO_PREFERRED_OPS_USER|TABLE
MDSYS|SDO_ST_TOLERANCE|TABLE
MDSYS|SDO_TOPO_DATA$|TABLE
MDSYS|SDO_TOPO_RELATION_DATA|TABLE
MDSYS|SDO_TOPO_TRANSACT_DATA$|VIEW
MDSYS|SDO_TXN_IDX_DELETES|TABLE
MDSYS|SDO_TXN_IDX_EXP_UPD_RGN|TABLE
MDSYS|SDO_TXN_IDX_INSERTS|TABLE
MDSYS|SRSNAMESPACE_TABLE|TABLE
MDSYS|USER_ANNOTATION_TEXT_METADATA|VIEW
MDSYS|USER_SDO_3DTHEMES|VIEW
MDSYS|USER_SDO_3DTXFMS|VIEW
MDSYS|USER_SDO_ANIMATIONS|VIEW
MDSYS|USER_SDO_CACHED_MAPS|VIEW
MDSYS|USER_SDO_GEOM_METADATA|VIEW
MDSYS|USER_SDO_LIGHTSOURCES|VIEW
MDSYS|USER_SDO_LRS_METADATA|VIEW
MDSYS|USER_SDO_MAPS|VIEW
MDSYS|USER_SDO_SCENES|VIEW
MDSYS|USER_SDO_STYLES|VIEW
MDSYS|USER_SDO_THEMES|VIEW
MDSYS|USER_SDO_VIEWFRAMES|VIEW
ORDDATA|ORDDCM_CONFORMANCE_VLD_MSGS|VIEW
OUTLN|OL$HINTS|TABLE
OUTLN|OL$NODES|TABLE
OUTLN|OL$|TABLE
SYS|DATA_PUMP_XPL_TABLE$|TABLE
SYS|IMPDP_STATS|INDEX
SYS|IMPDP_STATS|TABLE
SYS|KU$_DATAPUMP_MASTER_10_1|TABLE
SYS|KU$_DATAPUMP_MASTER_11_1_0_7|TABLE
SYS|KU$_DATAPUMP_MASTER_11_1|TABLE
SYS|KU$_DATAPUMP_MASTER_11_2|TABLE
SYS|KU$_LIST_FILTER_TEMP_2|TABLE
SYS|KU$_LIST_FILTER_TEMP|TABLE
SYS|KU$NOEXP_TAB|TABLE
SYS|KU$XKTFBUE|TABLE
SYS|ODCI_SECOBJ$|TABLE
SYS|ODCI_WARNINGS$|TABLE
SYS|PLAN_TABLE$|TABLE
SYS|PSTUBTBL|TABLE
SYSTEM|OL$HINTS|TABLE
SYSTEM|OL$NODES|TABLE
SYSTEM|OL$|TABLE
SYS|WRI$_ADV_ASA_RECO_DATA|TABLE
XDB|PATH_VIEW|VIEW
XDB|RESOURCE_VIEW|VIEW
XDB|XDB$ACL|TABLE
XDB|XDB$IMPORT_TT_INFO|TABLE
XDB|XDB$RESCONFIG|TABLE
XDB|XDB$XIDX_IMP_T|TABLE

Simply doing sort

Code:
$ sort x.txt
MDSYS|OGIS_GEOMETRY_COLUMNS|TABLE
MDSYS|OGIS_SPATIAL_REFERENCE_SYSTEMS|TABLE
MDSYS|SDO_IDX_TAB_SEQUENCE|SEQUENCE
MDSYS|SDO_PREFERRED_OPS_USER|TABLE
MDSYS|SDO_ST_TOLERANCE|TABLE
MDSYS|SDO_TOPO_DATA$|TABLE
MDSYS|SDO_TOPO_RELATION_DATA|TABLE
MDSYS|SDO_TOPO_TRANSACT_DATA$|VIEW
MDSYS|SDO_TXN_IDX_DELETES|TABLE
MDSYS|SDO_TXN_IDX_EXP_UPD_RGN|TABLE
MDSYS|SDO_TXN_IDX_INSERTS|TABLE
MDSYS|SRSNAMESPACE_TABLE|TABLE
MDSYS|USER_ANNOTATION_TEXT_METADATA|VIEW
MDSYS|USER_SDO_3DTHEMES|VIEW
MDSYS|USER_SDO_3DTXFMS|VIEW
MDSYS|USER_SDO_ANIMATIONS|VIEW
MDSYS|USER_SDO_CACHED_MAPS|VIEW
MDSYS|USER_SDO_GEOM_METADATA|VIEW
MDSYS|USER_SDO_LIGHTSOURCES|VIEW
MDSYS|USER_SDO_LRS_METADATA|VIEW
MDSYS|USER_SDO_MAPS|VIEW
MDSYS|USER_SDO_SCENES|VIEW
MDSYS|USER_SDO_STYLES|VIEW
MDSYS|USER_SDO_THEMES|VIEW
MDSYS|USER_SDO_VIEWFRAMES|VIEW
ORDDATA|ORDDCM_CONFORMANCE_VLD_MSGS|VIEW
OUTLN|OL$HINTS|TABLE
OUTLN|OL$NODES|TABLE
OUTLN|OL$|TABLE
SYS|DATA_PUMP_XPL_TABLE$|TABLE
SYS|IMPDP_STATS|INDEX
SYS|IMPDP_STATS|TABLE
SYS|KU$_DATAPUMP_MASTER_10_1|TABLE
SYS|KU$_DATAPUMP_MASTER_11_1_0_7|TABLE
SYS|KU$_DATAPUMP_MASTER_11_1|TABLE
SYS|KU$_DATAPUMP_MASTER_11_2|TABLE
SYS|KU$_LIST_FILTER_TEMP_2|TABLE
SYS|KU$_LIST_FILTER_TEMP|TABLE
SYS|KU$NOEXP_TAB|TABLE
SYS|KU$XKTFBUE|TABLE
SYS|ODCI_SECOBJ$|TABLE
SYS|ODCI_WARNINGS$|TABLE
SYS|PLAN_TABLE$|TABLE
SYS|PSTUBTBL|TABLE
SYSTEM|OL$HINTS|TABLE
SYSTEM|OL$NODES|TABLE
SYSTEM|OL$|TABLE
SYS|WRI$_ADV_ASA_RECO_DATA|TABLE
XDB|PATH_VIEW|VIEW
XDB|RESOURCE_VIEW|VIEW
XDB|XDB$ACL|TABLE
XDB|XDB$IMPORT_TT_INFO|TABLE
XDB|XDB$RESCONFIG|TABLE
XDB|XDB$XIDX_IMP_T|TABLE

I am expecting the one below:

Code:
SYS|PLAN_TABLE$|TABLE
SYS|PSTUBTBL|TABLE
SYSTEM|OL$HINTS|TABLE
SYSTEM|OL$NODES|TABLE
SYSTEM|OL$|TABLE
SYS|WRI$_ADV_ASA_RECO_DATA|TABLE

to be

Code:
SYS|PLAN_TABLE$|TABLE
SYS|PSTUBTBL|TABLE
SYS|WRI$_ADV_ASA_RECO_DATA|TABLE
SYSTEM|OL$HINTS|TABLE
SYSTEM|OL$NODES|TABLE
SYSTEM|OL$|TABLE

Shouldn't that be the case? Anyway, I thought maybe there is some special characters of some sort so I did a strings and it is still the same Smilie. What am I missing?

Code:
$ cat x.txt | strings > y.txt
$ sort y.txt
MDSYS|OGIS_GEOMETRY_COLUMNS|TABLE
MDSYS|OGIS_SPATIAL_REFERENCE_SYSTEMS|TABLE
MDSYS|SDO_IDX_TAB_SEQUENCE|SEQUENCE
MDSYS|SDO_PREFERRED_OPS_USER|TABLE
MDSYS|SDO_ST_TOLERANCE|TABLE
MDSYS|SDO_TOPO_DATA$|TABLE
MDSYS|SDO_TOPO_RELATION_DATA|TABLE
MDSYS|SDO_TOPO_TRANSACT_DATA$|VIEW
MDSYS|SDO_TXN_IDX_DELETES|TABLE
MDSYS|SDO_TXN_IDX_EXP_UPD_RGN|TABLE
MDSYS|SDO_TXN_IDX_INSERTS|TABLE
MDSYS|SRSNAMESPACE_TABLE|TABLE
MDSYS|USER_ANNOTATION_TEXT_METADATA|VIEW
MDSYS|USER_SDO_3DTHEMES|VIEW
MDSYS|USER_SDO_3DTXFMS|VIEW
MDSYS|USER_SDO_ANIMATIONS|VIEW
MDSYS|USER_SDO_CACHED_MAPS|VIEW
MDSYS|USER_SDO_GEOM_METADATA|VIEW
MDSYS|USER_SDO_LIGHTSOURCES|VIEW
MDSYS|USER_SDO_LRS_METADATA|VIEW
MDSYS|USER_SDO_MAPS|VIEW
MDSYS|USER_SDO_SCENES|VIEW
MDSYS|USER_SDO_STYLES|VIEW
MDSYS|USER_SDO_THEMES|VIEW
MDSYS|USER_SDO_VIEWFRAMES|VIEW
ORDDATA|ORDDCM_CONFORMANCE_VLD_MSGS|VIEW
OUTLN|OL$HINTS|TABLE
OUTLN|OL$NODES|TABLE
OUTLN|OL$|TABLE
SYS|DATA_PUMP_XPL_TABLE$|TABLE
SYS|IMPDP_STATS|INDEX
SYS|IMPDP_STATS|TABLE
SYS|KU$_DATAPUMP_MASTER_10_1|TABLE
SYS|KU$_DATAPUMP_MASTER_11_1_0_7|TABLE
SYS|KU$_DATAPUMP_MASTER_11_1|TABLE
SYS|KU$_DATAPUMP_MASTER_11_2|TABLE
SYS|KU$_LIST_FILTER_TEMP_2|TABLE
SYS|KU$_LIST_FILTER_TEMP|TABLE
SYS|KU$NOEXP_TAB|TABLE
SYS|KU$XKTFBUE|TABLE
SYS|ODCI_SECOBJ$|TABLE
SYS|ODCI_WARNINGS$|TABLE
SYS|PLAN_TABLE$|TABLE
SYS|PSTUBTBL|TABLE
SYSTEM|OL$HINTS|TABLE
SYSTEM|OL$NODES|TABLE
SYSTEM|OL$|TABLE
SYS|WRI$_ADV_ASA_RECO_DATA|TABLE
XDB|PATH_VIEW|VIEW
XDB|RESOURCE_VIEW|VIEW
XDB|XDB$ACL|TABLE
XDB|XDB$IMPORT_TT_INFO|TABLE
XDB|XDB$RESCONFIG|TABLE
XDB|XDB$XIDX_IMP_T|TABLE

I have also tried sort -t"|" -k1. It's the same problem. I am confused. BTW, I thought maybe 'coz I am using a pipe (|) as the delimiter. I change them to a comma (,) and it is still the same. Please advise.

Last edited by newbie_01; 2 Weeks Ago at 12:53 AM..
# 2  
I cannot duplicate your problem.
With sort, using a cut and paste copy of your example input, and using sort as the only command I get:

Code:
SYS|ODCI_WARNINGS$|TABLE
SYS|PLAN_TABLE$|TABLE
SYS|PSTUBTBL|TABLE
SYS|WRI$_ADV_ASA_RECO_DATA|TABLE
SYSTEM|OL$|TABLE
SYSTEM|OL$HINTS|TABLE
SYSTEM|OL$NODES|TABLE
XDB|PATH_VIEW|VIEW
XDB|RESOURCE_VIEW|VIEW
XDB|XDB$ACL|TABLE
XDB|XDB$IMPORT_TT_INFO|TABLE
XDB|XDB$RESCONFIG|TABLE
XDB|XDB$XIDX_IMP_T|TABLE

Which is the expected result.
1. please tell us your OS and shell
2. please post the output of
Code:
echo  '
SYS|PSTUBTBL|TABLE
SYS|WRI$_ADV_ASA_RECO_DATA|TABLE'  | od -c

I think there is a non-printing character in there somewhere. You can also use cat -v to see
# 3  
Your attempt to sort -t"|" -k1 is not enough, as (man sort)
Quote:
KEYDEF is F[.C][OPTS][,F[.C][OPTS]] for start and stop position, where F is a field number and C a character position in the field; both are origin 1, and the stop position defaults to the line's end.
, so -k1 is equivalent to no key at all. Try
Code:
sort -t"|" -k1,1  file

This User Gave Thanks to RudiC For This Post:
# 4  
@Jim

Not sure if this is what you are after. That is my first thought too, there is a special / hidden / unprintable character somewhere.

Please find below echo and the sort and OS flavor.

The one that RudiC suggested works find. I've also uploaded the test.txt file if you still want to give it a go.

Code:
$ echo 'SYS|PSTUBTBL|TABLE' | od -c
0000000   S   Y   S   |   P   S   T   U   B   T   B   L   |   T   A   B
0000020   L   E  \n
0000023
$ echo 'SYS|WRI$_ADV_ASA_RECO_DATA|TABLE' | od -c
0000000   S   Y   S   |   W   R   I   $   _   A   D   V   _   A   S   A
0000020   _   R   E   C   O   _   D   A   T   A   |   T   A   B   L   E
0000040  \n
0000041
$ view xx.txt
$ echo 'SYSTEM|OL$HINTS|TABLE' | od -c
0000000   S   Y   S   T   E   M   |   O   L   $   H   I   N   T   S   |
0000020   T   A   B   L   E  \n
0000026
$ echo 'SYSTEM|OL$NODES|TABLE' | od -c
0000000   S   Y   S   T   E   M   |   O   L   $   N   O   D   E   S   |
0000020   T   A   B   L   E  \n
0000026


$ sort -t"|" -k1,1 test.txt
MDSYS|OGIS_GEOMETRY_COLUMNS|TABLE
MDSYS|OGIS_SPATIAL_REFERENCE_SYSTEMS|TABLE
MDSYS|SDO_IDX_TAB_SEQUENCE|SEQUENCE
MDSYS|SDO_PREFERRED_OPS_USER|TABLE
MDSYS|SDO_ST_TOLERANCE|TABLE
MDSYS|SDO_TOPO_DATA$|TABLE
MDSYS|SDO_TOPO_RELATION_DATA|TABLE
MDSYS|SDO_TOPO_TRANSACT_DATA$|VIEW
MDSYS|SDO_TXN_IDX_DELETES|TABLE
MDSYS|SDO_TXN_IDX_EXP_UPD_RGN|TABLE
MDSYS|SDO_TXN_IDX_INSERTS|TABLE
MDSYS|SRSNAMESPACE_TABLE|TABLE
MDSYS|USER_ANNOTATION_TEXT_METADATA|VIEW
MDSYS|USER_SDO_3DTHEMES|VIEW
MDSYS|USER_SDO_3DTXFMS|VIEW
MDSYS|USER_SDO_ANIMATIONS|VIEW
MDSYS|USER_SDO_CACHED_MAPS|VIEW
MDSYS|USER_SDO_GEOM_METADATA|VIEW
MDSYS|USER_SDO_LIGHTSOURCES|VIEW
MDSYS|USER_SDO_LRS_METADATA|VIEW
MDSYS|USER_SDO_MAPS|VIEW
MDSYS|USER_SDO_SCENES|VIEW
MDSYS|USER_SDO_STYLES|VIEW
MDSYS|USER_SDO_THEMES|VIEW
MDSYS|USER_SDO_VIEWFRAMES|VIEW
ORDDATA|ORDDCM_CONFORMANCE_VLD_MSGS|VIEW
OUTLN|OL$HINTS|TABLE
OUTLN|OL$NODES|TABLE
SYS|DATA_PUMP_XPL_TABLE$|TABLE
SYS|IMPDP_STATS|INDEX
SYS|IMPDP_STATS|TABLE
SYS|KU$_DATAPUMP_MASTER_10_1|TABLE
SYS|KU$_DATAPUMP_MASTER_11_1_0_7|TABLE
SYS|KU$_DATAPUMP_MASTER_11_1|TABLE
SYS|KU$_DATAPUMP_MASTER_11_2|TABLE
SYS|KU$_LIST_FILTER_TEMP_2|TABLE
SYS|KU$_LIST_FILTER_TEMP|TABLE
SYS|KU$NOEXP_TAB|TABLE
SYS|KU$XKTFBUE|TABLE
SYS|ODCI_SECOBJ$|TABLE
SYS|ODCI_WARNINGS$|TABLE
SYS|PLAN_TABLE$|TABLE
SYS|PSTUBTBL|TABLE
SYS|WRI$_ADV_ASA_RECO_DATA|TABLE
SYSTEM|OL$HINTS|TABLE
SYSTEM|OL$NODES|TABLE
XDB|PATH_VIEW|VIEW
XDB|RESOURCE_VIEW|VIEW
XDB|XDB$ACL|TABLE
XDB|XDB$IMPORT_TT_INFO|TABLE
XDB|XDB$RESCONFIG|TABLE
XDB|XDB$XIDX_IMP_T|TABLE


$ sort test.txt
MDSYS|OGIS_GEOMETRY_COLUMNS|TABLE
MDSYS|OGIS_SPATIAL_REFERENCE_SYSTEMS|TABLE
MDSYS|SDO_IDX_TAB_SEQUENCE|SEQUENCE
MDSYS|SDO_PREFERRED_OPS_USER|TABLE
MDSYS|SDO_ST_TOLERANCE|TABLE
MDSYS|SDO_TOPO_DATA$|TABLE
MDSYS|SDO_TOPO_RELATION_DATA|TABLE
MDSYS|SDO_TOPO_TRANSACT_DATA$|VIEW
MDSYS|SDO_TXN_IDX_DELETES|TABLE
MDSYS|SDO_TXN_IDX_EXP_UPD_RGN|TABLE
MDSYS|SDO_TXN_IDX_INSERTS|TABLE
MDSYS|SRSNAMESPACE_TABLE|TABLE
MDSYS|USER_ANNOTATION_TEXT_METADATA|VIEW
MDSYS|USER_SDO_3DTHEMES|VIEW
MDSYS|USER_SDO_3DTXFMS|VIEW
MDSYS|USER_SDO_ANIMATIONS|VIEW
MDSYS|USER_SDO_CACHED_MAPS|VIEW
MDSYS|USER_SDO_GEOM_METADATA|VIEW
MDSYS|USER_SDO_LIGHTSOURCES|VIEW
MDSYS|USER_SDO_LRS_METADATA|VIEW
MDSYS|USER_SDO_MAPS|VIEW
MDSYS|USER_SDO_SCENES|VIEW
MDSYS|USER_SDO_STYLES|VIEW
MDSYS|USER_SDO_THEMES|VIEW
MDSYS|USER_SDO_VIEWFRAMES|VIEW
ORDDATA|ORDDCM_CONFORMANCE_VLD_MSGS|VIEW
OUTLN|OL$HINTS|TABLE
OUTLN|OL$NODES|TABLE
SYS|DATA_PUMP_XPL_TABLE$|TABLE
SYS|IMPDP_STATS|INDEX
SYS|IMPDP_STATS|TABLE
SYS|KU$_DATAPUMP_MASTER_10_1|TABLE
SYS|KU$_DATAPUMP_MASTER_11_1_0_7|TABLE
SYS|KU$_DATAPUMP_MASTER_11_1|TABLE
SYS|KU$_DATAPUMP_MASTER_11_2|TABLE
SYS|KU$_LIST_FILTER_TEMP_2|TABLE
SYS|KU$_LIST_FILTER_TEMP|TABLE
SYS|KU$NOEXP_TAB|TABLE
SYS|KU$XKTFBUE|TABLE
SYS|ODCI_SECOBJ$|TABLE
SYS|ODCI_WARNINGS$|TABLE
SYS|PLAN_TABLE$|TABLE
SYS|PSTUBTBL|TABLE
SYSTEM|OL$HINTS|TABLE
SYSTEM|OL$NODES|TABLE
SYS|WRI$_ADV_ASA_RECO_DATA|TABLE
XDB|PATH_VIEW|VIEW
XDB|RESOURCE_VIEW|VIEW
XDB|XDB$ACL|TABLE
XDB|XDB$IMPORT_TT_INFO|TABLE
XDB|XDB$RESCONFIG|TABLE
XDB|XDB$XIDX_IMP_T|TABLE


$ uname -a
Linux [hostname] 2.6.18-419.el5 #1 SMP Wed Feb 22 22:40:57 EST 2017 x86_64 x86_64 x86_64 GNU/Linux
$ cat redhat-release
Red Hat Enterprise Linux Server release 5.11 (Tikanga)

# 5  
Silly me Smilie, it does sort like what it should be doing what you said.
Still a bit lost why a 'normal' sort doesn't sort like I expect it to be Smilie

Cygwin sorts differently too but at least using sort -t"|" -k1,1 gives the same output as just doing sort

Code:
$ uname -a
CYGWIN_NT-6.2-WOW64 [host] 1.7.5(0.225/36/3) 2010-09-26 22:50 i686 GNU/Linux

$ sort test.txt
MDSYS|OGIS_GEOMETRY_COLUMNS|TABLE
MDSYS|OGIS_SPATIAL_REFERENCE_SYSTEMS|TABLE
MDSYS|SDO_IDX_TAB_SEQUENCE|SEQUENCE
MDSYS|SDO_PREFERRED_OPS_USER|TABLE
MDSYS|SDO_ST_TOLERANCE|TABLE
MDSYS|SDO_TOPO_DATA$|TABLE
MDSYS|SDO_TOPO_RELATION_DATA|TABLE
MDSYS|SDO_TOPO_TRANSACT_DATA$|VIEW
MDSYS|SDO_TXN_IDX_DELETES|TABLE
MDSYS|SDO_TXN_IDX_EXP_UPD_RGN|TABLE
MDSYS|SDO_TXN_IDX_INSERTS|TABLE
MDSYS|SRSNAMESPACE_TABLE|TABLE
MDSYS|USER_ANNOTATION_TEXT_METADATA|VIEW
MDSYS|USER_SDO_3DTHEMES|VIEW
MDSYS|USER_SDO_3DTXFMS|VIEW
MDSYS|USER_SDO_ANIMATIONS|VIEW
MDSYS|USER_SDO_CACHED_MAPS|VIEW
MDSYS|USER_SDO_GEOM_METADATA|VIEW
MDSYS|USER_SDO_LIGHTSOURCES|VIEW
MDSYS|USER_SDO_LRS_METADATA|VIEW
MDSYS|USER_SDO_MAPS|VIEW
MDSYS|USER_SDO_SCENES|VIEW
MDSYS|USER_SDO_STYLES|VIEW
MDSYS|USER_SDO_THEMES|VIEW
MDSYS|USER_SDO_VIEWFRAMES|VIEW
ORDDATA|ORDDCM_CONFORMANCE_VLD_MSGS|VIEW
OUTLN|OL$HINTS|TABLE
OUTLN|OL$NODES|TABLE
SYSTEM|OL$HINTS|TABLE
SYSTEM|OL$NODES|TABLE
SYS|DATA_PUMP_XPL_TABLE$|TABLE
SYS|IMPDP_STATS|INDEX
SYS|IMPDP_STATS|TABLE
SYS|KU$NOEXP_TAB|TABLE
SYS|KU$XKTFBUE|TABLE
SYS|KU$_DATAPUMP_MASTER_10_1|TABLE
SYS|KU$_DATAPUMP_MASTER_11_1_0_7|TABLE
SYS|KU$_DATAPUMP_MASTER_11_1|TABLE
SYS|KU$_DATAPUMP_MASTER_11_2|TABLE
SYS|KU$_LIST_FILTER_TEMP_2|TABLE
SYS|KU$_LIST_FILTER_TEMP|TABLE
SYS|ODCI_SECOBJ$|TABLE
SYS|ODCI_WARNINGS$|TABLE
SYS|PLAN_TABLE$|TABLE
SYS|PSTUBTBL|TABLE
SYS|WRI$_ADV_ASA_RECO_DATA|TABLE
XDB|PATH_VIEW|VIEW
XDB|RESOURCE_VIEW|VIEW
XDB|XDB$ACL|TABLE
XDB|XDB$IMPORT_TT_INFO|TABLE
XDB|XDB$RESCONFIG|TABLE
XDB|XDB$XIDX_IMP_T|TABLE


Last edited by newbie_01; 1 Week Ago at 12:53 AM..
Login or Register to Reply

|
Thread Tools Search this Thread
Search this Thread:
Advanced Search

More UNIX and Linux Forum Topics You Might Find Helpful
awk not working correctly
Junes
Hi I am attempting to right a script which will read a table and extract specfic information. LASTFAILEDJOB=/usr/openv/netbackup/scripts/GB-LDN/Junaid/temp_files/lastfailedjob cat /usr/openv/netbackup/scripts/GB-LDN/Junaid/temp_files/lastfailedjob 237308646 If i run the following...... Shell Programming and Scripting
5
Shell Programming and Scripting
I am a little bit confused in a socket example through select()
sehang
Hi, I am a newbie about network programming. All codes come from this book: UNIX Network Programming Volume 1, Third Edition. It is a TCP server by use select() int main(int argc, char **argv) { int i, maxi, maxfd, listenfd, connfd, sockfd; int ...... Programming
2
Programming
rsync is not correctly working
govindts
We are using Red Hat linux system. I am transferring my rman backup files to another server. Here is the command i am using to transfer the files. /usr/bin/rsync -avpP --delete /xyz/xyz/ 99.99.999.99::db110bkp Here is the rsync version. >rsync --version rsync version 3.0.6 ...... Shell Programming and Scripting
1
Shell Programming and Scripting
Variable not working correctly.
walsh_j
Hi, I have a script where I am trying to set a local variable using the following, MYVAR="$NAME"_"$NAME2".txt where say, NAME = one NAME2 = two so I want the output one_two.txt but what I am getting is, two.txt basically the $NAME2 is overwriting, what am I doing wrong? ...... Shell Programming and Scripting
3
Shell Programming and Scripting
if not working correctly
2dumb
Anyone have an idea why this if statement does not work correctly? "test2.sh" 18 lines, 386 characters #!/usr/bin/sh WARNING=80 CRITICAL=95 check_it() { if ] || ];then echo "YES ] || ]" else echo "NO ] || ]" fi } check_it 80.1 check_it 81.1... Shell Programming and Scripting
3
Shell Programming and Scripting

Featured Tech Videos