EXP的例子:
exp userid=system/manager
parfile=exp_user.par
file=exp_scott.dmp
log=exp_scott.log
owner="(scott)"
exp_user.par的内容
BUFFER=4096000(以字节为单位,可自行调整)
--------------
COMPRESS=Y
GRANTS=Y
INDEXES=Y
ROWS=Y
CONSTRAINTS=Y
DIRECT=Y (以direct 方式导出,速度快)
-------- 注意上面的第一个和最后一个参数,对性能有很大影响. IMP 时,可以先不导入索引,约束,导入完毕再重新建立.
解决方案 »
- 真晕。不知道怎么写了。
- oracle10g rac 关机步骤?
- 我在安装oracle9i后一切正常,能通过delphi(BDE)连接到oracle,但重新启动时报错啊19011
- Oracle9i中利用jdbc写一条简单sql语句遇到问题。请大家帮忙
- 新手几问如果要新建一个和101_db结构一样的库,只是叫102_db
- 请救各路Oracle高手?Oracle的number类型,哪个属性可以设定保存小数点后面的零........
- 不能连接数据库。
- 怎样做 实现一个这样的表!?
- 主从表关联数据,如何写的sql语句得到主表的记录和相关的从表记录
- linux ,oracle mount过程中报错,重启没关库导致的,求大神帮忙谢谢,Address not mapped to object
- 关于提交是否会影响系统资源的问题。
- 怎样查看blob类型的数据??
Set the BUFFER parameter to a high value (e.g. 2M)
Set the RECORDLENGTH parameter to a high value (e.g. 64K)
Stop unnecessary applications to free-up resources for your job.
If you run multiple export sessions, ensure they write to different physical disks.
DO NOT export to an NFS mounted filesystem. It will take forever.
IMPORT:
Create an indexfile so that you can create indexes AFTER you have imported data. Do this by setting INDEXFILE to a filename and then import. No data will be imported but a file containing index definitions will be created. You must edit this file afterwards and supply the passwords for the schemas on all CONNECT statements.
Place the file to be imported on a separate physical disk from the oracle data files
Increase DB_CACHE_SIZE (DB_BLOCK_BUFFERS prior to 9i) considerably in the init$SID.ora file
Set the LOG_BUFFER to a big value and restart oracle.
Stop redo log archiving if it is running (ALTER DATABASE NOARCHIVELOG;)
Create a BIG tablespace with a BIG rollback segment inside. Set all other rollback segments offline (except the SYSTEM rollback segment of course). The rollback segment must be as big as your biggest table (I think?)
Use COMMIT=N in the import parameter file if you can afford it
Use ANALYZE=N in the import parameter file to avoid time consuming ANALYZE statements
Remember to run the indexfile previously created --摘自 www.orafaq.net