求$ORACLE_HOME/bin目录下所有命令的使用方法及命令详解
如题。
$ORACLE_HOME/bin目录下有很多命令,那我们平时用到的也不是太多,即使用到的那部分可能用法也不是完全能掌握,所以还请高人指点解释一下该目录下其他命令的使用奥秘,不求有多全,知道多少讲多少,希望大家互相补充,如遇特殊命令烦请注明版本。
例如,数据库的导入命令imp,可以使用help=y来获得帮助信息
imp help=y
Import: Release 10.2.0.4.0 - Production on Mon Dec 29 15:29:01 2008 Copyright (c) 1982, 2007, Oracle. All rights reserved.
You can let Import prompt you for parameters by entering the IMP
command followed by your username/password:
Example: IMP SCOTT/TIGER
Or, you can control how Import runs by entering the IMP command followed by various arguments. To specify parameters, you use keywords:
Format: IMP KEYWORD=value or KEYWORD=(value1,value2,...,valueN) Example: IMP SCOTT/TIGER IGNORE=Y TABLES=(EMP,DEPT) FULL=N or TABLES=(T11,T12), if T1 is partitioned table
USERID must be the first parameter on the command line.
Keyword Description (Default) Keyword Description (Default) -------------------------------------------------------------------------- USERID username/password FULL import entire file (N) BUFFER size of data buffer FROMUSER list of owner usernames FILE input files (EXPDAT.DMP) TOUSER list of usernames
SHOW just list file contents (N) TABLES list of table names