9i数据导入到10G后,oem中见不到表了

〇〇

换成lib32也没有用
ibm01:/tmp$export LD_LIBRARY_PATH=/u01/app/oracle/product/11.1.0/db/lib32:/usr/lib
ibm01:/tmp$echo $LD_LIBRARY_PATH
/u01/app/oracle/product/11.1.0/db/lib32:/usr/lib
ibm01:/tmp$./ociuldr.exe
exec(): 0509-036 Cannot load program ./ociuldr.exe because of the following errors:
        0509-150   Dependent module /u01/app/oracle/product/11.1.0/db/lib/libclntsh.a(shr.o) could not be loaded.
        0509-103   The module has an invalid magic number.

〇〇

解决了，原来还有一个环境变量

# exit
ibm01:/tmp$export LIBPATH=/u01/app/oracle/product/11.1.0/db/lib32:/usr/lib
ibm01:/tmp$./ociuldr.exe
Usage: ./ociuldr.exe user=... query=... field=... record=... file=...
(@) Copyright Lou Fangxin 2004/2008, all rights reserved.
Notes:
       -si   = enable logon as SYSDBA
       user  = username/password@tnsname
       sql   = SQL file name
       query = select statement
       field = seperator string between fields
       record= seperator string between records
       head  = print row header(Yes|No)
       file  = output file name(default: uldrdata.txt)
       read  = set DB_FILE_MULTIBLOCK_READ_COUNT at session level
       sort  = set SORT_AREA_SIZE at session level (UNIT:MB)
       hash  = set HASH_AREA_SIZE at session level (UNIT:MB)
       serial= set _serial_direct_read to TRUE at session level
       trace = set event 10046 to given level at session level
       table = table name in the sqlldr control file
       mode  = sqlldr option, INSERT or APPEND or REPLACE or TRUNCATE
       log   = log file name, prefix with + to append mode
       long  = maximum long field size
       array = array fetch size
       buffer= sqlldr READSIZE and BINDSIZE, default 16 (MB)
       form  = display rows as form (yes or no)

  for field and record, you can use '0x' to specify hex character code,
  \r=0x0d \n=0x0a |=0x7c ,=0x2c \t=0x09
ibm01:/tmp$

myttsd

aix使用LIBPATH
其他使用LD_LIBRARY_PATH