时间：2021-07-01 10:21:17 帮助过：1人阅读
kbyy:/oracle/work/sub_imp> more exp_subs_a.sh
#!/usr/bin/ksh
. ~/.profile
export ORACLE_SID=tbcsa1
cd /oracle/work/sub_imp/tbcsa
rm *.p
cd /oracle/work/sub_imp
sqlplus dbmt/dbmt_666 <<!> exp_a.log
@./tab.sql
truncate table SUBS_SERVICE;
truncate table SUBS_SPSERVICE;
!
mknod ./tbcsa/SUBS_SERVICE:PART_310.p p
mknod ./tbcsa/SUBS_SERVICE:PART_311.p p
mknod ./tbcsa/SUBS_SERVICE:PART_312.p p
mknod ./tbcsa/SUBS_SERVICE:PART_313.p p
mknod ./tbcsa/SUBS_SERVICE:PART_314.p p
mknod ./tbcsa/SUBS_SERVICE:PART_315.p p
mknod ./tbcsa/SUBS_SERVICE:PART_316.p p
mknod ./tbcsa/SUBS_SERVICE:PART_317.p p
mknod ./tbcsa/SUBS_SERVICE:PART_318.p p
mknod ./tbcsa/SUBS_SERVICE:PART_319.p p
mknod ./tbcsa/SUBS_SERVICE:PART_335.p p
mknod ./tbcsa/SUBS_SERVICE:PART_999.p p
sleep 1
nohup exp dbmt/dbmt_dba@tbcsa_bcv TABLES=TBCS.SUBS_SERVICE:PART_310 FILE=./tbcsa/SUBS_SERVICE:PART_310.p LOG=./tbcsa/SUBS_SERVICE:PA
RT_310.exp.log parfile=exp.par &
nohup exp TABLES=TBCS.SUBS_SERVICE:PART_311 FILE=./tbcsa/SUBS_SERVICE:PART_311.p LOG=./tbcsa/SUBS_SERVICE:PA
RT_311.exp.log parfile=exp.par &
nohup exp TABLES=TBCS.SUBS_SERVICE:PART_312 FILE=./tbcsa/SUBS_SERVICE:PART_312.p LOG=./tbcsa/SUBS_SERVICE:PA
RT_312.exp.log parfile=exp.par &
nohup exp TABLES=TBCS.SUBS_SERVICE:PART_313 FILE=./tbcsa/SUBS_SERVICE:PART_313.p LOG=./tbcsa/SUBS_SERVICE:PA
RT_313.exp.log parfile=exp.par &
nohup exp TABLES=TBCS.SUBS_SERVICE:PART_314 FILE=./tbcsa/SUBS_SERVICE:PART_314.p LOG=./tbcsa/SUBS_SERVICE:PA
RT_314.exp.log parfile=exp.par &
nohup exp TABLES=TBCS.SUBS_SERVICE:PART_315 FILE=./tbcsa/SUBS_SERVICE:PART_315.p LOG=./tbcsa/SUBS_SERVICE:PA
RT_315.exp.log parfile=exp.par &
nohup exp TABLES=TBCS.SUBS_SERVICE:PART_316 FILE=./tbcsa/SUBS_SERVICE:PART_316.p LOG=./tbcsa/SUBS_SERVICE:PA
RT_316.exp.log parfile=exp.par &
nohup exp TABLES=TBCS.SUBS_SERVICE:PART_317 FILE=./tbcsa/SUBS_SERVICE:PART_317.p LOG=./tbcsa/SUBS_SERVICE:PA
RT_317.exp.log parfile=exp.par &
nohup exp TABLES=TBCS.SUBS_SERVICE:PART_318 FILE=./tbcsa/SUBS_SERVICE:PART_318.p LOG=./tbcsa/SUBS_SERVICE:PA
RT_318.exp.log parfile=exp.par &
nohup exp TABLES=TBCS.SUBS_SERVICE:PART_319 FILE=./tbcsa/SUBS_SERVICE:PART_319.p LOG=./tbcsa/SUBS_SERVICE:PA
RT_319.exp.log parfile=exp.par &
nohup exp TABLES=TBCS.SUBS_SERVICE:PART_335 FILE=./tbcsa/SUBS_SERVICE:PART_335.p LOG=./tbcsa/SUBS_SERVICE:PA
RT_335.exp.log parfile=exp.par &
nohup exp TABLES=TBCS.SUBS_SERVICE:PART_999 FILE=./tbcsa/SUBS_SERVICE:PART_999.p LOG=./tbcsa/SUBS_SERVICE:PA
RT_999.exp.log parfile=exp.par &
sleep 1
nohup imp dbmt/dbmt_666 FROMUSER=TBCS TOUSER=DBMT TABLES=SUBS_SERVICE FILE=./tbcsa/SUBS_SERVICE:PART_310.p LOG=./tbcsa/SUBS_SERVICE:
PART_310.imp.log parfile=imp.par &
nohup imp dbmt/dbmt_666 FROMUSER=TBCS TOUSER=DBMT TABLES=SUBS_SERVICE FILE=./tbcsa/SUBS_SERVICE:PART_311.p LOG=./tbcsa/SUBS_SERVICE:
PART_311.imp.log parfile=imp.par &
nohup imp dbmt/dbmt_666 FROMUSER=TBCS TOUSER=DBMT TABLES=SUBS_SERVICE FILE=./tbcsa/SUBS_SERVICE:PART_312.p LOG=./tbcsa/SUBS_SERVICE:
PART_312.imp.log parfile=imp.par &
nohup imp dbmt/dbmt_666 FROMUSER=TBCS TOUSER=DBMT TABLES=SUBS_SERVICE FILE=./tbcsa/SUBS_SERVICE:PART_313.p LOG=./tbcsa/SUBS_SERVICE:
PART_313.imp.log parfile=imp.par &
nohup imp dbmt/dbmt_666 FROMUSER=TBCS TOUSER=DBMT TABLES=SUBS_SERVICE FILE=./tbcsa/SUBS_SERVICE:PART_314.p LOG=./tbcsa/SUBS_SERVICE:
PART_314.imp.log parfile=imp.par &
nohup imp dbmt/dbmt_666 FROMUSER=TBCS TOUSER=DBMT TABLES=SUBS_SERVICE FILE=./tbcsa/SUBS_SERVICE:PART_315.p LOG=./tbcsa/SUBS_SERVICE:
PART_315.imp.log parfile=imp.par &
nohup imp dbmt/dbmt_666 FROMUSER=TBCS TOUSER=DBMT TABLES=SUBS_SERVICE FILE=./tbcsa/SUBS_SERVICE:PART_316.p LOG=./tbcsa/SUBS_SERVICE:
PART_316.imp.log parfile=imp.par &
nohup imp dbmt/dbmt_666 FROMUSER=TBCS TOUSER=DBMT TABLES=SUBS_SERVICE FILE=./tbcsa/SUBS_SERVICE:PART_317.p LOG=./tbcsa/SUBS_SERVICE:
PART_317.imp.log parfile=imp.par &
nohup imp dbmt/dbmt_666 FROMUSER=TBCS TOUSER=DBMT TABLES=SUBS_SERVICE FILE=./tbcsa/SUBS_SERVICE:PART_318.p LOG=./tbcsa/SUBS_SERVICE:
PART_318.imp.log parfile=imp.par &
nohup imp dbmt/dbmt_666 FROMUSER=TBCS TOUSER=DBMT TABLES=SUBS_SERVICE FILE=./tbcsa/SUBS_SERVICE:PART_319.p LOG=./tbcsa/SUBS_SERVICE:
PART_319.imp.log parfile=imp.par &
nohup imp dbmt/dbmt_666 FROMUSER=TBCS TOUSER=DBMT TABLES=SUBS_SERVICE FILE=./tbcsa/SUBS_SERVICE:PART_335.p LOG=./tbcsa/SUBS_SERVICE:
PART_335.imp.log parfile=imp.par &
nohup imp dbmt/dbmt_666 FROMUSER=TBCS TOUSER=DBMT TABLES=SUBS_SERVICE FILE=./tbcsa/SUBS_SERVICE:PART_999.p LOG=./tbcsa/SUBS_SERVICE:
PART_999.imp.log parfile=imp.par &
sleep 1
mknod ./tbcsa/SUBS_SPSERVICE:PART_310.p p
mknod ./tbcsa/SUBS_SPSERVICE:PART_311.p p
mknod ./tbcsa/SUBS_SPSERVICE:PART_312.p p
mknod ./tbcsa/SUBS_SPSERVICE:PART_313.p p
mknod ./tbcsa/SUBS_SPSERVICE:PART_314.p p
mknod ./tbcsa/SUBS_SPSERVICE:PART_315.p p
mknod ./tbcsa/SUBS_SPSERVICE:PART_316.p p
mknod ./tbcsa/SUBS_SPSERVICE:PART_317.p p
mknod ./tbcsa/SUBS_SPSERVICE:PART_318.p p
mknod ./tbcsa/SUBS_SPSERVICE:PART_319.p p
mknod ./tbcsa/SUBS_SPSERVICE:PART_335.p p
mknod ./tbcsa/SUBS_SPSERVICE:PART_999.p p
sleep 1
nohup exp dbmt/dbmt_dba@tbcsa_bcv TABLES=TBCS.SUBS_SPSERVICE:PART_310 FILE=./tbcsa/SUBS_SPSERVICE:PART_310.p LOG=./tbcsa/SUBS_SPSERV
ICE:PART_310.exp.log parfile=exp.par &
nohup exp TABLES=TBCS.SUBS_SPSERVICE:PART_311 FILE=./tbcsa/SUBS_SPSERVICE:PART_311.p LOG=./tbcsa/SUBS_SPSERV
ICE:PART_311.exp.log parfile=exp.par &
nohup exp TABLES=TBCS.SUBS_SPSERVICE:PART_312 FILE=./tbcsa/SUBS_SPSERVICE:PART_312.p LOG=./tbcsa/SUBS_SPSERV
ICE:PART_312.exp.log parfile=exp.par &
nohup exp TABLES=TBCS.SUBS_SPSERVICE:PART_313 FILE=./tbcsa/SUBS_SPSERVICE:PART_313.p LOG=./tbcsa/SUBS_SPSERV
ICE:PART_313.exp.log parfile=exp.par &
nohup exp TABLES=TBCS.SUBS_SPSERVICE:PART_314 FILE=./tbcsa/SUBS_SPSERVICE:PART_314.p LOG=./tbcsa/SUBS_SPSERV
ICE:PART_314.exp.log parfile=exp.par &
nohup exp TABLES=TBCS.SUBS_SPSERVICE:PART_315 FILE=./tbcsa/SUBS_SPSERVICE:PART_315.p LOG=./tbcsa/SUBS_SPSERV
ICE:PART_315.exp.log parfile=exp.par &
nohup exp TABLES=TBCS.SUBS_SPSERVICE:PART_316 FILE=./tbcsa/SUBS_SPSERVICE:PART_316.p LOG=./tbcsa/SUBS_SPSERV
ICE:PART_316.exp.log parfile=exp.par &
nohup exp TABLES=TBCS.SUBS_SPSERVICE:PART_317 FILE=./tbcsa/SUBS_SPSERVICE:PART_317.p LOG=./tbcsa/SUBS_SPSERV
ICE:PART_317.exp.log parfile=exp.par &
nohup exp TABLES=TBCS.SUBS_SPSERVICE:PART_318 FILE=./tbcsa/SUBS_SPSERVICE:PART_318.p LOG=./tbcsa/SUBS_SPSERV
ICE:PART_318.exp.log parfile=exp.par &
nohup exp TABLES=TBCS.SUBS_SPSERVICE:PART_319 FILE=./tbcsa/SUBS_SPSERVICE:PART_319.p LOG=./tbcsa/SUBS_SPSERV
ICE:PART_319.exp.log parfile=exp.par &
nohup exp TABLES=TBCS.SUBS_SPSERVICE:PART_335 FILE=./tbcsa/SUBS_SPSERVICE:PART_335.p LOG=./tbcsa/SUBS_SPSERV
ICE:PART_335.exp.log parfile=exp.par &
nohup exp TABLES=TBCS.SUBS_SPSERVICE:PART_999 FILE=./tbcsa/SUBS_SPSERVICE:PART_999.p LOG=./tbcsa/SUBS_SPSERV
ICE:PART_999.exp.log parfile=exp.par &
sleep 1
nohup imp dbmt/dbmt_666 FROMUSER=TBCS TOUSER=DBMT TABLES=SUBS_SPSERVICE FILE=./tbcsa/SUBS_SPSERVICE:PART_310.p LOG=./tbcsa/SUBS_SPSE
RVICE:PART_310.imp.log parfile=imp.par &
nohup imp dbmt/dbmt_666 FROMUSER=TBCS TOUSER=DBMT TABLES=SUBS_SPSERVICE FILE=./tbcsa/SUBS_SPSERVICE:PART_311.p LOG=./tbcsa/SUBS_SPSE
RVICE:PART_311.imp.log parfile=imp.par &
nohup imp dbmt/dbmt_666 FROMUSER=TBCS TOUSER=DBMT TABLES=SUBS_SPSERVICE FILE=./tbcsa/SUBS_SPSERVICE:PART_312.p LOG=./tbcsa/SUBS_SPSE
RVICE:PART_312.imp.log parfile=imp.par &
nohup imp dbmt/dbmt_666 FROMUSER=TBCS TOUSER=DBMT TABLES=SUBS_SPSERVICE FILE=./tbcsa/SUBS_SPSERVICE:PART_313.p LOG=./tbcsa/SUBS_SPSE
RVICE:PART_313.imp.log parfile=imp.par &
nohup imp dbmt/dbmt_666 FROMUSER=TBCS TOUSER=DBMT TABLES=SUBS_SPSERVICE FILE=./tbcsa/SUBS_SPSERVICE:PART_314.p LOG=./tbcsa/SUBS_SPSE
RVICE:PART_314.imp.log parfile=imp.par &
nohup imp dbmt/dbmt_666 FROMUSER=TBCS TOUSER=DBMT TABLES=SUBS_SPSERVICE FILE=./tbcsa/SUBS_SPSERVICE:PART_315.p LOG=./tbcsa/SUBS_SPSE
RVICE:PART_315.imp.log parfile=imp.par &
nohup imp dbmt/dbmt_666 FROMUSER=TBCS TOUSER=DBMT TABLES=SUBS_SPSERVICE FILE=./tbcsa/SUBS_SPSERVICE:PART_316.p LOG=./tbcsa/SUBS_SPSE
RVICE:PART_316.imp.log parfile=imp.par &
nohup imp dbmt/dbmt_666 FROMUSER=TBCS TOUSER=DBMT TABLES=SUBS_SPSERVICE FILE=./tbcsa/SUBS_SPSERVICE:PART_317.p LOG=./tbcsa/SUBS_SPSE
RVICE:PART_317.imp.log parfile=imp.par &
nohup imp dbmt/dbmt_666 FROMUSER=TBCS TOUSER=DBMT TABLES=SUBS_SPSERVICE FILE=./tbcsa/SUBS_SPSERVICE:PART_318.p LOG=./tbcsa/SUBS_SPSE
RVICE:PART_318.imp.log parfile=imp.par &
nohup imp dbmt/dbmt_666 FROMUSER=TBCS TOUSER=DBMT TABLES=SUBS_SPSERVICE FILE=./tbcsa/SUBS_SPSERVICE:PART_319.p LOG=./tbcsa/SUBS_SPSE
RVICE:PART_319.imp.log parfile=imp.par &
nohup imp dbmt/dbmt_666 FROMUSER=TBCS TOUSER=DBMT TABLES=SUBS_SPSERVICE FILE=./tbcsa/SUBS_SPSERVICE:PART_335.p LOG=./tbcsa/SUBS_SPSE
RVICE:PART_335.imp.log parfile=imp.par &
nohup imp dbmt/dbmt_666 FROMUSER=TBCS TOUSER=DBMT TABLES=SUBS_SPSERVICE FILE=./tbcsa/SUBS_SPSERVICE:PART_999.p LOG=./tbcsa/SUBS_SPSE
RVICE:PART_999.imp.log parfile=imp.par &
kbyy:/oracle/work/sub_imp>
kbyy:/oracle/work/sub_imp> more tab.sql
create table SUBS_SERVICE
(
oid NUMBER(14) not null,
subsid NUMBER(14) not null,
region NUMBER(5) not null,
serviceid VARCHAR2(16) not null,
subsprodoid NUMBER(14),
prodid VARCHAR2(32) not null,
grpsubsid NUMBER(14),
startdate DATE,
applyoid NUMBER(14) not null,
enddate DATE,
canceloid NUMBER(14),
status NUMBER(1),
servstatus NUMBER(1),
statusdate DATE,
oldenddate DATE,
refergrpsubsid NUMBER(14),
affecttype NUMBER(1),
serverstatusdate DATE,
applyaccesstype VARCHAR2(16),
applyoperid VARCHAR2(20),
cancelaccesstype VARCHAR2(16),
canceloperid VARCHAR2(20),
applydate DATE,
canceldate DATE,
billingflag NUMBER(5)
)
partition by range (REGION)
(
partition PART_310 values less than (311)
tablespace DATALOG310
pctfree 10
initrans 40
maxtrans 255
storage
(
initial 4M
next 4M
minextents 1
maxextents unlimited
pctincrease 0
),
partition PART_311 values less than (312)
tablespace DATALOG311
pctfree 10
initrans 40
maxtrans 255
storage
(
initial 4M
next 4M
minextents 1
maxextents unlimited
pctincrease 0
),
partition PART_312 values less than (313)
tablespace DATALOG312
pctfree 10
initrans 40
maxtrans 255
storage
(
initial 4M
next 4M
minextents 1
maxextents unlimited
pctincrease 0
),
partition PART_313 values less than (314)
tablespace DATALOG313
pctfree 10
initrans 40
maxtrans 255
storage
(
initial 4M
next 4M
minextents 1
maxextents unlimited
pctincrease 0
),
partition PART_314 values less than (315)
tablespace DATALOG314
pctfree 10
initrans 40
maxtrans 255
storage
(
initial 4M
next 4M
minextents 1
maxextents unlimited
pctincrease 0
),
partition PART_315 values less than (316)
tablespace DATALOG315
pctfree 10
initrans 40
maxtrans 255
storage
(
initial 4M
next 4M
minextents 1
maxextents unlimited
pctincrease 0
),
partition PART_316 values less than (317)
tablespace DATALOG316
pctfree 10
initrans 40
maxtrans 255
storage
(
initial 4M
next 4M
minextents 1
maxextents unlimited
pctincrease 0
),
partition PART_317 values less than (318)
tablespace DATALOG317
pctfree 10
initrans 40
maxtrans 255
storage
(
initial 4M
next 4M
minextents 1
maxextents unlimited
pctincrease 0
),
partition PART_318 values less than (319)
tablespace DATALOG318
pctfree 10
initrans 40
maxtrans 255
storage
(
initial 4M
next 4M
minextents 1
maxextents unlimited
pctincrease 0
),
partition PART_319 values less than (320)
tablespace DATALOG319
pctfree 10
initrans 40
maxtrans 255
storage
(
initial 4M
next 4M
minextents 1
maxextents unlimited
pctincrease 0
),
partition PART_335 values less than (336)
tablespace DATALOG335
pctfree 10
initrans 40
maxtrans 255
storage
(
initial 4M
next 4M
minextents 1
maxextents unlimited
pctincrease 0
),
partition PART_999 values less than (1000)
tablespace DATALOG999
pctfree 10
initrans 40
maxtrans 255
storage
(
initial 4M
next 4M
minextents 1
maxextents unlimited
pctincrease 0
)
)
/
create table SUBS_SPSERVICE
(
oid NUMBER(14) not null,
subsid NUMBER(14) not null,
region NUMBER(5) not null,
spservid VARCHAR2(16),
spbizid VARCHAR2(64),
spid VARCHAR2(64),
subsprodoid NUMBER(14),
prodid VARCHAR2(32) not null,
applyoid NUMBER(14) not null,
startdate DATE,
canceloid NUMBER(14),
enddate DATE,
status NUMBER(1),
groupid NUMBER(14),
servstatus NUMBER(1),
statusdate DATE,
localspid VARCHAR2(60),
oprsource VARCHAR2(30),
spbiztype VARCHAR2(32),
domain VARCHAR2(32),
thrdnum VARCHAR2(20),
rltrefid NUMBER(18),
idtype VARCHAR2(32),
prior_order_time DATE,
last_order_time DATE,
oldenddate DATE,
applyaccesstype VARCHAR2(16),
applyoperid VARCHAR2(20),
cancelaccesstype VARCHAR2(16),
canceloperid VARCHAR2(20),
vccardnum VARCHAR2(64),
billingflag NUMBER(5)
)
partition by range (REGION)
(
partition PART_310 values less than (311)
tablespace DATALOG310
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 4M
next 4M
minextents 1
maxextents unlimited
pctincrease 0
),
partition PART_311 values less than (312)
tablespace DATALOG311
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 4M
next 4M
minextents 1
maxextents unlimited
pctincrease 0
),
partition PART_312 values less than (313)
tablespace DATALOG312
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 4M
next 4M
minextents 1
maxextents unlimited
pctincrease 0
),
partition PART_313 values less than (314)
tablespace DATALOG313
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 4M
next 4M
minextents 1
maxextents unlimited
pctincrease 0
),
partition PART_314 values less than (315)
tablespace DATALOG314
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 4M
next 4M
minextents 1
maxextents unlimited
pctincrease 0
),
partition PART_315 values less than (316)
tablespace DATALOG315
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 4M
next 4M
minextents 1
maxextents unlimited
pctincrease 0
),
partition PART_316 values less than (317)
tablespace DATALOG316
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 4M
next 4M
minextents 1
maxextents unlimited
pctincrease 0
),
partition PART_317 values less than (318)
tablespace DATALOG317
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 4M
next 4M
minextents 1
maxextents unlimited
pctincrease 0
),
partition PART_318 values less than (319)
tablespace DATALOG318
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 4M
next 4M
minextents 1
maxextents unlimited
pctincrease 0
),
partition PART_319 values less than (335)
tablespace DATALOG319
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 4M
next 4M
minextents 1
maxextents unlimited
pctincrease 0
),
partition PART_335 values less than (336)
tablespace DATALOG335
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 4M
next 4M
minextents 1
maxextents unlimited
pctincrease 0
),
partition PART_999 values less than (1000)
tablespace DATALOG999
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 4M
next 4M
minextents 1
maxextents unlimited
pctincrease 0
)
)
/
kbyy:/oracle/work/sub_imp>
kbyy:/oracle/work/sub_imp> more exp.par
grants = n
STATISTICS=none
indexes = n
constraints = n
triggers=n
direct = y
buffer = 409600000
recordlength=65535
kbyy:/oracle/work/sub_imp>
结束。
oracle exp 命令导大数据
标签：