鸿 网 互 联 www.68idc.cn

当前位置 : 服务器租用 > 数据库 > oracle > >

使用可传输表空间将Oracle 9i升级到10g

来源:互联网 作者:佚名 时间:2012-09-27 18:36
1. 在Oracle 9i所在服务器上安装oracle 10g,并建库,创建用户scott,不创建用户表空间: SQL select * from v$version; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.1
1. 在Oracle 9i所在服务器上安装oracle 10g,并建库,创建用户scott,不创建用户表空间:
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod


PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
SQL> select tablespace_name,file_name,bytes/1024/1024 from dba_data_files;
TABLESPACE_NAME                FILE_NAME                                          BYTES/1024/1024
------------------------------ -------------------------------------------------- ---------------
SYSTEM                         /home/db/Oracle/oradata/mbs/MBS/datafile/o1_mf_sys             410
                               tem_80bnvf2j_.dbf
UNDOTBS1                       /home/db/Oracle/oradata/mbs/MBS/datafile/o1_mf_und             305
                               otbs1_80bnvm5g_.dbf
SYSAUX                         /home/db/Oracle/oradata/mbs/MBS/datafile/o1_mf_sys             130
                               aux_80bnvnr8_.dbf
SQL> create user scott identified by tiger;
User created.
SQL> grant dba to scott;
Grant succeeded.
2. 检查9i环境,确认需要传输的表空间是自包含的
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
PL/SQL Release 9.2.0.4.0 - Production
CORE    9.2.0.3.0       Production
TNS for Linux: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production
SQL> select tablespace_name,file_name,bytes/1024/1024 from dba_data_files;
TABLESPACE_NAME                FILE_NAME                                          BYTES/1024/1024
------------------------------ -------------------------------------------------- ---------------
SYSTEM                         /home/db/Oracle/oradata/mbs/system01.dbf                       325
UNDOTBS1                       /home/db/Oracle/oradata/mbs/undotbs01.dbf                      200
USERS                          /home/db/Oracle/oradata/mbs/users01.dbf                        100
SQL> select owner,table_name,tablespace_name from dba_tables where table_name='TEST';
OWNER                          TABLE_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------ ------------------------------
SYS                            TEST                           USERS
SCOTT                          TEST                           USERS
SQL> EXECUTE SYS.DBMS_TTS.TRANSPORT_SET_CHECK('users',TRUE,TRUE);
PL/SQL procedure successfully completed.
SQL> SELECT * FROM SYS.TRANSPORT_SET_VIOLATIONS;
VIOLATIONS
------------------------------------------------------------------------------------------------------------------------------------
Sys owned object  TEST in tablespace USERS not allowed in pluggable set
提示在users表空间中存在sys用户的表test,这不能包含在需要传输的表空间中。
将其删除:
SQL> drop table sys.test;
Table dropped.
SQL> EXECUTE SYS.DBMS_TTS.TRANSPORT_SET_CHECK('users',TRUE,TRUE);
PL/SQL procedure successfully completed.
SQL> SELECT * FROM SYS.TRANSPORT_SET_VIOLATIONS;
no rows selected
没有返回,代表在表空间users与其他表空间不存在依赖关系
3.导出表空间中的元数据
--首先将表空间users设为read only
SQL> alter tablespace users read only;
Tablespace altered.
--导出表空间users中表的元数据
[Oracle@rhel ~]$ exp \'/ as sysdba\' TRANSPORT_TABLESPACE=y TABLESPACES=(users) TTS_FULL_CHECK=y
Export: Release 9.2.0.4.0 - Production on Wed Jul 18 02:15:28 2012
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)
Note: table data (rows) will not be exported
About to export transportable tablespace metadata...
For tablespace USERS ...
. exporting cluster definitions
. exporting table definitions
. . exporting table                           TEST
. exporting referential integrity constraints
. exporting triggers
. end transportable tablespace metadata export
Export terminated successfully without warnings.
4. 导出数据库中其它对象,以full=y rows=n方式导出
[Oracle@rhel ~]$ exp SYSTEM/oracle FULL=y FILE=full.dmp ROWS=n statistics=none
Export: Release 9.2.0.4.0 - Production on Wed Jul 18 02:16:22 2012
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses ZHS16GBK character set (possible charset conversion)
Note: table data (rows) will not be exported
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions
. exporting system procedural objects and actions
. exporting pre-schema procedural objects and actions
. exporting cluster definitions
. about to export SYSTEM's tables via Conventional Path ...
. . exporting table            AQ$_INTERNET_AGENTS
. . exporting table       AQ$_INTERNET_AGENT_PRIVS
. . exporting table                    DEF$_AQCALL
. . exporting table                   DEF$_AQERROR
. . exporting table                  DEF$_CALLDEST
. . exporting table               DEF$_DEFAULTDEST
. . exporting table               DEF$_DESTINATION
. . exporting table                     DEF$_ERROR
. . exporting table                       DEF$_LOB
. . exporting table                    DEF$_ORIGIN
. . exporting table                DEF$_PROPAGATOR
. . exporting table       DEF$_PUSHED_TRANSACTIONS
. . exporting table                  DEF$_TEMP$LOB
. . exporting table       LOGSTDBY$APPLY_MILESTONE
. . exporting table        LOGSTDBY$APPLY_PROGRESS
. . exporting table                LOGSTDBY$EVENTS
. . exporting table            LOGSTDBY$PARAMETERS
. . exporting table                 LOGSTDBY$PLSQL
. . exporting table                   LOGSTDBY$SCN
. . exporting table                  LOGSTDBY$SKIP
. . exporting table      LOGSTDBY$SKIP_TRANSACTION
. . exporting table        REPCAT$_AUDIT_ATTRIBUTE
. . exporting table           REPCAT$_AUDIT_COLUMN
. . exporting table           REPCAT$_COLUMN_GROUP
. . exporting table               REPCAT$_CONFLICT
. . exporting table                    REPCAT$_DDL
. . exporting table             REPCAT$_EXCEPTIONS
. . exporting table              REPCAT$_EXTENSION
. . exporting table                REPCAT$_FLAVORS
. . exporting table         REPCAT$_FLAVOR_OBJECTS
. . exporting table              REPCAT$_GENERATED
. . exporting table         REPCAT$_GROUPED_COLUMN
. . exporting table      REPCAT$_INSTANTIATION_DDL
. . exporting table            REPCAT$_KEY_COLUMNS
. . exporting table           REPCAT$_OBJECT_PARMS
. . exporting table           REPCAT$_OBJECT_TYPES
. . exporting table       REPCAT$_PARAMETER_COLUMN
. . exporting table               REPCAT$_PRIORITY
. . exporting table         REPCAT$_PRIORITY_GROUP
. . exporting table      REPCAT$_REFRESH_TEMPLATES
. . exporting table                 REPCAT$_REPCAT
. . exporting table              REPCAT$_REPCATLOG
. . exporting table              REPCAT$_REPCOLUMN
. . exporting table         REPCAT$_REPGROUP_PRIVS
. . exporting table              REPCAT$_REPOBJECT
. . exporting table                REPCAT$_REPPROP
. . exporting table              REPCAT$_REPSCHEMA
. . exporting table             REPCAT$_RESOLUTION
. . exporting table      REPCAT$_RESOLUTION_METHOD
. . exporting table  REPCAT$_RESOLUTION_STATISTICS
. . exporting table    REPCAT$_RESOL_STATS_CONTROL
. . exporting table          REPCAT$_RUNTIME_PARMS
. . exporting table              REPCAT$_SITES_NEW
. . exporting table           REPCAT$_SITE_OBJECTS
. . exporting table              REPCAT$_SNAPGROUP
. . exporting table       REPCAT$_TEMPLATE_OBJECTS
. . exporting table         REPCAT$_TEMPLATE_PARMS
. . exporting table     REPCAT$_TEMPLATE_REFGROUPS
. . exporting table         REPCAT$_TEMPLATE_SITES
. . exporting table        REPCAT$_TEMPLATE_STATUS
. . exporting table       REPCAT$_TEMPLATE_TARGETS
. . exporting table         REPCAT$_TEMPLATE_TYPES
. . exporting table    REPCAT$_USER_AUTHORIZATIONS
. . exporting table       REPCAT$_USER_PARM_VALUES
. . exporting table        SQLPLUS_PRODUCT_PROFILE
. about to export OUTLN's tables via Conventional Path ...
. . exporting table                            OL$
. . exporting table                       OL$HINTS
. . exporting table                       OL$NODES
. about to export DBSNMP's tables via Conventional Path ...
. about to export SCOTT's tables via Conventional Path ...
. . exporting table                           TEST
. exporting synonyms
. exporting views
. exporting referential integrity constraints
. exporting stored procedures
. exporting operators
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting triggers
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting user history table
. exporting default and system auditing options
. exporting statistics
Export terminated successfully without warnings.
5.将表空间及数据库其它对象导入
[Oracle@rhel ~]$imp \'/ as sysdba\' TRANSPORT_TABLESPACE=y FILE=expdat.dmp DATAFILES=('/home/db/oracle/oradata/mbs/users01.dbf')
[Oracle@rhel ~]$ imp \'/ as sysdba\' FILE=full.dmp ignore=y full=y
Import: Release 10.2.0.1.0 - Production on Wed Jul 18 02:23:19 2012
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V09.02.00 via conventional path
Warning: the objects were exported by SYSTEM, not by you
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses ZHS16GBK character set (possible charset conversion)
. importing SYSTEM's objects into SYSTEM
IMP-00017: following statement failed with Oracle error 1119:
"CREATE TEMPORARY TABLESPACE "TEMPTS1" BLOCKSIZE 8192 TEMPFILE  '/home/db/or"
"acle/oradata/mbs/temp01.dbf' SIZE 20971520       EXTENT MANAGEMENT LOCAL  U"
"NIFORM. SIZE 1048576"
IMP-00003: Oracle error 1119 encountered
ORA-01119: error in creating database file '/home/db/Oracle/oradata/mbs/temp01.dbf'
ORA-27038: created file already exists
Additional information: 1
IMP-00017: following statement failed with Oracle error 959:
"ALTER USER "SYS" IDENTIFIED BY VALUES '8A8F025737A9097A' TEMPORARY TABLESPA"
"CE "TEMPTS1""
IMP-00003: Oracle error 959 encountered
ORA-00959: tablespace 'TEMPTS1' does not exist
IMP-00017: following statement failed with Oracle error 959:
"ALTER USER "SYSTEM" IDENTIFIED BY VALUES '2D594E86F93B17A1' TEMPORARY TABLE"
"SPACE "TEMPTS1""
IMP-00003: Oracle error 959 encountered
ORA-00959: tablespace 'TEMPTS1' does not exist
IMP-00061: Warning: Object type "SYSTEM"."REPCAT$_OBJECT_NULL_VECTOR" already exists with a different identifier
"CREATE TYPE "REPCAT$_OBJECT_NULL_VECTOR" TIMESTAMP '2012-07-18:01:24:33' OI"
"D 'C509B28C83DBA46FE040007F0100762C'          AS OBJECT"
"("
"  -- type owner, name, hashcode for the type represented by null_vector"
"  type_owner      VARCHAR2(30),"
"  type_name       VARCHAR2(30),"
"  type_hashcode   RAW(17),"
"  -- null_vector for a particular object instance"
"  -- ROBJ REVISIT: should only contain the null image, and not version#"
"  null_vector     RAW(2000)"
")"
. importing SYS's objects into SYS
. importing SYSTEM's objects into SYSTEM
. importing SYS's objects into SYS
. importing SYSTEM's objects into SYSTEM
. importing OUTLN's objects into OUTLN
. importing DBSNMP's objects into DBSNMP
. importing SCOTT's objects into SCOTT
. importing SYSTEM's objects into SYSTEM
. importing SYS's objects into SYS
. importing SYSTEM's objects into SYSTEM
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_AUDIT_ATTRIBUTE" ADD CONSTRAINT "REPCAT$_AUDIT_ATTRIBU"
"TE_C1" CHECK ((data_type_id in (2, 4, 5, 6, 7) and"
"                  data_length is not null)"
"              or (data_type_id not in (2, 4, 5, 6, 7) and"
"                  data_length is null)"
"                 ) ENABLE NOVALIDATE"
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_CONFLICT" ADD CONSTRAINT "REPCAT$_CONFLICT_C1" CHECK ("
"conflict_type_id in (1, 2, 3)) ENABLE NOVALIDATE"
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_EXTENSION" ADD CONSTRAINT "REPCAT$_EXTENSION_CODE" CHE"
"CK (extension_code IN (0)) ENABLE NOVALIDATE"
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_EXTENSION" ADD CONSTRAINT "REPCAT$_EXTENSION_EXPORTREQ"
"" CHECK (export_required IN ('Y', 'N')) ENABLE NOVALIDATE"
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_EXTENSION" ADD CONSTRAINT "REPCAT$_EXTENSION_STATUS" C"
"HECK (extension_status IN (0, 1, 2, 3, 4)) ENABLE NOVALIDATE"
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_EXTENSION" ADD CONSTRAINT "REPCAT$_EXTENSION_PUSH_TO_M"
"DEF" CHECK (push_to_mdef IN ('Y', 'N')) ENABLE NOVALIDATE"
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_EXTENSION" ADD CONSTRAINT "REPCAT$_EXTENSION_PUSH_TO_N"
"EW" CHECK (push_to_new IN ('Y', 'N')) ENABLE NOVALIDATE"
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_FLAVORS" ADD CONSTRAINT "REPCAT$_FLAVORS_C2" CHECK (pu"
"blished is NULL or (published in ('Y','N','O'))) ENABLE NOVALIDATE"
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_FLAVOR_OBJECTS" ADD CONSTRAINT "REPCAT$_FLAVOR_OBJECTS"
"_VERSION" CHECK (version# >= 0 AND version#
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_GENERATED" ADD CONSTRAINT "REPCAT$_GENERATED_OBJ" CHEC"
"K (reason IN (0, 1, 2, 3, 4, 5, 6, 7, 9, 10)) ENABLE NOVALIDATE"
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_PRIORITY_GROUP" ADD CONSTRAINT "REPCAT$_PRIORITY_GROUP"
"_C1" CHECK (data_type_id in (1, 2, 3, 4, 5, 6, 7)) ENABLE NOVALIDATE"
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_PRIORITY_GROUP" ADD CONSTRAINT "REPCAT$_PRIORITY_GROUP"
"_C2" CHECK ((data_type_id in (4, 7) and"
"                  fixed_data_length is not null)"
"              or (data_type_id in (1, 2, 3, 5, 6) and"
"                  fixed_data_length is null)) ENABLE NOVALIDATE"
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_REFRESH_TEMPLATES" ADD CONSTRAINT "REFRESH_TEMPLATES_C"
"1" CHECK ((public_template in ('Y','N'))"
"   or public_template is NULL) ENABLE NOVALIDATE"
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_REPCAT" ADD CONSTRAINT "REPCAT$_REPCAT_STATUS" CHECK ("
"status IN (0, 1, 2)) ENABLE NOVALIDATE"
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_REPCATLOG" ADD CONSTRAINT "REPCAT$_REPCATLOG_REQUEST" "
"CHECK (request IN (-1, 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10,"
"                                       11, 12, 13, 14, 15, 16, 17,"
"                                       18, 19, 20, 21, 22, 23, 24, 25)) ENA"
"BLE NOVALIDATE"
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_REPCATLOG" ADD CONSTRAINT "REPCAT$_REPCATLOG_TYPE" CHE"
"CK (type IN (-1, 0, 1, 2, 4, 5, 7, 8, 9, 11, 12, -3,"
"                                    13, 14, 32, 33)) ENABLE NOVALIDATE"
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_REPCATLOG" ADD CONSTRAINT "REPCAT$_REPCATLOG_STATUS" C"
"HECK (status IN (0, 1, 2, 3, 4)) ENABLE NOVALIDATE"
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_REPCOLUMN" ADD CONSTRAINT "REPCAT$_REPCOLUMN_VERSION" "
"CHECK (version# >= 0 AND version#
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_REPOBJECT" ADD CONSTRAINT "REPCAT$_REPOBJECT_TYPE" CHE"
"CK (type IN (-1, 1, 2, 4, 5, 7, 8, 9, 11, 12, -3,"
"                                      -4, 13, 14, 32, 33)) ENABLE NOVALIDAT"
"E"
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_REPOBJECT" ADD CONSTRAINT "REPCAT$_REPOBJECT_VERSION" "
"CHECK (version# >= 0 AND version#
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_REPOBJECT" ADD CONSTRAINT "REPCAT$_REPOBJECT_STATUS" C"
"HECK (status IN (0, 1, 2, 3, 4, 5, 6)) ENABLE NOVALIDATE"
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_REPOBJECT" ADD CONSTRAINT "REPCAT$_REPOBJECT_GENPACKAG"
"E" CHECK (genpackage IN (0, 1, 2)) ENABLE NOVALIDATE"
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_REPOBJECT" ADD CONSTRAINT "REPCAT$_REPOBJECT_GENTRIGGE"
"R" CHECK (gentrigger IN (0, 1, 2)) ENABLE NOVALIDATE"
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_REPPROP" ADD CONSTRAINT "REPCAT$_REPPROP_HOW" CHECK (h"
"ow IN (0, 1, 2, 3)) ENABLE NOVALIDATE"
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_SITES_NEW" ADD CONSTRAINT "REPCAT$_SITES_NEW_FULL_INST"
"" CHECK (full_instantiation IN ('Y', 'N')) ENABLE NOVALIDATE"
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_TEMPLATE_OBJECTS" ADD CONSTRAINT "REPCAT$_TEMPLATE_OBJ"
"ECTS_VER" CHECK (object_version# >= 0 AND object_version#
"OVALIDATE"
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_TEMPLATE_PARMS" ADD CONSTRAINT "REPCAT$_TEMPLATE_PARMS"
"_C1" CHECK (user_override in ('Y','N')) ENABLE NOVALIDATE"
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_TEMPLATE_SITES" ADD CONSTRAINT "REPCAT$_TEMPLATE_SITES"
"_C1" CHECK (status in (-100,-1,0,1)) ENABLE NOVALIDATE"
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
IMP-00017: following statement failed with Oracle error 2264:
"ALTER TABLE "REPCAT$_TEMPLATE_SITES" ADD CONSTRAINT "REPCAT$_TEMPLATE_SITES"
"_C2" CHECK ((site_name is not null and repapi_site_id is null) or"
"   (site_name is null and repapi_site_id is not null)) ENABLE NOVALIDATE"
IMP-00003: Oracle error 2264 encountered
ORA-02264: name already used by an existing constraint
. importing OUTLN's objects into OUTLN
. importing SCOTT's objects into SCOTT
. importing SYSTEM's objects into SYSTEM
. importing SYS's objects into SYS
. importing SYSTEM's objects into SYSTEM
. importing SYS's objects into SYS
. importing SYSTEM's objects into SYSTEM
. importing SYS's objects into SYS
. importing SYSTEM's objects into SYSTEM
. importing SYS's objects into SYS
. importing SYSTEM's objects into SYSTEM
. importing SYS's objects into SYS
. importing SYSTEM's objects into SYSTEM
. importing SYS's objects into SYS
. importing SYSTEM's objects into SYSTEM
. importing SYS's objects into SYS
. importing SYSTEM's objects into SYSTEM
. importing OUTLN's objects into OUTLN
. importing SYSTEM's objects into SYSTEM
. importing OUTLN's objects into OUTLN
. importing SYSTEM's objects into SYSTEM
. importing OUTLN's objects into OUTLN
. importing SYSTEM's objects into SYSTEM
. importing SYS's objects into SYS
. importing SYSTEM's objects into SYSTEM
About to enable constraints...
Import terminated successfully with warnings.
6.编译失效对象
SQL> @?/rdbms/admin/utlrp.sql
SQL> select owner,object_name,object_type,status from dba_objects where status 'VALID';
no rows selected
7.确认数据已经被导入到10g
SQL> select tablespace_name,file_name,bytes/1024/1024 from dba_data_files;
TABLESPACE_NAME                FILE_NAME                                          BYTES/1024/1024
------------------------------ -------------------------------------------------- ---------------
SYSTEM                         /home/db/Oracle/oradata/mbs/MBS/datafile/o1_mf_sys             410
                               tem_80bnvf2j_.dbf
UNDOTBS1                       /home/db/Oracle/oradata/mbs/MBS/datafile/o1_mf_und             305
                               otbs1_80bnvm5g_.dbf
SYSAUX                         /home/db/Oracle/oradata/mbs/MBS/datafile/o1_mf_sys             140
                               aux_80bnvnr8_.dbf
USERS                          /home/db/Oracle/oradata/mbs/users01.dbf                        100
SQL> select count(*) from scott.test;
  COUNT(*)
----------
      5786
网友评论
<