使用可传输表空间将Oracle 9i升级到10g
使用可传输表空间将Oracle 9i升级到10g
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
评论暂时关闭