ora的导入与导出（Import and export of ora）.docVIP

ora的导入与导出（Import and export of ora） Import and export of ORACLE database Rows=n Implement a part of the table in a.Dmp file of IMP, and import only commands that data do not import table structures (table structures already exist): Imp, username/password@ORASVR, fromuser=username1, touser=username, file=e:\file.dmp, IGNORE=Y, TABLES= (table1, table2),...... ) Explain： Keyword description (default) IGNORE ignores creating errors (N) TABLES list of table names Reference material： Under CMD, enter imp help=y to get help from oracle. The imp help=y reads as follows: C:\Documents and Settings\shiliangshuaiimp help=y Import: Release .1 - Production on Tuesday, May 8, 11:58:39 2007 (c) Copyright 2001, Oracle, Corporation., All, rights, reserved. You can enter the IMP command and your username / password User name / password command: Routine: IMP SCOTT/TIGER Alternatively, you can control import by entering the IMP command and various parameters According to different parameters. To specify parameters, you can use keywords: Format: IMP, KEYWORD=value, or KEYWORD= (value1, Value2,..., vlaueN) Routines: IMP, SCOTT/TIGER, IGNORE=Y, TABLES= (EMP, DEPT) FULL=N Or TABLES= (T1:, P1, T1:, P2), if T1 is the partition table USERID must be the first parameter in the command line. Keyword description (default) keyword description (default) ----------------------------------------------------------------------- USERID user name / password FULL to import the entire file (N) BUFFER data buffer size, FROMUSER, all user name list FILE input file (EXPDAT.DMP) TOUSER user name list SHOW lists only the file contents (N) list of TABLES tables IGNORE ignores the length of the creation (N) RECORDLENGTH IO record GRANTS import permission (Y) INCTYPE incremental import type INDEXES import index (Y) COMMIT submits array insert (N) ROWS imports the data line (Y) PARFILE parameter file name LOG screen output log file CONSTRAINTS import restriction (Y) DESTROY covers tablespace data files (N) INDEXFILE