安裝資料庫和資料庫解決問題

-------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------
imp匯出的時候包一堆這樣的錯誤，IMP-00017: following statement failed with ORACLE error 43854:
 "CREATE TABLE "T_CMS_REGION" ("REGIONID" NUMBER(19, 0) NOT NULL ENABLE, "REG"
 "IONCODE" VARCHAR2(32) NOT NULL ENABLE, "REGIONNAME" "SYS"."XMLTYPE" NOT NUL"
 "L ENABLE, "REGIONDESC" VARCHAR2(1024))  PCTFREE 10 PCTUSED 40 INITRANS 1 MA"
 "XTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREE"
 "LIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "TS_MDSP_DATA" LOGGING NOCOMP"
 "RESS XMLTYPE "REGIONNAME" STORE AS CLOB  (TABLESPACE "TS_MDSP_DATA" ENABLE "
 "STORAGE IN ROW CHUNK 8192 RETENTION AUTO NOCACHE LOGGING  NOCOMPRESS KEEP_D"
 "UPLICATES STORAGE(INITIAL 106496 NEXT 1048576 MINEXTENTS 1 BUFFER_POOL DEFA"
 "ULT))"
 --在手動管理的表空間上建立LOB時會報43854  需改為auto管理方式
----------------
exp匯出coredump的問題 可能是因為索引無效問題引起的
------------------------------------------------------------------------------------------------------
將資料庫檔案改為自動擴充套件
alter database datafile '/opt/oracle/db/oradata/orcl/zhaoqing1.dbf' autoextend on;
檢查dba_data_files autoextensible屬性為yes
-------------------------------------------------------------------------------------------------------
ORA-39143: dump file "/home/oracle/zm/data/sysdb.dmp" may be an original export dump file
這種錯誤發生在impdp匯入exp匯出的dmp檔案

-------------------------------------------------------------------------------------------------
修改oracle字符集
sqlplus /nolog
SQL> connect / as sysdba;
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter system enable restricted session;
SQL> alter system set job_queue_processes=0;
SQL> alter database open;
SQL> alter database character set ZHS16GBK;
SQL> shutdown immediate;
SQL> exit;

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/23205405/viewspace-735603/，如需轉載，請註明出處，否則將追究法律責任。