imprec

一本介绍oracle的书籍

USER_PASSWD=dbuser/oracle
TABLE=user_info

#index
#imp $USER_PASSWD file=dmp/${TABLE}.dmp tables=${TABLE} fromuser=dbuser touser=dbuser buffer=4096000 commit=y ignore=y feedback=10000

#with no index
#imp $USER_PASSWD file=dmp/${TABLE}.dmp tables=${TABLE} fromuser=dbuser touser=dbuser buffer=4096000 indexes=n commit=y ignore=y feedback=10000
sqlplus $USER_PASSWD <<EOF
create unique index user_info_x00 on user_info(loginname) tablespace tbsindex;
create unique index user_info_x01 on user_info(nickname) tablespace tbsindex;
create index user_info_x02 on user_info(register_dt) tablespace tbsindex;
exit;
EOF