00 ORACLE 工具使用例句.docVIP

EXP、IMP 表导出、导入： exp userid=sys/change_on_install@itspfdb as sysdba tables=itspf.t_holiday file=E:\t_holidayexp.dmp log=E:\ t_holidayexp.log bufferimp userid=sys/change_on_install@itspfdb as sysdba file=E:\ t_holidayexp.dmp fromuser=itspf touser=itspf ignore=y log=E:\t_holidayimp.log buffer用户导出、导入： exp userid=sys/change_on_install@itspfdb as sysdba owner =its_abd file=E:\its_abdexp.dmp log=E:\its_abdexp.log bufferimp userid=sys/sys as sysdba fromuser=its_abd touser=its_abd file=E:\its_abdexp.dmp log=E:\its_abdimp.log ignore=y buffer全库导出、导入： exp userid=sys/change_on_install@dmsdb as sysdba full=y file=(f:\dmsdb01.dmp, f:\ dmsdb02.dmp) filesize=5GB log=f:\201001exp.log bufferimp userid=sys/sys@dmsdb as sysdba full=y file=f:\ dmsdb01.dmp log=f:\ 201001imp.log buffer-- 冷备份生成语句 Spool f:\backup\cold_backup.sql select copy || name || f:\backup\ from v$controlfile union select copy || file_name || f:\backup\ from dba_data_files union select copy || member || f:\backup\ from v$logfile; spool off -- 热备份生成语句 spool f:\backup\hot_backup.sql select tablespace_name, 1 sortorder, alter tablespace || tablespace_name || begin backup; textout from dba_data_files union select tablespace_name, 2 sortorder, host copy || file_name || || f:\backup\ textout from dba_data_files union select tablespace_name, 3 sortorder, alter tablespace || tablespace_name || end backup; textout from dba_data_files order by tablespace_name, sortorder,textout; select alter system archive log current; from dual; spool off 二、TKPROF Tkprof 全称：tool kit profiler trace kernel profiler 例句： tkprof orcl_ora_14483.trc qintest.txt explain=system/manager sys=no waits=yes sort=fchela aggregate=yes 用法： Tkprof tracefile outputfile [explain= ] [table= ] [print= ] [insert= ] [sys= ] [sort= ] 参数说明： tracefile： 你要分析的trace文件 outputfile： 格式化后的文件 explain=user/password@connectstring table=schema.tablename 这两个参数是一起使用的，通过连接数据库对在trace文件中出现的每条sql语句查看执