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

核心提示： BUFFER size of data buffer OWNER list of owner usernames FILE output file (EXPDAT.DMP) TABLES list of table names COMPRESS import into one extent

BUFFER size of data buffer OWNER list of owner usernames

FILE output file (EXPDAT.DMP) TABLES list of table names

COMPRESS import into one extent (Y) RECORDLENGTH length of IO record

GRANTS export grants (Y) INCTYPE incremental export type

INDEXES export indexes (Y) RECORD track incr. export (Y)

ROWS export data rows (Y) PARFILE parameter filename

CONSTRAINTS export constraints (Y) CONSISTENT cross-table consistency

LOG log file of screen output STATISTICS analyze objects (ESTIMATE)

DIRECT direct path (N)

FEEDBACK display progress every x rows (0)

POINT_IN_TIME_RECOVER Tablespace Point-in-time Recovery (N)

RECOVERY_TABLESPACES List of tablespace names to recover

VOLSIZE number of bytes to write to each tape volume

例：$exp userid=cwadmin/cwadmin tables=’(sys_cwxx,sys_menu)’ file=pzexport.dmp

2． 装库：

不带参数

$ cd $ORACLE_HOME/bin

$ imp

Username: cwadmin

Password:

Connected to: Oracle8 Enterprise Edition Release 8.0.4.0.0 - Production

PL/SQL Release 8.0.4.0.0 - Production

Import file: expdat.dmp > pzexdat.dmp

Enter insert buffer size (minimum is 4096) 30720> 10240

Export file created by EXPORT:V08.00.04 via conventional path

List contents of import file only (yes/no): no >

Ignore create error due to object existence (yes/no): no > y