【正文】 52: Table SCOTT.DEPT exists. Data will be appended to existing table but all dependent metadata will be skipped due to table_exists_action of appendORA39152: Table SCOTT.EMP exists. Data will be appended to existing table but all dependent metadata will be skipped due to table_exists_action of appendProcessing object type TABLE_EXPORT/TABLE/TABLE_DATAORA31693: Table data object SCOTT.DEPT failed to load/unload and is being skipped due to error:ORA00001: unique constraint () violated. . imported SCOTT.EMP KB 14 rowsProcessing object type TABLE_EXPORT/TABLE/INDEX/INDEXProcessing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINTProcessing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICSProcessing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINTProcessing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICSJob APPS.SYS_IMPORT_FULL_01 pleted with 3 error(s) at 15:49:27SELECT COUNT(*) FROM EMP方法二CREATE TABLE ( EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10 BYTE), JOB VARCHAR2(9 BYTE), MGR NUMBER(4), HIREDATE DATE, SAL NUMBER(7,2), COMM NUMBER(7,2), DEPTNO NUMBER(2))TABLESPACE CUXIPARTITION BY RANGE(HIREDATE)(PARTITION EMP_P1 VALUES LESS THAN(TO_DATE(39。s objects into SCOTT. . importing table EMP 14 rows imported. . importing table DEPTIMP00019: row rejected due to ORACLE error 1IMP00003: ORACLE error 1 encounteredORA00001: unique constraint () violatedColumn 1 10Column 2 ACCOUNTINGColumn 3 NEW YORKIMP00019: row rejected due to ORACLE error 1IMP00003: ORACLE error 1 encounteredORA00001: unique constraint () violatedColumn 1 20Column 2 RESEARCHColumn 3 DALLASIMP00019: row rejected due to ORACLE error 1IMP00003: ORACLE error 1 encounteredORA00001: unique constraint () violatedColumn 1 30Column 2 SALESColumn 3 CHICAGOIMP00019: row rejected due to ORACLE error 1IMP00003: ORACLE error 1 encounteredORA00001: unique constraint () violatedColumn 1 40Column 2 OPERATIONSColumn 3 BOSTON 0 rows importedAbout to enable constraints...Import terminated successfully with warnings.測試此方法無法將index帶過來，還得繼續(xù)測試[ebststfinapp oracle]$ impdp apps/apps directory=DUMP dumpfile= logfile= table_exists_action=append PARALLEL=5。[ebststfinapp oracle]$ imp apps/apps file= log= fromuser=scott touser=scott buffer=100000000 ignore=y。EMP39。EMP39。EMP39。))。,39。如果分區(qū)不夠用，可進(jìn)行添加ALTER TABLE EMP_P ADD PARTITION EMP_P4 VALUES LESS THAN(TO_DATE(39。YYYYMMDD39。1990010139。YYYYMMDD39。1986010139。YYYYMMDD39。1983010139。[ebststfinapp ]$ exp apps/apps tables=, file=/u01/oracle/ log=/u01/oracle/ indexes=y constraints=y grants=y rows=y filesize=2G。[ebststfinapp db]$ expdp apps/apps directory=DUMP tables=, dumpfile= logfile= job_name=expdpemp parallel=5。Grant succeeded.SELECT PRIVILEGE, DIRECTORY_NAME, DIRECTORY_PATH FROM USER_TAB_PRIVS T, ALL_DIRECTORIES DWHERE (+) = ORDER BY 2, 1。/u01/oracle/39。GRANT DELETE, INSERT, SELECT, UPDATE ON TO PUBLIC。PRESIDENT39。ANALYST39。MANAGER39。SALESMAN39。CLERK39。end。普通表轉(zhuǎn)分區(qū)表方法一、行數(shù)如果存在long、raw long類型無法進(jìn)行分區(qū)表SELECT COUNT(*) FROM EMPF4鍵CREATE TABLE ( EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10 BYTE), JOB VARCHAR2(9 BYTE), MGR NUMBER(4), HIREDATE DATE, SAL NUMBER(7,2), COMM NUMBER(7,2), DEPTNO NUMBER(2))TABLESPACE SYSTE