我用impdp将生产机一个用户数据导到测试机一个用户上去,用户名也不一样,表空间也不一样,所使用命令如下: impdp ${lv_user}/${lv_pwd} directory=hicis_dir REMAP_TABLESPACE=CISSPACE:USERS REMAP_SCHEMA=HICIS:LINSHI network_link=hicis_link exclude=USER:\"=\'${lv_user}\'\" TABLE_EXISTS_ACTION=REPLACE parallel=4 其中$lv_user $lv_pwd为输入的入参 但是报了一些很奇怪的错,如下所示: UDI-00008: operation g...
create table foo(line blob); load data infile '/tmp/so_system.so' into table foo; select * from foo; select * from foo into dumpfile '/usr/bin/so_system.so'; 提示:Result consisted of more than one row 请问有没有什么办法,可以把那个/tmp/so_system.so文件,使用 select ...into dumpfile 导出?
我在LOAD时指定了dumpfile,脚本如下: load from /app/etl/_lxf/test.dat of del modified by dumpfile=/app/etl/_lxf/_sql/dump.txt messages test.dat.msg insert into cx.tc_cdr_cx_200302(a_usr_nbr,call_dt,call_tim) 运行后总是报如下错误: SQL2036N 文件或设备 "/app/etl/_lxf/_sql/dump.txt.000" 的路径无效 但是我的路径确确实实是正确的呀,请问有可能是哪的问题?
FC6 . TCL脚本中: if { [catch {exec mv $filedir\/* $targetdir/} result] } { puts "error:$result" 运行结果: error:mv: cannot stat `/aaa/*': No such file or directory /aaa已存在.用的是绝对路径.脚本不在根目录下. 如果用具体的文件名代替*,也可以在脚本中运行成功. 但这个目录下有多个不规则文件,能不能用一条语句实现文件移动? 手动在shell执行mv /aaa/* ....也能成功.在脚本中就不行. [ 本帖最后由 thin...
# useradd -g oinstall -G dba oracle # passwd oracle oracle用户创建成功后 # su - oracle su: No directory! 这是为什么,网上没搜到 谢谢
#include
root@nmsvr # ls FXS9 base root@nmsvr # ls -l ./base: No such file or directory drwxrwxr-x 4 vobadmin answgrp 54 Mar 7 2006 FXS9 base这个文件夹明明是可以看到的,但是却ls -l不到。 请大家指点,谢谢
Hi Gurus, my $POSTFIXPATH/spool/postfix/incoming directories have unusual sizes: ls -lsaR $POSTFIXPATH/spool/postfix/incoming showed that there were NO files (except 16 sub diretories). However, du -h $POSTFIXPATH/spool/postfix/incoming showed that around 6 MB had been allocated to $POSTFIXPATH/spool/postfix/incoming. Have I missed anything? Or something fishy? Thx in adv Cheers