- 论坛徽章:
- 0
|
请教imp的问题
init.ora
db_name = oradb
instance_name = oradb
control_files = ('/opt/oracle/oradata/oradb/system/ora_control1.ctl', '/opt/oracle/oradata/oradb/system/ora_control2.ctl')
db_block_size = 8192
pga_aggregate_target = 100M
db_cache_size = 200M
shared_pool_size = 50M
db_file_multiblock_read_count = 32
processes = 200
sessions = 500
open_cursors = 500
db_writer_processes = 2
background_dump_dest = /opt/oracle/admin/oradb/bdump
core_dump_dest = /opt/oracle/admin/oradb/cdump
user_dump_dest = /opt/oracle/admin/oradb/udump
undo_management = auto
undo_tablespace = tbsundo
compatible = 9.0.0
init.ora基本上是平淡无奇的,有些在oracle8i上需要设的参数如log,9i已经做了优化
imp:
TABLE=user_info
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 tbs_index;
create unique index user_info_x01 on user_info(nickname) tablespace tbs_index;
create index user_info_x02 on user_info(register_dt) tablespace tbs_index;
exit;
EOF
imp我作了一点变化,先不建任何索引,导入成功后再建,这样速度快一些
sqlldr和exp都工作正常,惟独在imp上出现这个怪毛病,非常非常地郁闷。 |
|