copy 命令

来源：互联网发布：最优化方法中基变量编辑：程序博客网时间：2024/04/28 08:16

select * from outln.ol$

exp shyt/inet21 file=test_ol log=test_ol tables=outln.ol$ query=''''''where ol$.category='TEST'''''''
exp shyt/inet21 file=test_ol log=test_ol tables=outln.ol$ query=/"where ol$.category=/'TEST/'/"
exp shyt/inet21 file=test_ol log=test_ol parfile=par_file.txt

insert into test1 (sql_text) select sql_text from outln.ol$

copy from shyt/inet21@orcl append testimg1 using select * from test1

create table pccw_ol$
(
ol_name     VARCHAR2(30),
sql_text    LONG,
textlen     NUMBER,
signature   RAW(16),
hash_value NUMBER,
hash_value2 NUMBER,
category    VARCHAR2(30),
version     VARCHAR2(64),
creator     VARCHAR2(30),
timestamp   DATE,
flags       NUMBER,
hintcount   NUMBER,
spare1      NUMBER,
spare2      VARCHAR2(1000),
ref1        VARCHAR2(30)
)
select * from pccw_ol$
copy from system/inet21@orcl append pccw_ol$ using select * from outln.ol$

copy from system/inet21@orcl insert pccw_ol$ (ol_name,sql_text,textlen,signature,hash_value,hash_value2,category,version,creator,timestamp,flags,hintcount,spare1,spare2,ref1) using select ol_name,sql_text,textlen,signature,hash_value,hash_value2,category,version,creator,timestamp,flags,hintcount,spare1,spare2,'' from outln.ol$
copy from system/inet21@orcl insert pccw_ol$ (ol_name,sql_text,textlen,signature,hash_value,hash_value2,category,version,creator,timestamp,flags,hintcount,spare1,spare2) using select ol_name,sql_text,textlen,signature,hash_value,hash_value2,category,version,creator,timestamp,flags,hintcount,spare1,spare2 from outln.ol$

copy from system/inet21@orcl insert pccw_ol$ (ol_name,sql_text) using select ol_name,sql_text from outln.ol$