copy 命令

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$