Oracle DBA的工作列表上写了些什么

核心提示： Import grants (yes/no):yes > y Import table data (yes/no):yes >y Import entire export file (yes/no):no >y import 工作开始自动进行最终出现： Import te

Import grants (yes/no):yes > y

Import table data (yes/no):yes >y

Import entire export file (yes/no):no >y

import 工作开始自动进行最终出现：

Import terminated successfully with warnings.

带参数，可选参数如下（可用imp help=y 得到）：

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 file (EXPDAT.DMP) TOUSER list of usernames

SHOW just list file contents (N) TABLES list of table names

IGNORE ignore create errors (N) RECORDLENGTH length of IO record

GRANTS import grants (Y) INCTYPE incremental import type

INDEXES import indexes (Y) COMMIT commit array insert (N)

ROWS import data rows (Y) PARFILE parameter filename

LOG log file of screen output

DESTROY overwrite tablespace data file (N)

INDEXFILE write table/index info to specified file

CHARSET character set of export file (NLS_LANG)

POINT_IN_TIME_RECOVER Tablespace Point-in-time Recovery (N)

SKIP_UNUSABLE_INDEXES skip maintenance of unusable indexes (N)

ANALYZE execute ANALYZE statements in dump file (Y)

FEEDBACK display progress every x rows(0)