USER_PASSWD=dbuser/oracleTABLE=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=10000sqlplus $USER_PASSWD <<EOFcreate 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